[B! mysql] kosakiã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

kosaki id:kosaki

mysqlã«é–¢ã™ã‚‹kosakiã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (6)

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

ï¿½Linux/DB Tuning (DevSumi2010, Japanese)
1. é«˜æ€§èƒ½ãƒ»å®‰å®šé‹ç”¨ã®ãŸã‚ã® Linux/DB ã‚·ã‚¹ãƒ†ãƒ æ§‹ç¯‰ / é‹ç”¨æŠ€è¡“ æ¾ä¿¡ å˜‰ç¯„ (MATSUNOBU Yoshinori) ã‚µãƒ³ãƒ»ãƒžã‚¤ã‚¯ãƒã‚·ã‚¹ãƒ†ãƒ ã‚ºæ ªå¼ä¼šç¤¾ ãƒ—ãƒªãƒ³ã‚·ãƒ‘ãƒ« MySQL ã‚³ãƒ³ã‚µãƒ«ã‚¿ãƒ³ãƒˆ 2. ãƒ—ãƒãƒ•ã‚£ãƒ¼ãƒ« 2006 å¹´ 9 æœˆã‹ã‚‰ MySQL->Sun(-> ã‚ªãƒ©ã‚¯ãƒ« ) ã§ MySQL ã‚³ãƒ³ã‚µãƒ«ã‚¿ãƒ³ãƒˆã¨ã—ã¦å‹¤å‹™ ä¸»ãªè‘—æ›¸ Linux-DB ã‚·ã‚¹ãƒ†ãƒ æ§‹ç¯‰ / é‹ç”¨å…¥é–€ ç¾å ´ã§ä½¿ãˆã‚‹ MySQL Java ãƒ‡ãƒ¼ã‚¿ã‚¢ã‚¯ã‚»ã‚¹å®Ÿè·µè¬›åº§ Twitter: matsunobu Blog: http://opendatabaselife.blogspot.com * ä»Šå›žã®è³‡æ–™ã¯å…¬é–‹ã—ã¾ã™ * MySQL ç”¨èªžãŒã‚ã¡ã“ã¡ã«å‡ºã¾ã™ãŒã€ çµŒé¨“ã®ç„¡ã„æ–¹ã«ã‚‚åˆ†ã‹ã‚‹ã‚ˆã†ã«é…æ…®ã—ã¦ã„ãã¤ã‚‚ã‚Šã§ã™ 3. å®‰å®šç¨¼åƒã¨é«˜æ€§èƒ½ã‚’æ”¯ãˆã‚‹è¦ç´ ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³å±¤ã«é–¢ã™ã‚‹æŠ€è¡“ ãƒ†ãƒ¼ãƒ–ãƒ«è¨è¨ˆã€ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹è¨
kosaki 2010/04/01
DB

linux

mysql
ãƒªãƒ³ã‚¯
SystemTapã§MySQLã®Disk I/Oã‚’åˆ†æžã™ã‚‹ - SH2ã®æ—¥è¨˜
å®Ÿé¨“ã‚¨ãƒ³ãƒˆãƒªã§ã™ã€‚ å‹•æ©Ÿ Oracleã®Statspack/AWRã§å–ã‚Œã‚‹ãƒ•ã‚¡ã‚¤ãƒ«å˜ä½ã®Disk I/Oæƒ…å ±ã‚’ã€MySQLã§ã‚‚æŽ¡å–ã—ãŸã„ã€‚ã“ã‚Œã¯æ¬¡ã«ç¤ºã™ã‚ˆã†ãªãƒ‡ãƒ¼ã‚¿ã§ã™ã€‚ File IO Stats DB/Inst: ORA112/ORA112 Snaps: 6-7 ->Mx Rd Bkt: Max bucket time for single block read ->ordered by Tablespace, File Tablespace Filename ------------------------ ---------------------------------------------------- Av Mx Av Av Rd Rd Av Av Buffer BufWt Reads Reads/s (ms) Bkt Blks/Rd Writes Writes/s Wai
kosaki 2010/01/20
mysql

SystemTap

linux
ãƒªãƒ³ã‚¯
MySQLã«çºã‚ã‚‹10ã®éƒ½å¸‚ä¼èª¬
èª°ã®å£ã‹ã‚‰é£›ã³å‡ºã—ãŸã®ã‹ã¯å®šã‹ã§ã¯ãªã„ãŒã€å··ã§ã¯MySQLã«ã¾ã¤ã‚ã‚‹æ§˜ã€…ãªã€Œéƒ½å¸‚ä¼èª¬ã€ãŒã¾ã“ã¨ã—ã‚„ã‹ã«å›ã‹ã‚Œã¦ã„ã‚‹ã‚ˆã†ã ã€‚æã‚‰ãMySQLã«å¯¾ã™ã‚‹ç†è§£ãŒä½Žã„äººã‚„ã€MySQLãŒã‚ã¾ã‚Šå¥½ãã§ã¯ãªã„é¢ã€…ã«ã‚ˆã£ã¦FUDã£ã½ãè¨€ã‚ã‚Œã¦ã„ã‚‹ã®ã ã¨æ€ã†ãŒã€ä¸–ã®ä¸ã«ã¯ãã®ã‚ˆã†ãªã€Œéƒ½å¸‚ä¼èª¬ã€ã‚’çœŸã«å—ã‘ã¦ã—ã¾ã†äººãŒå±…ã‚‹ã®ã‚‚ã¾ãŸäº‹å®Ÿã§ã‚ã§ã‚ã‚‹ã€‚MySQLã«ãŠã‘ã‚‹æ˜¨ä»Šã®é–‹ç™ºã‚¹ãƒ”ãƒ¼ãƒ‰ã«ã¯ç›®è¦šã¾ã—ã„ã‚‚ã®ãŒã‚ã‚Šã€MySQLã¯æ€§èƒ½ãƒ»å®‰å®šæ€§ãƒ»ä½¿ã„æ˜“ã•å…±ã«é€²åŒ–ã—ç¶šã‘ã¦ã„ã‚‹ã€‚ï¼ˆç‰¹ã«å…ˆæ—¥ãƒªãƒªãƒ¼ã‚¹ã•ã‚ŒãŸMySQL 5.5ã¯æ€§èƒ½ãƒ»å®‰å®šæ€§ãƒ»ä½¿ã„æ˜“ã•ã‚’ä¸¡ç«‹ã—ã¦ã„ã‚‹å„ªã‚ŒãŸãƒãƒ¼ã‚¸ãƒ§ãƒ³ã ï¼ï¼ï¼‰ã—ã‹ã—ã€Œéƒ½å¸‚ä¼èª¬ã€ã§èªžã‚‰ã‚Œã‚‹ã“ã¨ã¯ç·ã˜ã¦ã€ŒMySQLã¯ãƒ€ãƒ¡ãªåã¡ã‚ƒã‚“ã€ã§ã‚ã‚‹ã¨ã„ã†çƒ™å°ã‚’æŠ¼ã™ã‚‚ã®ã°ã‹ã‚Šã§ã‚ã‚Šã€MySQLerã¨ã—ã¦ã¯ãã®ã‚ˆã†ãªè¨€ã‚ã‚Œç„¡ãæ±šåã‚’å…¨èº«å…¨éœŠã‚’ã‚‚ã£ã¦æ™´ã‚‰ã•ãªã‘ã‚Œã°ãªã‚‰ãªã„ä½¿å‘½ã‚’èƒŒè² ã£ã¦ã„ã‚‹ã€‚ãã“ã§ã€ä»Šæ—¥ã¯MySQLã«ã¤ã„ã¦èªžã‚‰ã‚Œ
kosaki 2009/12/18
mysql
ãƒªãƒ³ã‚¯
MySQLã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã®è©±
46. ä¸€æ™‚ãƒ†ãƒ¼ãƒ–ãƒ«ã§ã¯å€¤ã®å°ã•ã„æ–¹ãŒæŽ¡ç”¨ã•ã‚Œã‚‹ if (thd->variables.tmp_table_size == ~ (ulonglong) 0) // No limit share->max_rows= ~(ha_rows) 0; else share->max_rows= (ha_rows) (((share->db_type() == heap_hton) ? min(thd->variables.tmp_table_size, thd->variables.max_heap_table_size) : thd->variables.tmp_table_size) / share->reclength);
kosaki 2009/11/02
MySQL

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ãƒªãƒ³ã‚¯
MySQLã®ã€Œç”Ÿã¿ã®è¦ªã€ã€ã‚µãƒ³ã‚’é›¢ã‚Œã‚‹ ï¼ ï¼ IT
2009/02/05 å…ƒMySQL ABã®CTOã§ã€MySQLã®ã€Œç”Ÿã¿ã®è¦ªã€ã¨ã„ã‚ã‚Œã‚‹Michael Wideniusæ°ãŒã‚µãƒ³ãƒ»ãƒžã‚¤ã‚¯ãƒã‚·ã‚¹ãƒ†ãƒ ã‚ºã‚’é€€è·ã—ãŸã€‚2009å¹´2æœˆ5æ—¥ä»˜ã‘ã®åŒæ°ã®ãƒ–ãƒã‚°ã‚¨ãƒ³ãƒˆãƒªã«ã‚ˆã‚‹ã¨ã€ã™ã§ã«ã‚µãƒ³ãƒ»ãƒžã‚¤ã‚¯ãƒã‚·ã‚¹ãƒ†ãƒ ã‚ºã‚’é€€è·ã—ã€æ–°ãŸã«Monty Program Abã¨ã„ã†ä¼šç¤¾ã‚’è¨ç«‹ã—ãŸæ¨¡æ§˜ã€‚ ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ãƒ—ãƒãƒ€ã‚¯ãƒˆã®ä¸å¿ƒçš„é–‹ç™ºè€…ãŸã¡ã‚’å¤šæ•°æ‹›ãå…¥ã‚Œã¦ããŸã‚µãƒ³ãƒ»ãƒžã‚¤ã‚¯ãƒã‚·ã‚¹ãƒ†ãƒ ã‚ºãŒä»Šå¾Œã€MySQLã‚’ã©ã®ã‚ˆã†ã«èˆµå–ã‚Šã—ã¦ã„ãã®ã‹ãŒæ³¨ç›®ã•ã‚Œã‚‹ã€‚ åŒãƒ–ãƒã‚°ã«ã‚ˆã‚‹ã¨ã€é€€è·ã®ç†ç”±ã¯MySQL 5.1GAç‰ˆã®ãƒªãƒªãƒ¼ã‚¹ã‚¿ã‚¤ãƒŸãƒ³ã‚°ã‚„ã€Serverç‰ˆã®é–‹ç™ºãªã©ã§ã€ã‚µãƒ³ãƒ»ãƒžã‚¤ã‚¯ãƒã‚·ã‚¹ãƒ†ãƒ å´ã¨æ„è¦‹ãŒé£Ÿã„é•ã£ãŸã“ã¨ãªã©ãŒä¸»ãªåŽŸå› ã ã¨ã„ã†ã€‚ ç¾åœ¨åŒæ°ã¯ã€ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³Maria 1.5ã®æ£å¼ç‰ˆãƒªãƒªãƒ¼ã‚¹ã‚„Maria 2.0ï¼ˆãƒ•ãƒ«ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³å¯¾å¿œç‰ˆï¼‰ã®é–‹ç™ºã€ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹å‘¨ã‚Šã®èª¿æ•´ã«ç€æ‰‹ã—
kosaki 2009/02/07
ã¾ã‚äºˆæƒ³ã§ããŸã‚ãª

MySQL
ãƒªãƒ³ã‚¯
é©å‘½ã®æ—¥ã€…ï¼ MySQLãŒlinuxã§é…ã„ã®ã¯glibc mallocã®ã›ã„ï¼Ÿ
http://blog.miraclelinux.com/yume/2007/02/mysql linux_472a.html MySQLã®ãƒžãƒ«ãƒã‚³ã‚¢ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ã¨Linux ã‚¹ãƒ©ãƒƒã‚·ãƒ¥ãƒ‰ãƒƒãƒˆã®æƒ…å ±ã€‚FreeBSDã¨Linuxã§sysbench(MySQLã‚’åˆ©ç”¨ã—ã¦ã„ã‚‹)ã®çµæžœãŒå‡ºã¦ã„ã‚‹ã€‚çµè«–ã‹ã‚‰è¨€ã†ã¨8ã‚³ã‚¢ã®AMD64ã®ãƒžã‚·ãƒ³ã§ã‚¹ãƒ¬ãƒƒãƒ‰æ•°ã‚’ä¸Šã’ã¦ã„ãã¨8ã‚¹ãƒ¬ãƒƒãƒ‰ã¾ã§ã¯Linuxã§ã®æ€§èƒ½ãŒè‰¯ã‹ã£ãŸãŒã€ãã‚Œä»¥ä¸Šã«ãªã‚‹ã¨ãŒãŸã£ã¨æ€§èƒ½ãŒåŠ£åŒ–ã—ã¦ã€FreeBSDã®SMPngã®å®Ÿè£…ãŒå‹ã¤ã€‚ ä¸‹è¨˜ã‚’å‚ç…§ã—ã¦ã»ã—ã„ã€‚ http://jeffr-tech.livejournal.com/6268.html ã‚ã‚Œã¡ã‚ƒã†ã‹ã€‚ ãŸã¶ã‚“ã€MySQLãŒãƒžãƒ«ãƒã‚¹ãƒ¬ãƒƒãƒ‰ç’°å¢ƒä¸‹ã§mallocã¨freeãŒæ¯Žå›žç•°ãªã‚‹ã‚¹ãƒ¬ãƒƒãƒ‰ã«ãªã£ã¦ã„ã‚‹ã‚“ã¡ã‚ƒã†ã‹ã€‚ mallocã‹freeã®ã©ã¡ã‚‰ã‹ãŒãƒžãƒãƒ¼ã‚¸ãƒ£ãƒ¼ã‚¹ãƒ¬ãƒƒãƒ‰ã§ã¾ã¨ã‚ã¦ã‚„ã£ã¦ã„ã‚‹
kosaki 2007/03/21
mysql

prog

ã‚¹ãƒ©ãƒƒã‚·ãƒ¥ãƒ‰ãƒƒãƒˆ

MySQL

malloc

Linux

Google

glibc

FreeBSD

cache
ãƒªãƒ³ã‚¯
1