[B! innodb] webmarksjpã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

webmarksjp id:webmarksjp

innodbã«é–¢ã™ã‚‹webmarksjpã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (12)

${{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}}

https://labs.cybozu.co.jp/blog/kazuho/archives/2008/06/mysql_direct_access.php
webmarksjp 2008/07/14
æœ€é©åŒ–

database

innodb

mysql

sql

db
ãƒªãƒ³ã‚¯
Re: MySQLæœ€é©åŒ–ã®ãƒŸãƒ‹tips - æ—¥å‘å¤ç‰¹æ®Šå¿œæ´éƒ¨éšŠ
å…ƒãƒã‚¿: http://labs.unoh.net/2007/07/mysqltips.html ã‚ã¾ã‚Šå…·ä½“çš„ã˜ã‚ƒãªã„ã®ã§ã€åƒ•ã®è€ƒãˆã¨ã‹ã€‚ æ£ã—ã„ã‹ã©ã†ã‹ã¯å„è‡ªã®çŠ¶æ³ã ã¨ã‹å®Ÿéš›è©¦ã™ã¹ããªã‚“ã ã‘ã©ã€å‚è€ƒã«ãªã‚Œã°ã€‚ MyISAMã€InnoDBãªã©ãƒ†ãƒ¼ãƒ–ãƒ«ã‚¿ã‚¤ãƒ— åƒ•ã¯æ–ç„¶InnoDBæ´¾ã§ã™ã€‚ ãŸã ä»°ã‚‹ã¨ãŠã‚Šã€ãƒã‚°ã‚‹ã ã‘ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã¨ã‹ãªã‚‰MyISAMã§ã‚‚ã„ã„ã¨ã¯æ€ã†ã‘ã©ã€‚ ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã‚„ãƒãƒƒã‚¯å‡¦ç†ãªã©ãŒå¿…è¦ãªã„å ´åˆãªã©ã€MyISAMå½¢å¼ã«ã‚‚è‰¯ã„ã¨ã“ã‚ã¯ã‚ã‚‹ã®ã§æ¤œè¨Žã—ã¦ã¿ã‚‹ä¾¡å€¤ã¯ã‚ã‚‹ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ã€‚ ã“ã‚Œã ã‘ã®æŒ‡æ‘˜ã ã¨ã¡ã‚‡ã£ã¨å¾®å¦™ãªæ°—ãŒã™ã‚‹ã§ã™ã€‚ MyISAMã®ä½¿ã„ã©ã“ã‚ã£ã¦ã®ã¯ã€ ãƒ”ãƒ³ã§ä»–ã¨ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ãŒç„¡ã„å˜ç´”è¿½è¨˜ç³»ã®ãƒ†ãƒ¼ãƒ–ãƒ« ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ãŒã‚ã‚Šã€åŒä¸€ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³å†…ã§ã®æ›´æ–°ç³»ã‚¯ã‚¨ãƒªãŒå˜åœ¨ã™ã‚‹å ´åˆã¯ã€ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ãŒæœŸå¾…é€šã‚Šã«å‹•ã‹ãªã„ã®ã§ã€åŸºæœ¬çš„ã«ã¯InnoDBã¨æ··åœ¨ã•ã›ã‚‹ã¹ãã§ã¯ãªã„
webmarksjp 2008/07/14
MySQL

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°

DB

innodb

myisam

performance
ãƒªãƒ³ã‚¯
InnoDB ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚° - MySQLã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹2007 - akiyan.com ç®¡ç†äººãƒ¡ãƒ¢
http://www.mysql-ucj2007.jp/details/j25.html æœ¨ä¸‹ é–æ–‡ æ° NTTã‚³ãƒ ã‚¦ã‚§ã‚¢æ ªå¼ä¼šç¤¾ ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆç®¡ç†çµ±æ‹¬éƒ¨æŠ€è¡“SEéƒ¨é–€ DB æŠ€è¡“ã‚°ãƒ«ãƒ¼ãƒ— ï¼ˆã€ŒInnoDBã€ã¯ã€Œã„ã‚“ã®ã§ãƒ¼ã³ãƒ¼ã€ã¨è¨€ã†ã‚‰ã—ã„...ä»Šã¾ã§ã€Œã„ã®ã§ãƒ¼ã³ãƒ¼ã€ã¨è¨€ã£ã¦ã¾ã—ãŸï¼‰ InnoDBã‚’ãªãœä½¿ã†ã‹ ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ ã‚³ãƒŸãƒƒãƒˆã€ãƒãƒ¼ãƒ«ãƒãƒƒã‚¯ã€ã‚»ãƒ¼ãƒ–ãƒã‚¤ãƒ³ãƒˆ å¤–éƒ¨ã‚ãƒ¼ è¡Œãƒ¬ãƒ™ãƒ«ãƒãƒƒã‚¯ ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ— ã‚¯ãƒ©ãƒƒã‚·ãƒ¥ãƒªã‚«ãƒãƒª ã‚¯ãƒ©ãƒƒã‚·ãƒ¥ãƒªã‚«ãƒãƒª MyISAMã¯ãƒ‡ãƒ¼ã‚¿é‡ã®å¢—å¤§ã¨ã¨ã‚‚ã«æ™‚é–“ãŒã‹ã‹ã‚‹ InnoDBã¯ãƒ‡ãƒ¼ã‚¿é‡ã®å¢—å¤§ã¨ã®ç›¸é–¢ãŒãªã„ InnoDBãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®çŽ‹é“çš„ã‚¢ãƒ—ãƒãƒ¼ãƒ ã‚¯ã‚¨ãƒªã‚’æ”¹å–„ã—ã¦å…¨ä½“çš„ã«å‡¦ç†åŠ¹çŽ‡ã‚’ä¸Šã’ã‚‹ ãƒ‡ãƒ¼ã‚¿ã‚µã‚¤ã‚ºã‚’ã§ãã‚‹ã ã‘å°ã•ã ãƒ¡ãƒ¢ãƒªã‚’ã§ãã‚‹ã ã‘å¤šãç©ã‚€ ã‚³ãƒŸãƒƒãƒˆæ€§èƒ½ï¼ˆåŒæœŸæ›¸ãè¾¼ã¿ï¼‰ innodb_flush_log_at_trx_commit=1,0,2
webmarksjp 2008/07/14
RDBMS

ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°

MySQL

innodb

performance

tuning

myisam

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ãƒªãƒ³ã‚¯
MySQL (InnoDB) ã«ãŠã‘ã‚‹è¡Œã®ã‚µã‚¤ã‚ºã¨é€Ÿåº¦ã®é–¢ä¿‚ã«ã¤ã„ã¦ - kazuhoã®ãƒ¡ãƒ¢ç½®ãå ´
é›†ç´„æ¼”ç®—ã‚’è¡Œã†ã‚±ãƒ¼ã‚¹ã§ã¯ã€è¡Œã®ã‚µã‚¤ã‚ºã‚’å°ã•ãä¿ã¤ã“ã¨ã¯ã¨ã¦ã‚‚é‡è¦ã€‚ã‚¢ã‚¯ã‚»ã‚¹é »åº¦ãŒä½Žã„ã‚³ãƒ©ãƒ ã¯åˆ¥ãƒ†ãƒ¼ãƒ–ãƒ«ã«è¿½ã„å‡ºã™ã¨ã‹ã—ãŸã»ã†ãŒã„ã„ãã‚‰ã„ã€‚ ä¸€æ–¹ã€é›†ç´„æ¼”ç®—ã‚’è¡Œã‚ãªã„ã‚±ãƒ¼ã‚¹ (å˜ä¸€è¡Œã® insert, update ç‰ã‚’å«ã‚€) ã®å ´åˆã¯ã€(ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã¨ã®é€šä¿¡ã®ãŸã‚ã®) ã‚·ã‚¹ãƒ†ãƒ ã‚³ãƒ¼ãƒ«ãŒã‚ªãƒ¼ãƒãƒ¼ãƒ˜ãƒƒãƒ‰ã«ãªã‚‹ã®ã§ã€å°ã•ãªãƒ†ãƒ¼ãƒ–ãƒ«ã«ãŸãã•ã‚“ã‚¢ã‚¯ã‚»ã‚¹ã‚’ã™ã‚‹ã‚ˆã‚Šã‚‚ã€é•·ã„è¡Œã‚’æŒã¤ãƒ†ãƒ¼ãƒ–ãƒ«ã«ï¼‘å›žã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹ã»ã†ãŒè‰¯ã„ã€‚ ãŸã¨ãˆã°æ‰‹å…ƒã®ç’°å¢ƒã§ã® insert on duplicate key update ã®é€Ÿåº¦ã¯ã€ è¡Œã®ã‚µã‚¤ã‚º å¿…è¦æ™‚é–“ 0KB 1 3KB 4 6KB 7 9KB 13 12KB 13 ã¨ã‹ãã‚“ãªæ„Ÿã˜ (ç’°å¢ƒã‚„ã‚¯ã‚¨ãƒªã«ã‚ˆã‚‹å¤‰ã‚ã‚‹ã®ã§è‡ªåˆ†ã§æ¸¬å®šã—ã¦ãã€‚9KB ã®é€Ÿåº¦ä½Žä¸‹ã¯ãƒšãƒ¼ã‚¸ã‚µã‚¤ã‚ºã®1/2ã‚’è¶…ãˆãŸã‹ã‚‰ã‹ãª)ã€‚ã¤ã¾ã‚Šã€è¡Œã®ã‚µã‚¤ã‚ºãŒ1KBç¨‹åº¦ã ã¨ã€é€šä¿¡ã®ã‚ªãƒ¼ãƒãƒ¼ãƒ˜ãƒƒãƒ‰ãŒå¤§ãã„ã‹ã‚‰ã‚ã¾ã‚Šå•é¡Œã«
webmarksjp 2008/07/14
db

mysql

ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹

innodb

*db

database

æœ€é©åŒ–
ãƒªãƒ³ã‚¯
æ ªå¼ä¼šç¤¾ã‚¹ã‚¿ã‚¤ãƒ«ã‚º
AWSã‚¢ãƒ‰ãƒãƒ³ã‚¹ãƒ‰ã‚³ãƒ³ã‚µãƒ«ãƒ†ã‚£ãƒ³ã‚°ãƒ‘ãƒ¼ãƒˆãƒŠãƒ¼ã®ä¸€å“¡ã¨ã—ã¦æ´»å‹•ã™ã‚‹æ ªå¼ä¼šç¤¾ã‚¹ã‚¿ã‚¤ãƒ«ã‚ºãŒã€AWSå°Žå…¥ã€ç§»è¡Œã€é–‹ç™ºã€ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã€é‹ç”¨ä¿å®ˆãªã©ã€ã™ã¹ã¦ã®ã”ç›¸è«‡ã«ä¹—ã‚‰ã›ã¦ã„ãŸã ãã¾ã™ã€‚ AWSã‚’å°Žå…¥ã—ãŸã„ãŒä½•ã‹ã‚‰å§‹ã‚ãŸã‚‰ã„ã„ã‹ã‚ã‹ã‚‰ãªã„ æ—¢å˜ã®ãƒ™ãƒ³ãƒ€ãƒ¼ãŒæ–°æŠ€è¡“ã«å¼±ãã€è‰¯ã„ææ¡ˆãŒã‚‚ã‚‰ãˆãªã„ ã‚¯ãƒ©ã‚¦ãƒ‰ã®å°Žå…¥ã«ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã®ä¸å®‰ãŒã‚ã‚‹ AWSã‚’ã¨ã‚Šã‚ãˆãšå°Žå…¥ã—ãŸãŒã€ã•ã‚‰ã«æ´»ç”¨ã—ã¦ã„ããŸã„ ç¤¾å†…ã«AWSã®çŸ¥è¦‹ã‚’æŒã£ã¦ã„ã‚‹äººãŒã„ãªã„ AWSãªã‚‰ã§ã¯ã®ã‚·ã‚¹ãƒ†ãƒ é–‹ç™ºã‚’è©³ã—ãçŸ¥ã‚ŠãŸã„
webmarksjp 2008/07/13
MySQL

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°

DB

innodb

performance

tuning

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
ãƒªãƒ³ã‚¯
æ ªå¼ä¼šç¤¾ã‚¹ã‚¿ã‚¤ãƒ«ã‚º
AWSã‚¢ãƒ‰ãƒãƒ³ã‚¹ãƒ‰ã‚³ãƒ³ã‚µãƒ«ãƒ†ã‚£ãƒ³ã‚°ãƒ‘ãƒ¼ãƒˆãƒŠãƒ¼ã®ä¸€å“¡ã¨ã—ã¦æ´»å‹•ã™ã‚‹æ ªå¼ä¼šç¤¾ã‚¹ã‚¿ã‚¤ãƒ«ã‚ºãŒã€AWSå°Žå…¥ã€ç§»è¡Œã€é–‹ç™ºã€ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã€é‹ç”¨ä¿å®ˆãªã©ã€ã™ã¹ã¦ã®ã”ç›¸è«‡ã«ä¹—ã‚‰ã›ã¦ã„ãŸã ãã¾ã™ã€‚ AWSã‚’å°Žå…¥ã—ãŸã„ãŒä½•ã‹ã‚‰å§‹ã‚ãŸã‚‰ã„ã„ã‹ã‚ã‹ã‚‰ãªã„ æ—¢å˜ã®ãƒ™ãƒ³ãƒ€ãƒ¼ãŒæ–°æŠ€è¡“ã«å¼±ãã€è‰¯ã„ææ¡ˆãŒã‚‚ã‚‰ãˆãªã„ ã‚¯ãƒ©ã‚¦ãƒ‰ã®å°Žå…¥ã«ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã®ä¸å®‰ãŒã‚ã‚‹ AWSã‚’ã¨ã‚Šã‚ãˆãšå°Žå…¥ã—ãŸãŒã€ã•ã‚‰ã«æ´»ç”¨ã—ã¦ã„ããŸã„ ç¤¾å†…ã«AWSã®çŸ¥è¦‹ã‚’æŒã£ã¦ã„ã‚‹äººãŒã„ãªã„ AWSãªã‚‰ã§ã¯ã®ã‚·ã‚¹ãƒ†ãƒ é–‹ç™ºã‚’è©³ã—ãçŸ¥ã‚ŠãŸã„
webmarksjp 2008/07/13
mysql

performance

tuning

myisam

innodb

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
ãƒªãƒ³ã‚¯
MySQLã®InnoDBã§ã®ãƒ‡ãƒƒãƒ‰ãƒãƒƒã‚¯ - mixi engineer blog
ã“ã‚“ã«ã¡ã¯ã€mixié–‹ç™ºéƒ¨ã«ã¦ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³é–‹ç™ºã‚’ã—ã¦ã„ã¾ã™youheiã§ã™ã€‚ ä»Šå›žã¯ã€MySQL-5.0.45ã®InnoDBã§é€£ç•ªã‚’ç®¡ç†ã™ã‚‹ãƒ†ãƒ¼ãƒ–ãƒ«ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹æ¸¬å®šã‚’ã—ã¦ã„ãŸã®ã§ã™ãŒã€ãã®éš›ã«å°‘ã—å¤‰ã‚ã£ãŸãƒ‡ãƒƒãƒ‰ãƒãƒƒã‚¯å•é¡Œã«éé‡ã—ã¾ã—ãŸã®ã§ã€ãã®ã‚ãŸã‚Šã‚’ãƒã‚¿ã¨ã—ã¦æ›¸ã„ã¦ã¿ãŸã„ã¨æ€ã„ã¾ã™ã€‚ ã¾ãšã¯ã€ä»Šå›žä½¿ç”¨ã—ãŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã‚¹ã‚ãƒ¼ãƒžã¯ä¸‹è¨˜ã®ã‚ˆã†ãªã‚‚ã®ã§ã™ã€‚ CREATE TABLE num ( id bigint unsigned NOT NULL default '0' ) Engine=InnoDB; AUTO_INCREMENTã¯ä½¿ç”¨ã—ã¦ã„ã¾ã›ã‚“ã€‚ ãã“ã«1ãƒ¬ã‚³ãƒ¼ãƒ‰ã ã‘ç™»éŒ²ã—ã¾ã™ã€‚ INSERT INTO num (id) values (1); ãã—ã¦å®Ÿéš›é€£ç•ªã‚’å–å¾—ã™ã‚‹éš›ã«ã¯ã€ UPDATE num SET id = LAST_INSERT_ID(id+1); ã¨ã„ã£ãŸã‚¯ã‚¨ãƒªã‚’
webmarksjp 2008/07/13
mysql

deadlock

innodb

tips
ãƒªãƒ³ã‚¯
InnoDB vs MyISAM (vs Falcon) ã‚’èªã‚“ã§èˆˆå‘³æ·±ã„ã¨æ€ã£ãŸç‚¹ - ï¼ˆã²ï¼‰ãƒ¡ãƒ¢
InnoDB vs MyISAM vs Falcon benchmarks - part 1 ã‚’èªã‚“ã ã€‚èˆˆå‘³æ·±ã‹ã£ãŸã€‚ ã ã‘ã ã¨ãƒŠãƒ³ãªã®ã§ã€æ€ã£ãŸã“ã¨ã‚’ãƒ¡ãƒ¢ã£ã¦ã¿ã‚‹ã€‚ ãŒã‚“ã°ã‚ŒFalcon ã¾ã ç”Ÿã¾ã‚ŒãŸã¦ãªã®ã§ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ã®çµæžœã¯å‚è€ƒç¨‹åº¦ã«ã€‚ InnoDB vs MyISAM The second goal of benchmark was a popular myth that MyISAM is faster than InnoDB in reads, as InnoDB is transactional, supports Foreign Key and has an operational overhead. As you will see it is not always true. ã®é€šã‚Šã€ã©ã¡ã‹ã¨ã„ã†ã¨(Falconã‚ˆã‚Š)InnoDBã¨MyISAMã®æ€§èƒ½æ¯”è¼ƒã®æ–¹ãŒèˆˆå‘³æ·±ã„ç‚¹ãŒ
webmarksjp 2008/07/13
benchmark

innodb

myisam

mysql

performance

scalability

*tips
ãƒªãƒ³ã‚¯
GREE Labs
ã‚³ãƒ³ãƒ†ãƒ³ãƒ„ã¸ã‚¹ã‚ãƒƒãƒ— ãƒŠãƒ“ã‚²ãƒ¼ã‚·ãƒ§ãƒ³ã«ç§»å‹• Engineers' Blog Awards 2024 ã‚’å®Ÿæ–½ã—ã¾ã—ãŸï¼2024/06/26yutaka.sashimaã“ã‚“ã«ã¡ã¯ã€é–‹ç™ºä¼ç”»éƒ¨ã®ä½å³¶ã§ã™ã€‚ Engineers' Blog Awards 2024 ã¨ã„ã†æŠ€è¡“ãƒ–ãƒã‚°åŸ·ç†è€…ã‚’ç§°ãˆã‚‹ç¤¾å†…ã‚¤ãƒ™ãƒ³ãƒˆã‚’é–‹å‚¬ã—ã¾ã—ãŸã®ã§ç´¹ä»‹ã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚ é–‹å‚¬èƒŒæ™¯ ãã£ã‹ã‘ã¯æ˜¨å¹´ã®æ–°å’ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ç ”ä¿® [â€¦] InfoGREE Engineersâ€™ Bash 2024 ã‚’6æœˆ19æ—¥(æ°´)ã«é–‹å‚¬ã—ã¾ã—ãŸï¼2024/06/26yutaka.sashima å‹‰å¼·ä¼š ã“ã‚“ã«ã¡ã¯ã€é–‹ç™ºä¼ç”»éƒ¨ã®ä½å³¶ã§ã™ã€‚ GREE Engineersâ€™ Bash 2024 ã¨ã„ã†ç¤¾å†…é™å®šã‚¤ãƒ™ãƒ³ãƒˆãŒæ˜¨å¹´ã«å¼•ãç¶šãé–‹å‚¬ã•ã‚Œã¾ã—ãŸã®ã§ç´¹ä»‹ã•ã›ã¦é ‚ãã¾ã™ã€‚ ï¼ˆGREE Engineersâ€™ Bash ã«ã¤ã„ã¦ã¯ [â€¦] InfoSlackã‚ªãƒ¼ãƒˆ
webmarksjp 2008/07/13
GREE

ãƒ¬ãƒãƒ¼ãƒˆ

programming

search

senna

tritonn

innodb

db

mysql
ãƒªãƒ³ã‚¯
ãƒ•ãƒ„ãƒ¼ãªæ—¥å¸¸ - InnoDBã‚’ä½¿ã†ã¨ãã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã¨ã—ã¦InnoDBã‚’ä½¿ã†ã¨ãã¯MyISAMã®ã¨ãã¨è§¦ã‚‹ã¹ããƒã‚¤ãƒ³ãƒˆãŒé•ã†ã®ã§æ³¨æ„ã€‚ http://www.mysqlperformanceblog.com/files/presentations/OSCON2004-MySQL-Innodb-Performance-Optimization.pdf ã‚’èªã¿ãªãŒã‚‰å–ã£ãŸãƒ¡ãƒ¢ã€‚çŠ¶æ³ã¨ã—ã¦ã¯RedHat AS3.0ã§å‹•ã‹ã—ãŸã¨ãã®DBT2*1ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’æ”¹å–„ã—ã¦ã„ãã¨ã„ã†ã‚‚ã®ã€‚MySQL ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆçŠ¶æ…‹ã§ã®åˆ†æž Handler_read_nextãŒå¤šã„ã€ã¤ã¾ã‚Šrange scanã‹index scanãŒå¤šã™ãŽã‚‹ slow query logã§ä½•ãŒæ‚ªã„ã‹ã‚’å¼•ã£ã‹ã‘ã‚‹ ä¾‹ã§ã¯2ç§’ä»¥ä¸Šå‡¦ç†ã«ã‹ã‹ã£ãŸqeuryã‚’è¨˜éŒ²ã™ã‚‹ã‚ˆã†ã«ã—ã¦ã„ã‚‹ çµæžœã‚’åˆ†æž updateæ–‡ãŒé…ã‹ã£ãŸã‘ã©ã€updateæ–‡ãã®ã¾ã¾ã§ã¯explainã§ããªã„ã®ã§ã€
webmarksjp 2008/07/13
mysql

database

innodb

tuning

é«˜é€ŸåŒ–

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ãƒªãƒ³ã‚¯
cl.pocari.org - æ‹¡å¼µã•ã‚Œç¶šã‘ã‚‹ InnoDB ã®ãƒ‡ãƒ¼ã‚¿ãƒ•ã‚¡ã‚¤ãƒ«ã®ã‚µã‚¤ã‚ºã‚’å°ã•ãã™ã‚‹æ–¹æ³•
æ‹¡å¼µã•ã‚Œç¶šã‘ã‚‹ InnoDB ã®ãƒ‡ãƒ¼ã‚¿ãƒ•ã‚¡ã‚¤ãƒ«ã®ã‚µã‚¤ã‚ºã‚’å°ã•ãã™ã‚‹æ–¹æ³• 2006-07-07-2: [MySQL] MySQL ã§ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã‚’å¯èƒ½ã«ã™ã‚‹ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã¨ã—ã¦ InnoDB ãŒã‚ã‚Šã¾ã™ï¼Ž InnoDB ã®ãƒ‡ãƒ¼ã‚¿ãƒ•ã‚¡ã‚¤ãƒ«ã¯ï¼ŒMyISAM ãƒ†ãƒ¼ãƒ–ãƒ«ã¨ç•°ãªã£ã¦ï¼Œãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã§ã¯ ibdata1 ã¨ã„ã†ãƒ•ã‚¡ã‚¤ãƒ«ã«ãƒ‡ãƒ¼ã‚¿ãŒè“„ç©ã•ã‚Œã¦ã„ãã¨ã“ã«ãªã‚Šã¾ã™ï¼Ž MySQL ã® datadir ã«è‡ªå‹•æ‹¡å¼µã™ã‚‹ 10 MB ã® ibdata1 ãƒ•ã‚¡ã‚¤ãƒ«ãŒ 1 ã¤ã¨ã€5 MB ã® ib_logfile ãƒã‚°ãƒ•ã‚¡ã‚¤ãƒ«ãŒ 2 ã¤ä½œæˆã•ã‚Œã¾ã™ - 7.5.3. InnoDB èµ·å‹•ã‚ªãƒ—ã‚·ãƒ§ãƒ³ http://dev.mysql.com/doc/refman/4.1/ja/innodb-start.html ã“ã® ibdata1 ã¯ï¼Œå¤§é‡ã®ãƒ‡ãƒ¼ã‚¿ã‚’è¿½åŠ ã—ã¦ã„ãã¨ï¼Œè‡ªå‹•çš„ã«ã‚µã‚¤ã‚ºã‚’æ‹¡å¼µã—ã¦ã„ãã¾ã™ï¼Ž ãŸã
webmarksjp 2008/07/12
mysql

innodb

rdb

tips

atode
ãƒªãƒ³ã‚¯
KLab
ã”æŒ‡å®šã®ãƒšãƒ¼ã‚¸ãŒè¦‹ã¤ã‹ã‚Šã¾ã›ã‚“ã§ã—ãŸ URLã®å¤‰æ›´ã€ã‚‚ã—ãã¯ãƒšãƒ¼ã‚¸ãŒå‰Šé™¤ã•ã‚ŒãŸå¯èƒ½æ€§ãŒã‚ã‚Šã¾ã™ã€‚ ãŠæ‰‹æ•°ã§ã™ãŒã€ä»¥ä¸‹ã®ãƒªãƒ³ã‚¯ã‹ã‚‰ç›®çš„ã®ãƒšãƒ¼ã‚¸ã‚’ãŠæŽ¢ã—ãã ã•ã„ã€‚
webmarksjp 2008/07/12
MySQL

tuning

DB-DBè¨è¨ˆ

DB-MySQL

database

db
ãƒªãƒ³ã‚¯
1