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

webmarksjp id:webmarksjp

sqlã¨performanceã«é–¢ã™ã‚‹webmarksjpã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (8)

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

1ã¤ã®SQLæ–‡ã§è¤‡æ•°ã®è¡¨ã«INSERTã™ã‚‹çµ¶å“ãƒ†ã‚¯ãƒ‹ãƒƒã‚¯ï¼ˆ1/2ï¼‰ â€• ï¼ IT
æœ¬é€£è¼‰ã¯SQLã®å¿œç”¨åŠ›ã‚’èº«ã«ä»˜ã‘ãŸã„ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢å‘ã‘ã«ã€ã•ã¾ã–ã¾ãªãƒ†ã‚¯ãƒ‹ãƒƒã‚¯ã‚’ç´¹ä»‹ã™ã‚‹ã€‚SQLã®åŸºæœ¬æ§‹æ–‡ã¯å¹³æ˜“ãªã‚‚ã®ã ãŒã€å®Ÿå‹™ã§æ´»ç”¨ã™ã‚‹ã«ã¯æ•™ç§‘æ›¸çš„ãªè¨˜è¿°ã‚’ç†è§£ã™ã‚‹ã ã‘ã§ã¯ä¸ååˆ†ã ã€‚æœ¬é€£è¼‰ã¯ã€è‘—åãªãƒ¡ãƒ¼ãƒ«ãƒžã‚¬ã‚¸ãƒ³ã€ŒãŠã‚‰ï¼ã‚ªãƒ©ï¼ Oracle - ã©ã£ã·ã‚Šæ¤œè¨¼ç”Ÿæ´»ã€ã‚’ç™ºè¡Œã™ã‚‹ã‚¤ãƒ³ã‚µã‚¤ãƒˆãƒ†ã‚¯ãƒŽãƒã‚¸ãƒ¼ã®ã‚³ãƒ³ã‚µãƒ«ã‚¿ãƒ³ãƒˆã‚’åŸ·ç†é™£ã«è¿Žãˆã€SQLã®ã‚»ãƒ³ã‚¹å‘ä¸Šã«å½¹ç«‹ã¤å¤§æŠ€å°æŠ€ã‚’ç´¹ä»‹ã—ã¦ã„ãã€‚ï¼ˆç·¨é›†å±€ï¼‰ FOR...LOOPæ–‡ã‚’ä½¿ã£ã¦ã€ã„ãã¤ã‚‚ã®SQLæ–‡ã§ãƒ‡ãƒ¼ã‚¿ã‚’INSERTã—ã¦ã„ã‚‹PL/SQLãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ã‚„ãƒ—ãƒã‚°ãƒ©ãƒ ã‚’ã‚ˆãè¦‹æŽ›ã‘ã¾ã™ãŒã€å®Ÿã¯1åº¦ã«ãƒ‡ãƒ¼ã‚¿ã‚’INSERTã™ã‚‹æ–¹æ³•ã‚‚ã‚ã‚‹ã‚“ã§ã™ã€‚ãƒžãƒ«ãƒãƒ†ãƒ¼ãƒ–ãƒ«ãƒ»ã‚¤ãƒ³ã‚µãƒ¼ãƒˆï¼ˆMultitable Insertï¼‰ã¨ã¯ãã®åã®ã¨ãŠã‚Šã€1ã¤ã®SQLæ–‡ã§è¤‡æ•°ã®è¡¨ã«INSERTãŒå¯èƒ½ã«ãªã‚Šã¾ã™ã€‚ã“ã®æœ€å¤§ã®ãƒ¡ãƒªãƒƒãƒˆã¯ã€ã‚„ã¯ã‚Šãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã§ã™ã€‚ã§ã¯æ—©é€Ÿã”ç´¹ä»‹ã—ã¾ã™ã€‚ ãƒžãƒ«ãƒãƒ†ãƒ¼ãƒ–
webmarksjp 2008/07/14
#|Ï‰-ï¼‰â€¦â€¦

SQL

performance

oracle

database

ãƒ—ãƒã‚°ãƒ©ãƒ
ãƒªãƒ³ã‚¯
GT Nitro: ã‚«ãƒ¼ãƒ¬ãƒ¼ã‚·ãƒ³ã‚°ãƒ»ãƒ‰ãƒ©ãƒƒã‚°ãƒ¬ãƒ¼ã‚·ãƒ³ã‚°ã‚²ãƒ¼ãƒ - Google Play ã®ã‚¢ãƒ—ãƒª
GT Nitro: Car Game Drag Raceã¯ã€å…¸åž‹çš„ãªã‚«ãƒ¼ã‚²ãƒ¼ãƒ ã§ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ã“ã‚Œã¯ã‚¹ãƒ”ãƒ¼ãƒ‰ã€ãƒ‘ãƒ¯ãƒ¼ã€ã‚¹ã‚ãƒ«å…¨é–‹ã®ã‚«ãƒ¼ãƒ¬ãƒ¼ã‚¹ã‚²ãƒ¼ãƒ ã§ã™ã€‚ãƒ–ãƒ¬ãƒ¼ã‚ã¯å¿˜ã‚Œã¦ã€ã“ã‚Œã¯ãƒ‰ãƒ©ãƒƒã‚°ãƒ¬ãƒ¼ã‚¹ã€ãƒ™ã‚¤ãƒ“ãƒ¼ï¼å¤å…¸çš„ãªã‚¯ãƒ©ã‚·ãƒƒã‚¯ã‹ã‚‰æœªæ¥çš„ãªãƒ“ãƒ¼ã‚¹ãƒˆã¾ã§ã€æœ€ã‚‚ã‚¯ãƒ¼ãƒ«ã§é€Ÿã„è»Šã¨ã‚«ãƒ¼ãƒ¬ãƒ¼ã‚¹ã§ãã¾ã™ã€‚ã‚¹ãƒ†ã‚£ãƒƒã‚¯ã‚·ãƒ•ãƒˆã‚’ãƒžã‚¹ã‚¿ãƒ¼ã—ã€ãƒ‹ãƒˆãƒã‚’è³¢ãä½¿ã£ã¦ç«¶äº‰ã‚’æ‰“ã¡ç ´ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ã“ã®ã‚«ãƒ¼ãƒ¬ãƒ¼ã‚¹ã‚²ãƒ¼ãƒ ã¯ãã®ãƒªã‚¢ãƒ«ãªç‰©ç†å¦ã¨ç´ æ™´ã‚‰ã—ã„ã‚°ãƒ©ãƒ•ã‚£ãƒƒã‚¯ã‚¹ã§ã‚ãªãŸã®å¿ƒã‚’çˆ†ç™ºã•ã›ã¾ã™ã€‚ã“ã‚Œã¾ã§ãƒ—ãƒ¬ã‚¤ã—ãŸã“ã¨ã®ãªã„ã‚ˆã†ãªã‚‚ã®ã§ã™ã€‚ GT Nitroã¯ã€ãƒªãƒ•ãƒ¬ãƒƒã‚¯ã‚¹ã¨ã‚¿ã‚¤ãƒŸãƒ³ã‚°ã‚’è©¦ã™ã‚«ãƒ¼ãƒ¬ãƒ¼ã‚¹ã‚²ãƒ¼ãƒ ã§ã™ã€‚æ£ã—ã„çž¬é–“ã«ã‚®ã‚¢ã‚’ã‚·ãƒ•ãƒˆã—ã€ã‚¬ã‚¹ã‚’æ€ã„åˆ‡ã‚Šè¸ã‚€å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ã¾ãŸã€å¤§ç‰©ãŸã¡ã¨ç«¶ã„ã¤ã¤ã€è»Šã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã¨ã‚¢ãƒƒãƒ—ã‚°ãƒ¬ãƒ¼ãƒ‰ã‚‚è¡Œã‚ãªã‘ã‚Œã°ãªã‚Šã¾ã›ã‚“ã€‚ä¸–ç•Œä¸ã§æœ€é«˜ã®ãƒ‰ãƒ©ã‚¤ãƒãƒ¼ã¨è»Šã¨ã‚«ãƒ¼ãƒ¬ãƒ¼ã‚¹ã«æŒ‘ã‚€ã“ã¨ã«ãªã‚Šã€ãƒ‰ãƒ©ãƒƒã‚°ãƒ¬ãƒ¼ã‚¹ã®çŽ‹å†
webmarksjp 2008/07/14
MySQL

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

DB

performance

tips

sql

ã‚ãƒ£ãƒªã‚¢
ãƒªãƒ³ã‚¯
MySQLã®æœ€é©åŒ–
é™ã‚Šãªãçœ æ°—ã‚’èª˜ã†PHP Internalsã®ã‚»ãƒƒã‚·ãƒ§ãƒ³ã‹ã‚‰é€ƒã’ã‚‹ã€‚ã“ã£ã¡ã® è¬›å¸«ã¯MySQL.comã®äººã€‚è¬›æ¼”æ…£ã‚Œã—ã¦ã„ã¦ã€ãšã£ã¨ã¾ã¨ã‚‚ã§ãƒ—ãƒãƒ•ã‚§ãƒƒã‚·ãƒ§ãƒŠãƒ«ãª æ„Ÿã˜ã€‚åˆå‰ä¸ã‚’é€ƒã—ãŸã®ãŒæƒœã—ã„ãŒã€è©³ã—ã„ãƒ—ãƒ¬ã‚¼ãƒ³è³‡æ–™ã¯å¾Œæ—¥å…¬é–‹ã•ã‚Œã‚‹ ã‚‰ã—ã„ã€‚ DELETEã®ã‚³ã‚¹ãƒˆã¯ã‹ãªã‚Šé«˜ã„ èªã¿ã ã—ãŒã™ã”ãå¤šã„å ´åˆã¯ç„¡åŠ¹åŒ–ã‚’ç¤ºã™ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰ã‚’ä½œã‚ŠUPDATEã™ã¹ãã€ indexæ›´æ–°ã®ã‚³ã‚¹ãƒˆãŒé¦¬é¹¿ã«ãªã‚‰ãªã„SHOW STATUSã®è¡¨ç¤ºçµæžœã®è§£æžæ–¹æ³• èµ·å‹•ã”ã¨ã«åˆæœŸåŒ–ã€å…¨ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«å…±é€šrnd ã¨ rnd_next ã®å‰²åˆKey_reads : Key_read_requests ã€ãƒ‡ã‚£ã‚¹ã‚¯ã‹ã‚‰èªã¾ã‚ŒãŸå›žæ•°ï¼šç·å›žæ•° ã“ã®å‰²åˆãŒ1:100ã‚ˆã‚Šæ‚ªããªã£ãŸã‚‰è¦æ³¨æ„Key_write_requests:Key_writes ç·æ›¸ãè¾¼ã¿è¦æ±‚å›žæ•°ï¼šãƒ‡ã‚£ã‚¹ã‚¯ã«æ›¸ãè¾¼ã¾ ã‚ŒãŸå›žæ•° ã‚ãƒ£ãƒƒã‚·ãƒ¥ã®åŠ¹æžœãªã©Max_used_con
webmarksjp 2008/07/14
db

SQL

mysql

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

æœ€é©åŒ–

performance

tuning
ãƒªãƒ³ã‚¯
ã‚µã‚¤ãƒœã‚¦ã‚ºæ ªå¼ä¼šç¤¾
ã‚µã‚¤ãƒœã‚¦ã‚ºã¯ã‚¯ãƒ©ã‚¦ãƒ‰ãƒ™ãƒ¼ã‚¹ã®ã‚°ãƒ«ãƒ¼ãƒ—ã‚¦ã‚§ã‚¢ã‚„æ¥å‹™æ”¹å–„ã‚µãƒ¼ãƒ“ã‚¹ã‚’è»¸ã«ã€ç¤¾ä¼šã®ãƒãƒ¼ãƒ ãƒ¯ãƒ¼ã‚¯å‘ä¸Šã‚’æ”¯æ´ã—ã¦ã„ã¾ã™ã€‚
webmarksjp 2008/07/14
è² è·åˆ†æ•£

senna

mysql

performance

DB

SQL

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

è² è·
ãƒªãƒ³ã‚¯
mir the archive
Contents æ›´æ–°:2007/08/31 MySQLå†…éƒ¨ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã¨ã‚½ãƒ¼ã‚¹è§£æž ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã¨ç›¸é–¢å›³ ä¸»è¦ã‚¯ãƒ©ã‚¹ã¨æ§‹é€ ä½“ ãƒ¦ãƒ¼ãƒ†ã‚£ãƒªãƒ†ã‚£é–¢æ•° ãƒ—ãƒªãƒ—ãƒã‚»ãƒƒã‚µãƒžã‚¯ãƒ ã‚°ãƒãƒ¼ãƒãƒ«å¤‰æ•° ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã‚¤ãƒ³ã‚¿ãƒ•ã‚§ãƒ¼ã‚¹ MySQL Hacking Tips InnoDBé–¢é€£ã®ã‚½ãƒ¼ã‚¹è§£æž InnoDBèµ·å‹•ãƒ—ãƒã‚»ã‚¹ InnoDBãƒãƒƒãƒ•ã‚¡ãƒ—ãƒ¼ãƒ«ã«é–¢ã™ã‚‹ã‚½ãƒ¼ã‚¹ã‚³ãƒ¡ãƒ³ãƒˆã®å’Œè¨³ InnoDB Recordæ§‹é€ MySQLã®æ‹¡å¼µ å¯å¤‰å¼•æ•°ã‚’æŒã¤NativeãªSQLé–¢æ•°ã®å®Ÿè£…æ–¹æ³• Warningã¨Errorã®å‡ºåŠ›æ–¹æ³• HelloWorldãƒã‚¿ GNU Autotoolsã§Hello World! ãã®ä»– ã‚µãƒ³ãƒ—ãƒ«ã‚³ãƒ¼ãƒ‰é›† å½“ã‚µã‚¤ãƒˆã¨ç®¡ç†è€…ã«ã¤ã„ã¦
webmarksjp 2008/07/13
MySQL

documentation

development

design

database

configuration

book

performance

source

sql
ãƒªãƒ³ã‚¯
PostgreSQLã‚’é…ãã—ã¦ã„ã‚‹çŠ¯äººã¯ã©ã“ã ï¼Ÿ
PostgreSQLã‚’é…ãã—ã¦ã„ã‚‹çŠ¯äººã¯ã©ã“ã ï¼Ÿï¼šLinuxãƒˆãƒ©ãƒ–ãƒ«ã‚·ãƒ¥ãƒ¼ãƒ†ã‚£ãƒ³ã‚°æŽ¢åµå›£ï¼ˆ3ï¼‰ï¼ˆ1/3 ãƒšãƒ¼ã‚¸ï¼‰ NTTã‚°ãƒ«ãƒ¼ãƒ—ã®å„ç¤¾ã§é³´ã‚‰ã—ãŸä¿ºãŸã¡Linuxãƒˆãƒ©ãƒ–ãƒ«ã‚·ãƒ¥ãƒ¼ãƒ†ã‚£ãƒ³ã‚°æŽ¢åµå›£ã¯ã€å„ç¤¾ã§åŸ¹ã£ãŸOSSé–¢é€£æŠ€è¡“ã‚’æ‰‹ã«ã€NTT OSSã‚»ãƒ³ã‚¿ã«é›†ã‚ã‚‰ã‚ŒãŸã€‚æ™®æ®µã¯åŸºæœ¬çš„ã«NTTã‚°ãƒ«ãƒ¼ãƒ—ã®ã¿ã‚’ç›¸æ‰‹ã«æ´»å‹•ã—ã¦ã„ã‚‹ãŒã€ãã‚Œã ã‘ã§çµ‚ã‚ã‚‹ä¿ºãŸã¡ã˜ã‚ƒã‚ãªã„ã€‚å¼•ãç¶šãOSSã«é–¢ã™ã‚‹ãƒˆãƒ©ãƒ–ãƒ«ã®è§£æ±ºéŽç¨‹ã‚’ï¼ ITã§é€£è¼‰ã—ã¦ã„ããœã€‚ ã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ã•ãˆã‚ã‚Œã°ã©ã‚“ãªãƒˆãƒ©ãƒ–ãƒ«ã§ã‚‚è§£æ±ºã™ã‚‹å‘½çŸ¥ã‚‰ãšã€ä¸å¯èƒ½ã‚’å¯èƒ½ã«ã—ã€å¤šãã®ãƒã‚°ã‚’ç²‰ç •ã™ã‚‹ã€ä¿ºãŸã¡Linuxãƒˆãƒ©ãƒ–ãƒ«ã‚·ãƒ¥ãƒ¼ãƒ†ã‚£ãƒ³ã‚°æŽ¢åµå›£ï¼ã€€åŠ©ã‘ã‚’å€Ÿã‚ŠãŸã„ã¨ãã¯ã€ã„ã¤ã§ã‚‚ã„ã£ã¦ãã‚Œï¼ OSï¼šé«˜ç”°å“²ç”Ÿ ä¿ºã¯ãƒªãƒ¼ãƒ€ãƒ¼ã€é«˜ç”°å“²ç”Ÿã€‚Linuxã®é”äººã€‚ä¿ºã®ã‚ˆã†ã«ã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ãƒ¬ãƒ™ãƒ«ã§OSã‚’ç†è§£ã—ã¦ã„ã‚‹äººé–“ã§ãªã‘ã‚Œã°ã€ç™¾æˆ¦éŒ¬ç£¨ã®Linuxãƒˆãƒ©ãƒ–ãƒ«ã‚·ãƒ¥ãƒ¼ãƒ†ã‚£ãƒ³ã‚°æŽ¢åµå›£ã®ãƒªãƒ¼ãƒ€ãƒ¼ã¯å‹™ã¾ã‚‰ã‚“ã€‚
webmarksjp 2008/07/13
DB

SQL

PostgreSQL

Programming

database

performance

tuning
ãƒªãƒ³ã‚¯
ã€ŒDBã‚’æ£è¦åŒ–ã™ã‚‹ã¨é…ããªã‚‹ã€ã¯èª¤è§£ï¼Œå®Ÿè¨¼å®Ÿé¨“ã®çµæžœãŒå…¬é–‹ã«
ãƒ‡ãƒ¼ã‚¿ãƒ»ãƒ¢ãƒ‡ãƒªãƒ³ã‚°ã®æ™®åŠå›£ä½“ï¼ŒDOA+ã‚³ãƒ³ã‚½ãƒ¼ã‚·ã‚¢ãƒ ã¯ã“ã®ã»ã©ï¼Œãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ»ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç®¡ç†ã‚·ã‚¹ãƒ†ãƒ ï¼ˆRDBMSï¼‰ã®å‡¦ç†æ€§èƒ½ã«é–¢ã™ã‚‹å®Ÿè¨¼è©¦é¨“ã‚’è¡Œã„ï¼Œèª¿æŸ»çµæžœã‚’å…¬é–‹ã—ãŸã€‚ã€Œãƒ‡ãƒ¼ã‚¿ã‚’æ£è¦åŒ–ã—ã¦ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«å®Ÿè£…ã™ã‚‹ã¨ï¼Œå‡¦ç†æ€§èƒ½ãŒä½Žä¸‹ã™ã‚‹ã€ã¨ã„ã†â€œèª¤è§£â€ã‚’æ£ã™ãŸã‚ï¼Œå®Ÿè¨¼å®Ÿé¨“ã‚’è¡Œã£ãŸã¨ã„ã†ã€‚ ãƒ‡ãƒ¼ã‚¿ã‚’æ£è¦åŒ–ã—ã¦å®Ÿè£…ã—ãŸã¨ãã¨ï¼Œéžæ£è¦åŒ–ã—ã¦å®Ÿè£…ã—ãŸã¨ãã®å‡¦ç†æ€§èƒ½ã®é•ã„ã‚’èª¿ã¹ãŸçµæžœï¼Œã€Œæ£è¦åŒ–ã—ã¦å®Ÿè£…ã—ãŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æ–¹ãŒå‡¦ç†æ€§èƒ½ãŒé«˜ã„ã€ï¼Œã€Œéžæ£è¦åŒ–ã—ã¦å®Ÿè£…ã—ãŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’æ“ä½œã™ã‚‹éš›ï¼Œãƒ†ãƒ¼ãƒ–ãƒ«çµåˆï¼ˆJOINï¼‰ãŒç™ºç”Ÿã™ã‚‹å‡¦ç†ã‚’è¡Œã†ã¨ï¼Œå‡¦ç†æ€§èƒ½ãŒä½Žããªã‚‹ã€ã¨çµè«–ä»˜ã‘ãŸã€‚ å®Ÿè¨¼å®Ÿé¨“ã§ã¯ï¼Œè‡ªå‹•è»Šã®å—æ³¨æ¥å‹™ã‚’æƒ³å®šã—ãŸWebã‚·ã‚¹ãƒ†ãƒ ã‚’æ§‹ç¯‰ã—ã¦ï¼Œå‡¦ç†æ€§èƒ½ã‚’æ¸¬å®šã—ãŸã€‚ã“ã®Webã‚·ã‚¹ãƒ†ãƒ ã¯ï¼Œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ä¸Šã«æ ¼ç´ã•ã‚ŒãŸå—æ³¨ãƒ‡ãƒ¼ã‚¿ã‚’åŸºã«ï¼Œè£½å“ãƒ‡ãƒ¼ã‚¿ã‚„éƒ¨å“ãƒ‡ãƒ¼ã‚¿ï¼Œéƒ¨å“ãƒ¡ãƒ¼ã‚«ã®ãƒ‡ãƒ¼ã‚¿ãªã©ã‚’æ¤œç´¢ã™ã‚‹ã€‚ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å®Ÿè£…ã®é•ã„
webmarksjp 2008/07/12
PostgreSQL

database

performance

ã‚ã¨ã§èªã‚€

SI

SQL

DB

ãƒ‹ã‚³ãƒ‹ã‚³å‹•ç”»

è² è·åˆ†æ•£

mysql
ãƒªãƒ³ã‚¯
ã€MySQLã‚¦ã‚©ãƒƒãƒã€‘ç¬¬8å›ž MySQLãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®ãƒ†ã‚¯ãƒ‹ãƒƒã‚¯ï¼šITpro
SlowLogã®è¨å®š ç’°å¢ƒè¨å®šãƒ•ã‚¡ã‚¤ãƒ«(Windowsã§ã¯my.iniï¼ŒLinuxã§ã¯my.cnf)ã«æ¬¡ã®ã‚ˆã†ãªè¨å®šã‚’åŠ ãˆã‚‹ã¨SlowLogãŒæœ‰åŠ¹ã«ãªã‚‹ã€‚ log-slow-queries SlowLogã®æœ‰åŠ¹åŒ–(ãƒã‚°ãƒ•ã‚¡ã‚¤ãƒ«åã‚’æŒ‡å®šå¯èƒ½) long-query-time=2 SlowLogã«è¨˜éŒ²ã™ã‚‹å‡¦ç†æ™‚é–“ã®ä¸Šé™ log-long-format ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ä½¿ç”¨ã—ãªã„SQLæ–‡ã®è¨˜éŒ² long-query-timeãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã¯ï¼ŒSlowLogã«è¨˜éŒ²ã™ã‚‹ã—ãã„å€¤ã‚’ç§’å˜ä½ã§è¨å®šã™ã‚‹ã€‚ã“ã®å ´åˆã«ã¯ï¼Œ2ç§’è¶…ãˆã‚‹å‡¦ç†æ™‚é–“ã‚’è²»ã‚„ã—ãŸSQLæ–‡ã‚’è¨˜éŒ²ã™ã‚‹ã€‚ã¾ãŸï¼Œlog-long-formatã‚’æŒ‡å®šã™ã‚‹ã¨ï¼Œã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ä½¿ç”¨ã—ãªã„SQLæ–‡ã‚‚SlowLogã«è¨˜éŒ²ã™ã‚‹ã€‚ SlowLogã®ç¢ºèª SlowLogãŒå‹•ä½œã—ã¦ã„ã‚‹ã‹ã©ã†ã‹ã¯ï¼Œæ¬¡ã®ã‚³ãƒžãƒ³ãƒ‰ã§ç¢ºèªã§ãã‚‹ã€‚log_slow_queriesãŒONã§ã‚ã‚Œã°æœ‰åŠ¹ã¨
webmarksjp 2008/07/12
database

mysql

tips

performance

sql

tunning
ãƒªãƒ³ã‚¯
1