[B! MySQL][python] beth321ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

beth321 id:beth321

MySQLã¨pythonã«é–¢ã™ã‚‹beth321ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (7)

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

${{author_name}}$
{{author_name}}{{created}}
{{ #comment }}{{ comment }}{{ /comment }}
- {{ label }}

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

ISUCON4 äºˆé¸ã§ workload=5 ã§ 88000ç‚¹å‡ºã™æ–¹æ³• (lily white å‚æˆ¦è¨˜) : DSASé–‹ç™ºè€…ã®éƒ¨å±‹
ISUCON4 äºˆé¸1æ—¥ç›®ã«ã€ lily white ã¨ã„ã†ãƒãƒ¼ãƒ ã§å‚æˆ¦ã—ã¦ãã¾ã—ãŸã€‚ è©¦åˆä¸ã« 62000 ç‚¹ã¯å‡ºã—ã¦ã„ãŸã®ã§ã™ãŒã€æœ€çµ‚çš„ã«æå‡ºã—ãŸã‚¹ã‚³ã‚¢ã¯ 60344 ç‚¹ã§ã—ãŸã€‚ ä»¥é™ã€äºˆé¸çµ‚äº†ã¾ã§ã¨ã€ãã®å¾Œã«æ°—ã¥ã„ãŸã•ã‚‰ã«ã‚¹ã‚³ã‚¢ã‚’ä¸Šã’ã‚‹æ–¹æ³•ã«ã¤ã„ã¦æ›¸ã„ã¦ã„ãã¾ã™ã€‚ å®Ÿéš›ã®æå‡ºæ™‚ã®ã‚³ãƒ¼ãƒ‰ã¯ methane/isucon4q-go ãƒªãƒã‚¸ãƒˆãƒªã® "final" ã‚¿ã‚°ã‚’è¦‹ã¦ãã ã•ã„ã€‚ æº–å‚™ (~å‰æ—¥) äºˆé¸æ–¹å¼ãŒç™ºè¡¨ã•ã‚ŒãŸæ™‚ç‚¹ã§ã€ isucon3 äºˆé¸ã¨åŒã˜æ–¹å¼ã ã£ãŸã®ã§ã€æœ‰åŠ¹ãªä½œæˆ¦ã‚‚ã»ã¼åŒã˜ã«ãªã‚‹äº‹ãŒäºˆæ¸¬ã§ãã¾ã—ãŸã€‚ å…·ä½“çš„ã«ã¯ä»¥ä¸‹ã®ã¨ãŠã‚Šã§ã™ã€‚ PIOPS ãª EBS ã‚’ä½¿ã‚ãªã„ã®ã§ã€æ€§èƒ½ãŒä¸å®‰å®šãªãƒ‡ã‚£ã‚¹ã‚¯ãŒãƒãƒƒã‚¯ã«ãªã‚‹å•é¡Œã¯ç„¡ã„ã§ã—ã‚‡ã†ã€‚ 1ã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹ã®ã¿ã‚’ä½¿ã†ã¨ã„ã†ã“ã¨ã‹ã‚‰ã€ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯å¸¯åŸŸãŒãƒãƒƒã‚¯ã«ãªã‚‹å¯èƒ½æ€§ã‚‚ç„¡ã„ã¯ãšã§ã™ã€‚ ã»ã¼ç¢ºå®Ÿã« CPU ãƒãƒƒã‚¯ãªå•é¡ŒãŒå‡ºã‚‹ã¯ãšã§ã™ã€‚ ã‚¢
beth321 2014/09/29
MySQL

ãƒ†ã‚¯ãƒŽãƒã‚¸ãƒ¼

isucon4

isucon

CPU

golang

python

go

infrastructure

performance
ãƒªãƒ³ã‚¯
Pythonã¦ã‚™ã¯ã—ã‚™ã‚ã‚‹é‡Žçƒãƒ•ã‚šãƒã‚¯ã‚™ãƒ©ãƒŸãƒ³ã‚¯ã‚™ PyCon JP 2014 9/14 Talk Session
Pycon JP 2014ç™ºè¡¨è³‡æ–™ã§ã™ã€‚ ãƒ”ã‚¿ã‚´ãƒ©ã‚¹å‹çŽ‡ã¨BABIPã«ã¤ã„ã¦ã€Djangoä»–ã§å¯è¦–åŒ–ã—ã¾ã—ãŸã€‚
beth321 2014/09/22
MySQL

(ä»®)

programming

ã‚¢ãƒ—ãƒª

ä»•äº‹

twitter

ã¾ã¨ã‚

python

baseball

åå‰
ãƒªãƒ³ã‚¯
[MySQL][Python]8000ä¸‡ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’Insertã™ã‚‹ | Momentum
æ¦‚è¦ ãƒ»ã¨ã‚ã‚‹ç‰©ä»¶ã§8000ä¸‡å¼±ã®ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’æ–°è¦ã®DBã«åŠ¹çŽ‡çš„ã«ã¶ã¡è¾¼ã‚€æ–¹æ³•ã‚’è€ƒãˆã‚‹å¿…è¦ã« ãƒ»MySQL(Amazon RDS) + Python(mysql.connector)ã‚’æƒ³å®š ãƒ»mysql.connector + pythonã«ã¤ã„ã¦ã¯æ‹™æ–‡ãªãŒã‚‰(http://nekopuni.holy.jp/?p=927)ã«æ›¸ã„ã¦ãŠã‚Šã¾ã™ã€‚ ãƒ»ã‚³ãƒŸãƒƒãƒˆã®ä½ç½®ã«ã¯æ°—ã‚’ã¤ã‘ã‚ˆã† + Multiple Insertæœ€å¼·ãã¨ã„ã†ãŠè©±ã€‚ æ–¹æ³•ãã®1 ã¾ãšã¯æœ€åˆã«ã‚„ã£ãŸæ–¹æ³•ã€‚1ãƒ¬ã‚³ãƒ¼ãƒ‰ã”ã¨ã«Insertã—ã¦ã‚³ãƒŸãƒƒãƒˆã—ã¦ã„ãæ–¹æ³•ã€‚ ä»Šã¾ã§DBé–¢é€£ã§ã‚„ã£ãŸã‚³ãƒ¼ãƒ‰ã¯ãƒ¬ã‚³ãƒ¼ãƒ‰é‡ã‚‚å¤§ã—ãŸã“ã¨ãªã‹ã£ãŸã®ã§ä»¥ä¸‹ã®æ–¹æ³•ã§ã‚‚ç‰¹ã«å•é¡Œãªã‹ã£ãŸã€‚ å…·ä½“çš„ãªç’°å¢ƒã¨ã—ã¦ã¯ãƒ†ã‚ã‚¹ãƒˆãƒ‡ãƒ¼ã‚¿(csv)ã‚’èªã¿è¾¼ã¿ã€ãã‚Œã‚’DBã«Insertã—ã¦ã„ãã¨ã„ã†ã‚‚ã®ã€‚ csvã®ä¸èº«ã¯æ—¥ä»˜(DATE)ã¨ãƒ‡ãƒ¼ã‚¿å€¤(VALUE)ãŒã‚«ãƒ³ãƒžåŒºåˆ‡ã‚Šã«ãªã£ã¦ã„
beth321 2014/05/04
()

MySQL

**

*dev

mysql

python

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

sql

db
ãƒªãƒ³ã‚¯
Pythonã§ä½œã‚‰ã‚ŒãŸä¾¿åˆ©ãªã‚³ãƒžãƒ³ãƒ‰ãƒ©ã‚¤ãƒ³ãƒ„ãƒ¼ãƒ« MySQL Utilities | ãƒ¢ãƒ‡ãƒªãƒ³ã‚°ãƒ„ãƒ¼ãƒ«ã‹ã‚‰ç®¡ç†ãƒ»é–‹ç™ºçµ±åˆç’°å¢ƒã«é€²åŒ–ã—ãŸMySQL Workbench 6.0 | Think ITï¼ˆã‚·ãƒ³ã‚¯ã‚¤ãƒƒãƒˆï¼‰
ã€Œã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã¯IT ã‚³ãƒ³ã‚µãƒ«ã‚¿ãƒ³ãƒˆã¸ã®è»¢è·ã§å¹¸ã›ã«ãªã‚Œã‚‹ã®ã‹ï¼Ÿã€ãƒ¼è©•ä¾¡ãƒ»å¹´åŽãƒ»ã‚ãƒ£ãƒªã‚¢ãƒ¼å¾¹åº•è§£èª¬ 3æœˆ4æ—¥ 6:30
beth321 2014/02/11
MySQL

MySQL

python

DB

shell

tool

util

MyInterest

musql

web
ãƒªãƒ³ã‚¯
Dropbox ã®ã‚¹ã‚±ãƒ¼ãƒ«ã¨ã‹
Python ãªã‚µãƒ¼ãƒ“ã‚¹ ã¿ã‚“ãªå¤§å¥½ã Dropbox ã®ã‚¹ã‚±ãƒ¼ãƒ«ã¨ã‹ãƒ¡ãƒ¢ã€‚ä»¥ä¸‹ã®ãƒšãƒ¼ã‚¸è¾ºã‚Šã‹ã‚‰ãƒ”ãƒƒã‚¯ã‚¢ãƒƒãƒ—ã€‚Parted? ã¿ãŸã„ãªã®ã§ã€ç¶šç·¨ãŒã§ãŸã‚‰è¿½è¨˜ã™ã‚‹ã‹ã‚‚ã€‚ Scaling lessons learned at Dropbox, part 1 (comment) Dropbox - Startup Lessons Learned (slideshare) Dropbox -Yã‚³ãƒ³ãƒ“ãƒãƒ¼ã‚¿ãƒ¼ãŒç”Ÿã‚“ã ã‚¹ã‚¿ãƒ¼ãƒˆã‚¢ãƒƒãƒ—ã®è»Œè·¡ã¨æœªæ¥ - ã‚¹ã‚±ãƒ¼ãƒ«é–¢ä¿‚ãªã„ã§ã™ãŒã€2006 å¹´å½“æ™‚ã¯ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚µãƒ¼ãƒ“ã‚¹ãŒã„ã£ã±ã„ã‚ã£ãŸã‚ˆã†ã§ã€VC ã‹ã‚‰è³‡é‡‘èª¿é”ã—ãŸã¨ãã®ã‚„ã‚Šå–ã‚ŠãŒãŠã‚‚ã—ã‚ã„ VC "ã‚¯ãƒ©ã‚¦ãƒ‰ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚µãƒ¼ãƒ“ã‚¹ãªã‚“ã¦è…ã‚‹ã»ã©ã‚ã‚‹" Drew "ãªã«ã‹ä½¿ã£ã¦ã‚‹ã®ã‚ã‚Šã¾ã™ã‹ï¼Ÿ" VC "NO" Drew "..." å®Œç’§ã§ã€ã‚¹ã‚±ãƒ¼ãƒ©ãƒ–ãƒ«ã§ã€ã‚¯ãƒã‚¹ãƒ—ãƒ©ãƒƒãƒˆãƒ•ã‚©ãƒ¼ãƒ ãªã‚¯ãƒ©ã‚¦ãƒ‰ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ï¼å½“æ™‚ã€ãƒ—
beth321 2012/07/18
c

MySQL

*ã‚ã¨ã§èªã‚€

dropbox

Python

Webã‚µãƒ¼ãƒ“ã‚¹

development

è¨è¨ˆ

architecture

performance
ãƒªãƒ³ã‚¯
Rubyã®ä¼šç¤¾ã§PythonistaãŒ3ãƒ¶æœˆç”Ÿãå»¶ã³ãŸè©±
ML Ops NYC 19 & Strata Data Conference 2019 NewYork æ³¨ç›®ã‚»ãƒƒã‚·ãƒ§ãƒ³ã¾ã¨ã‚
beth321 2012/05/10
ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ

ruby

MySQL

ruby

python

ãƒ‰ãƒªã‚³ãƒ

slide

**Society

***Technology

ã‚ã¨ã§èªã‚€
ãƒªãƒ³ã‚¯
LAMPã¯æ»ã«GUNDAM (Github Ubuntu Node Dropbox AWS MongDB)ã®æ™‚ä»£ã¸ - W3DDD
ã‚¯ãƒ©ã‚¦ãƒ‰Webã‚µãƒ¼ãƒ“ã‚¹æ™‚ä»£ã¯ GUNDAM (Github Ubuntu Node Dropbox AWS MongDB) ã ï¼ï¼ ãŠã„ï¼ãŠã„ãŠã„ï¼ã€ŒLAMPçµŒé¨“è€…å‹Ÿé›†ã—ã¦ã¾ã™ã€ã£ã¦ãŠã„ï¼ã‚‚ã†2012å¹´ã ãžï¼ã‚‚ã£ã¨ãƒŠã‚¦ã„æ„Ÿã˜ã®ãŒã‚ã‚‹ã ã‚ï¼ï¼ã‚¯ãƒ©ã‚¦ãƒ‰Webã‚µãƒ¼ãƒ“ã‚¹æ™‚ä»£ã¯ GUNDAM(Github Ubuntu Node Dropbox AWS MongDB)ã ï¼ï¼ã€ŒLAMPçµŒé¨“ã¯ï¼Ÿã€ã€Œä¿ºãŒGUNDAMã ï¼ã€â€” Wataru MIYAGUNIã•ã‚“ (@gongoZ) 3æœˆ 12, 2012 LAMP (Linux Apache MySQL Perl-PHP-Python)ã®æ¬¡ã®æŠ€è¡“ã®ç·ç§°ã¯GUNDAMã¨ã„ã†è¨€è‘‰ã¨ã—ã¦janos,num,lnnmãªã©ã‚ã£ãŸã‚ˆã†ã§ã™ãŒ ä»Šã²ã¨ã¤æ™®åŠã—ãªã„æ„Ÿã˜ãŒã‚ã‚Šã¾ã—ãŸã€‚ ã—ã‹ã—"GUNDAM"ã¨ã„ã†è¨€è‘‰ã¯æ™®åŠã—ãã†ã§ã™ãï¼ˆãƒã‚¿çš„ã«ã‚‚ã„ã„ã®ã§ï¼‰ LAMPã¨ã„ã†è¨€
beth321 2012/03/13
AWS

MySQL

GUNDAM

dropbox

Ubuntu

node.js

github

Python

aws

linux
ãƒªãƒ³ã‚¯
1