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

shogo4405 id:shogo4405

MySQLã«é–¢ã™ã‚‹shogo4405ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (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}}

(ç‰¹ã«MyISAMã‚’ä½¿ã£ã¦ã„ãŸ)ã‚¦ã‚§ãƒ–å±‹ã•ã‚“ãŒInnoDBã‚’ä½¿ã†å ´åˆã®è¨å®šé …ç›® - kazuhoã®ãƒ¡ãƒ¢ç½®ãå ´
InnoDBã¯MyISAMã¨æ¯”è¼ƒã—ã¦å®‰å…¨(OSã‚¯ãƒ©ãƒƒã‚·ãƒ¥ã‚„é›»æºæ–ãŒç™ºç”Ÿã—ã¦ã‚‚ãƒ†ãƒ¼ãƒ–ãƒ«ãŒå£Šã‚Œãªã„)åˆ†ã€æ›¸ãè¾¼ã¿ãŒé…ã„ã€‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å±‹ã•ã‚“ã‹ã‚‰ã™ã‚‹ã¨ã€ãã‚Œã¯å½“ç„¶ã®ã“ã¨ã§MyISAMãŒãŠã‹ã—ã„ã‚“ã ã€ã¨ã„ã†ã“ã¨ã«ãªã‚Šã€ã ã‹ã‚‰ãƒãƒƒãƒ†ãƒªãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—æ©Ÿèƒ½ã®ã¤ã„ãŸRAIDã‚«ãƒ¼ãƒ‰ã‚’ä½¿ã†ã‚“ã ã€ã¨ã„ã†è©±ã«ãªã‚‹ã€‚ã§ã‚‚ã€MyISAMã‚’ä½¿ã£ã¦ã„ã‚‹ã‚¦ã‚§ãƒ–å±‹ã•ã‚“ã®ç¾å ´ã§ã¯ã€å ´åˆã«ã‚ˆã£ã¦å¤šå°‘ãƒ‡ãƒ¼ã‚¿ãŒæ¶ˆãˆã¦ã‚‚ã‹ã¾ã‚ãªã„ã‹ã‚‰ã€å®‰ã„ãƒãƒ¼ãƒ‰ã‚¦ã‚§ã‚¢ã§å¤§é‡ã®ã‚¢ã‚¯ã‚»ã‚¹ã‚’æŒããŸã„... ã£ã¦ä¹–é›¢ãŒã‚ã‚‹ã‚“ã˜ã‚ƒãªã„ã‹ãªãƒ¼ã¨æ€ã£ã¦ã‚‹ã€‚ ãã®ã‚ˆã†ãªå ´åˆã«ã¯ã€my.cnf ã® innodb_flush_log_at_trx_commit ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã‚’èª¿æ•´ã™ã‚‹ã“ã¨ã§ã€MyISAMã«æ¯”è‚©ã™ã‚‹æ›¸ãè¾¼ã¿é€Ÿåº¦ã‚’å¾—ã‚‹ã“ã¨ãŒã§ãã‚‹(ãã®ã‹ã‚ã‚Šã€ã‚¯ãƒ©ãƒƒã‚·ãƒ¥ã‚„é›»æºæ–ã®å ´åˆã¯ã€è¨å®šã«ã‚ˆã£ã¦ç›´è¿‘ï¼‘ç§’ä»¥å†…ã®å¤‰æ›´ãŒå¤±ã‚ã‚Œã‚‹)ã€‚ ä»–ã®ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã‚‚å«ã‚ã¦æ›¸ã„ã¦ãŠãã¨ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼
shogo4405 2009/11/03
MySQL

MyISAM
ãƒªãƒ³ã‚¯
ï¼»é€Ÿå ±ï¼½Amazonã‚¯ãƒ©ã‚¦ãƒ‰ãŒMySQLã‚µãƒ¼ãƒ“ã‚¹é–‹å§‹ã€ãƒ‘ãƒƒãƒã‚‚ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚‚ãŠã¾ã‹ã›
Amazon Web ServicesãŒã‚¯ãƒ©ã‚¦ãƒ‰ä¸Šã§MySQLã‚’ãƒ›ã‚¹ãƒ†ã‚£ãƒ³ã‚°ã™ã‚‹ã€ŒAmazon Relational Database Service (Amazon RDS)ã€ã®Î²å…¬é–‹ã‚’é–‹å§‹ã—ã¾ã—ãŸã€‚ ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ä¸è¦ã§MySQLã®åˆ©ç”¨ã‚’é–‹å§‹ã§ãã€ãƒ‘ãƒƒãƒå½“ã¦ã‚„ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ãªã©ã‚‚Amazonã‚¯ãƒ©ã‚¦ãƒ‰å´ã§å®Ÿè¡Œã—ã¦ãã‚Œã‚‹ãŸã‚ã€MySQLã®å°Žå…¥ã‚„é‹ç”¨ã®æ‰‹é–“ã‚’å¤§å¹…ã«å‰Šæ¸›å¯èƒ½ã§ã™ã€‚ MySQLã®ã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹ã¯è¦æ¨¡ã«å¿œã˜ã¦5ç¨®é¡žãŒç”¨æ„ã•ã‚Œã¦ã„ã¾ã™ã€‚ Small DB Instance : ï¼ˆ1æ™‚é–“ã‚ãŸã‚Š0.11ãƒ‰ãƒ«ï¼‰ 1.7 GB memory, 1 ECU (1 virtual core with 1 ECU), 64-bit platform Large DB Instance : ï¼ˆ1æ™‚é–“ã‚ãŸã‚Š0.44ãƒ‰ãƒ«ï¼‰ 7.5 GB memory, 4 ECUs (2 virtual cores with
shogo4405 2009/11/03
Amazon

MySQL
ãƒªãƒ³ã‚¯
MySQLãŒãƒ•ã‚©ãƒ¼ã‚¯ã‹ã€ã‚ªãƒ¼ãƒ—ãƒ³ã‚¢ãƒ©ã‚¤ã‚¢ãƒ³ã‚¹ãŒèª•ç”Ÿ ï¼ ï¼ IT
2009/05/14 ã‚ªãƒ©ã‚¯ãƒ«ã«ã‚ˆã‚‹ã‚µãƒ³ãƒ»ãƒžã‚¤ã‚¯ãƒã‚·ã‚¹ãƒ†ãƒ ã‚ºè²·åŽã§æ³¨ç›®ãŒé›†ã¾ã‚‹OSSãƒ—ãƒãƒ€ã‚¯ãƒˆã®1ã¤ã€ŒMySQLã€ã«ç•°å¤‰ãŒèµ·ãã¦ã„ã‚‹ã€‚MySQLã®ã‚ªãƒªã‚¸ãƒŠãƒ«é–‹ç™ºè€…ã§å‰µæ¥è€…ã§ã‚‚ã‚ã‚‹ãƒžã‚¤ã‚±ãƒ«ãƒ»ã‚¦ã‚£ãƒ‡ãƒ‹ã‚¦ã‚¹ï¼ˆMichael Wideniusï¼‰æ°ã¯5æœˆ13æ—¥ã€ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ãƒ™ãƒ¼ã‚¹ã§MySQLé–¢é€£ã®é–‹ç™ºã‚„ã‚µãƒãƒ¼ãƒˆã‚’è¡Œã†ãŸã‚ã®ãƒãƒ–ã¨ãªã‚‹ã€ŒThe Open Database Allianceã€ï¼ˆODAï¼‰ã®è¨ç«‹ã‚’ç™ºè¡¨ã—ãŸã€‚ PostgreSQLã¨ä¸¦ã‚“ã§ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ç•Œã§ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è£½å“ã®ãƒ‡ãƒ•ã‚¡ã‚¯ãƒˆã‚¹ã‚¿ãƒ³ãƒ€ãƒ¼ãƒ‰ã¨ãªã£ã¦ã„ã‚‹MySQLã¯ã€ã‚µãƒ³ãƒ»ãƒžã‚¤ã‚¯ãƒã‚·ã‚¹ãƒ†ãƒ ã‚ºã«2008å¹´1æœˆã«è²·åŽã•ã‚ŒãŸã“ã¨ã§åŒç¤¾ã®ä¸€éƒ¨é–€ã«ã€‚ãã®å¾Œã€2009å¹´4æœˆã«ã‚ªãƒ©ã‚¯ãƒ«ãŒã‚µãƒ³ãƒ»ãƒžã‚¤ã‚¯ãƒã‚·ã‚¹ãƒ†ãƒ ã‚ºã‚’è²·åŽã™ã‚‹ã¨ç™ºè¡¨ã—ãŸã“ã¨ã‹ã‚‰ã€é–‹ç™ºä½“åˆ¶ã‚„ãƒ©ã‚¤ã‚»ãƒ³ã‚¹ãƒ¢ãƒ‡ãƒ«ãªã©ã‚’å·¡ã£ã¦æ†‚æ…®ã®å£°ã‚„æ†¶æ¸¬ãŒæµã‚Œã¦ã„ãŸã€‚ã‚ªãƒ©ã‚¯ãƒ«ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è£½å“ã¨ã®æ•´åˆæ€§
shogo4405 2009/05/16
MySQL
ãƒªãƒ³ã‚¯
MySQL+Java ã§ã‚µãƒ¼ãƒã‚µã‚¤ãƒ‰ãƒ—ãƒªãƒšã‚¢ãƒ¼ãƒ‰ã‚¹ãƒ†ãƒ¼ãƒˆãƒ¡ãƒ³ãƒˆã‚’ä½¿ã†ã¹ãã§ã€Œãªã„ã€ç†ç”± - kazuhoã®ãƒ¡ãƒ¢ç½®ãå ´
useServerPrepStmtsã®ã“ã“ã®èª¬æ˜Žã§ã¯ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆãŒtrueã«ãªã£ã¦ã„ã‚‹ãŒã€ã“ã‚Œã¯ä¸Šè¿°ã®é€šã‚Šå˜˜ã§ã‚ã‚‹ã€‚ (ä¸ç•¥) ãã—ã¦ãªãœfalseã«ã•ã‚ŒãŸã‹ã¨ã„ã†ã“ã¨ã®èƒŒæ™¯ã‚’å¯Ÿã™ã‚‹ã¨ã€trueã«ã™ã‚‹ã“ã¨ã®å¼Šå®³ã‚‚ã‚ã‚Šãã†ã§ã€æ‰‹æ”¾ã—ã§ã“ã‚Œã‚’trueã«ã™ã‚‹ã“ã¨ã‚’å‹§ã‚ã‚‹ã“ã¨ãŒå°‘ã—ã¯ã°ã‹ã‚‰ã‚Œã‚‹ã€‚ http://www.geminium.com/chiba_blog/2008/12/23/33/ è‡ªåˆ†ã¯ Java ä½¿ã£ã¦ãªã„ã§ã™ãŒã€MySQL ã®ä¸ã®äººãŒä½¿ã†ãªã£ã¦è¨€ã£ã¦ã¾ã™ *1ã€‚ãã®ç†ç”±ã¯ãƒ¡ãƒ¢ãƒªãƒªãƒ¼ã‚¯ã®ã‚ˆã†ãªç—‡çŠ¶ãŒå‡ºã‚‹å¯èƒ½æ€§ãŒã‚ã‚‹ã‹ã‚‰ã€‚ So why are prepared statements a probl em? Because users do not clean up/close unused prepared statements. Multiply the number of prep
shogo4405 2008/12/27
MySQL

Java
ãƒªãƒ³ã‚¯
Amazon.co.jp: MySQLã‚¯ã‚¤ãƒƒã‚¯ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹: Russel J. T. Dyer (è‘—), æ¸¡é‚‰äº†ä»‹ (ç¿»è¨³), æ ªå¼ä¼šç¤¾ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã‚·ã‚¹ãƒ†ãƒ (ç¿»è¨³): æœ¬
shogo4405 2008/12/01
æœ¬æ£š

MySQL

è³¼å…¥æ¸ˆ
ãƒªãƒ³ã‚¯
https://labs.cybozu.co.jp/blog/kazuho/archives/2007/09/mysql_param_binding.php
shogo4405 2007/09/29
MySQL

Tuning

Tips
ãƒªãƒ³ã‚¯
mixiã®ç”Ÿã¿ã®è¦ªâ€œãƒã‚¿ãƒ©æ°â€ãŒèªžã‚‹MySQLã®æ„å¤–ãªåˆ©ç”¨æ³• ï¼ TechTargetã‚¸ãƒ£ãƒ‘ãƒ³
æ—¥è¨˜ã ã‘ã§4å„„ä»¶ã®ãƒ‡ãƒ¼ã‚¿ ãƒŸã‚¯ã‚·ã‚£ãŒé‹å–¶ã™ã‚‹SNSã€Œmixiã€ã¯ã€2007å¹´7æœˆæœ«æ®µéšŽã§ãƒ¦ãƒ¼ã‚¶ãƒ¼æ•°ãŒ1110ä¸‡äººã€‚äººãŒ12äººé›†ã¾ã‚Œã°ã€1äººã¯mixiãƒ¦ãƒ¼ã‚¶ãƒ¼ã¨ã„ã†ã‚ã‘ã ã€‚ãƒ¦ãƒ¼ã‚¶ãƒ¼ã®ã‚¢ã‚¯ãƒ†ã‚£ãƒ–çŽ‡ï¼ˆãƒã‚°ã‚¤ãƒ³é–“éš”ãŒ3æ—¥ä»¥å†…ï¼‰ã¯ç´„62ï¼…ã¨é«˜ãã€2007å¹´4æœˆã‹ã‚‰6æœˆã®æœˆé–“å¹³å‡ãƒšãƒ¼ã‚¸ãƒ“ãƒ¥ãƒ¼ã¯117.5å„„ã«é”ã—ãŸã€‚æ—¥è¨˜ã ã‘ã§ã‚‚4å„„ä»¶ä»¥ä¸Šã«ä¸Šã‚‹ãªã©ã€è“„ç©ã™ã‚‹ãƒ‡ãƒ¼ã‚¿é‡ã‚‚èŽ«å¤§ã€‚2004å¹´3æœˆã®ã‚µãƒ¼ãƒ“ã‚¹é–‹å§‹ã‹ã‚‰ã€ã‚ãšã‹3å¹´åŠã§ç¾åœ¨ã®å·¨å¤§ã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ãƒ¼ã¸ã¨ç™ºå±•ã—ãŸã®ã ã€‚ ãƒŸã‚¯ã‚·ã‚£ã¯ã€ã€ŒLAMPï¼ˆOSã®Linuxã€Webã‚µãƒ¼ãƒã®Apacheã€DBMSã®MySQLã€é–‹ç™ºè¨€èªžã®Perlã€PHPã€Pythonï¼‰ã€ã¨å‘¼ã°ã‚Œã‚‹Webã‚·ã‚¹ãƒ†ãƒ å‘ã‘ã®æ¨™æº–çš„ãªã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ï¼ˆä»¥ä¸‹ã€OSSï¼‰ã§ã‚·ã‚¹ãƒ†ãƒ ã‚’è‡ªç¤¾é–‹ç™ºã—ã€å®‰ä¾¡ãªPCã‚µãƒ¼ãƒã‚’1000å°ä»¥ä¸Šé€£ãã‚‹è¶…åˆ†æ•£æ§‹æˆã§mixiã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’æ”¯ãˆã¦ã„ã‚‹ï¼ˆåºƒå‘Šé…ä¿¡ãªã©å‘¨è¾ºæ©Ÿèƒ½ã§ã¯
shogo4405 2007/09/18
MySQL

mixi

è² è·åˆ†æ•£
ãƒªãƒ³ã‚¯
1