[B! tuning] koji-watanabeã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

koji-watanabe id:koji-watanabe

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

Winãƒžã‚·ãƒ³ãŒæœ€è¿‘é…ã„ãªãã¨æ„Ÿã˜ãŸã‚‰ã€ã€ŽGlary Utilitiesã€ | ãƒ©ã‚¤ãƒ•ãƒãƒƒã‚«ãƒ¼ãƒ»ã‚¸ãƒ£ãƒ‘ãƒ³
è³¼å…¥ã—ãŸå½“åˆã¯ã€ã‚ãƒ¥ãƒ³ã‚ãƒ¥ãƒ³å‹•ä½œã—ã¦ã„ãŸã®ã«ã€ã©ã†ã‚‚æœ€è¿‘ã€Windowsã®å‹•ä½œãŒé…ã„ã¨æ„Ÿã˜ã‚‹ã“ã¨ã¯ã‚ã‚Šã¾ã›ã‚“ã‹ï¼Ÿ WindowsãŒé…ããªã£ãŸã¨æ„Ÿã˜ã‚‹åŽŸå› ã¯æ§˜ã€…è€ƒãˆã‚‰ã‚Œã¾ã™ãŒã€ã²ã¨ã¤ãšã¤åŽŸå› ã‚’æ½°ã—ã¦ãƒ¡ãƒ³ãƒ†ãƒŠãƒ³ã‚¹ã«æ™‚é–“ã‚’å–ã‚‰ã‚Œã‚‹ã®ã¯ç°¡ä¾¿ã—ã¦æ¬²ã—ã„ã®ã§ã€é¢å€’ãªæ“ä½œç„¡ã—ã§è§£æ¶ˆã—ã¦ãã‚Œã‚‹ãƒ„ãƒ¼ãƒ«ã«ç™»å ´é¡˜ã„ãŸã„ã‚‚ã®ã§ã™ã€‚ç§ã¨åŒã˜ã‚ˆã†ã«æ„Ÿã˜ã¦ã„ã‚‹æ–¹ãŒã„ãŸã‚‰ã€ŽGlary Utilitiesã€ã‚’ãŠå‹§ã‚ã—ã¾ã™ã€‚ ç¶šãã¯ã€ä»¥ä¸‹ã§ã€‚ ã€ŽGlary Utilitiesã€ã¯ã€ãƒ‡ã‚£ã‚¹ã‚¯/ãƒ¬ã‚¸ã‚¹ãƒˆãƒªã‚¯ãƒªãƒ¼ãƒŠãƒ¼ã‚„ã‚¢ãƒ³ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ãƒžãƒãƒ¼ã‚¸ãƒ£ã€ãƒ¡ãƒ¢ãƒªãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ãƒ„ãƒ¼ãƒ«ã€ãƒ‡ã‚£ã‚¹ã‚¯è§£æžã€ãƒ—ãƒã‚»ã‚¹ãƒžãƒãƒ¼ã‚¸ãƒ£ãªã©ã®ãƒ¢ãƒ‹ã‚¿ãƒªãƒ³ã‚°ãƒ„ãƒ¼ãƒ«ãªã©ã€Windowsã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’æ”¹å–„ã™ã‚‹ãƒ„ãƒ¼ãƒ«ã‚’çµ±åˆã—ãŸã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã§ã™ã€‚ ã€ŽGlary Utilitiesã€ã®ç›®çŽ‰ã¯ã€ãƒœã‚¿ãƒ³ã‚’ãƒ¯ãƒ³ã‚¯ãƒªãƒƒã‚¯ã™ã‚‹ã ã‘ã§Windowsã®å•é¡Œç‚¹ã‚’ã‚¹ã‚ãƒ£ãƒ³ã—ã¦ãã‚Œã‚‹ã€Œ1ã‚¯ãƒªãƒƒ
koji-watanabe 2009/10/20
ä½¿ã£ã¦ã¿ã‚‹ã€‚

tips

tools

free

windows

software

performance

tuning

utility
ãƒªãƒ³ã‚¯
ã€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ã§ã‚ã‚Œã°æœ‰åŠ¹ã¨
koji-watanabe 2009/06/29
MySQL

tuning

slowquery

explain

tips
ãƒªãƒ³ã‚¯
OTN Japan - Oracleãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ æ€§èƒ½å¯¾ç–æ©Ÿèƒ½ ã€œ Statspackã¨Diagnostics Packã‚’ä½¿ã„ã“ãªã™ ã€œ ç¬¬1å›ž Statspackã¨Diagnostics Packã®æ¦‚è¦ã¨ä½¿ç”¨æ–¹æ³•
NTTã‚³ãƒ ã‚¦ã‚§ã‚¢æ ªå¼ä¼šç¤¾ ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆç®¡ç†çµ±æ‹¬éƒ¨ã€€æŠ€è¡“SEéƒ¨é–€ã€€DB æŠ€è¡“ã‚°ãƒ«ãƒ¼ãƒ— å‚ä¸‹ã€€å¾¹ Oracleãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æ€§èƒ½å¯¾ç–ã®é‡è¦ãªæ©Ÿèƒ½ã€ã€ŒStatspackã€ã‚„ã€ŒOracle Enterprise Manager 10g Diagnostics Packã€(â€»ã‚ªãƒ—ã‚·ãƒ§ãƒ³ãƒ©ã‚¤ã‚»ãƒ³ã‚¹)ã®åˆ©ç”¨ãƒã‚¤ãƒ³ãƒˆã‚’ãŠä¼ãˆã—ã¾ã™ã€‚ä½¿ã‚ãªã„ã¨"ã‚‚ã£ãŸã„ãªã„"æ©Ÿèƒ½ã§ã™ï¼(Diagnostics Packã®æœ‰ç„¡ã«ã‚ˆã‚‹é•ã„ã¯ã“ã“) - INDEX - â– 1 ã¯ã˜ã‚ã« â– 2 æ€§èƒ½å¯¾ç–æ¦‚è¦ â– 3 Statspack ãƒ» 3.1 ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« ãƒ» 3.2 ãƒ¡ãƒ³ãƒ†ãƒŠãƒ³ã‚¹ ãƒ» 3.3 ãƒ¬ãƒãƒ¼ãƒˆä½œæˆ ãƒ» 3.4 StatspackãŒä¸å‘ããªã‚±ãƒ¼ã‚¹ â– 4 Diagnostics Pack ãƒ» 4.1 Automatic Workload Repository (AWR) ãƒ» 4.2 Automatic Database
koji-watanabe 2009/06/04
tips

tuning

oracle

performance

statspack
ãƒªãƒ³ã‚¯
ãªãœMySQLã®ã‚µãƒ–ã‚¯ã‚¨ãƒªã¯é…ã„ã®ã‹ã€‚
ã‚ˆãMySQLã¯ã‚µãƒ–ã‚¯ã‚¨ãƒªãŒå¼±ã„ã¨è¨€ã‚ã‚Œã‚‹ãŒã€ã“ã‚Œã¯æœ¬å½“ã ã‚ã†ã‹ï¼ŸåŠåˆ†ã¯æœ¬å½“ã§åŠåˆ†ã¯å˜˜ã§ã‚ã‚‹ã€‚MySQLã®ã‚µãƒ–ã‚¯ã‚¨ãƒªã ã£ã¦ãªã‚“ã§ã‚‚ã‹ã‚“ã§ã‚‚é…ã„ã‚ã‘ã§ã¯ãªã„ã€‚è½ã¨ã—ç©´ã‚’ã—ã£ã‹ã‚Šé¿ã‘ã€ä½¿ã„ã©ã“ã‚ã‚’é–“é•ãˆãªã‘ã‚Œã°ã‚µãƒ–ã‚¯ã‚¨ãƒªã‚‚é«˜é€Ÿã«å®Ÿè¡Œã§ãã‚‹ã®ã§ã‚ã‚‹ã€‚ä»Šæ—¥ã¯MySQLãŒã©ã‚“ãªé¢¨ã«ã‚µãƒ–ã‚¯ã‚¨ãƒªã‚’å®Ÿè¡Œã—ã€ã©ã®ã‚ˆã†ãªå ´åˆã«é…ã„ã®ã‹ã¨ã„ã†ã“ã¨ã«ã¤ã„ã¦èª¬æ˜Žã—ã‚ˆã†ã€‚ EXPLAINã§å®Ÿè¡Œè¨ˆç”»ã‚’èª¿ã¹ãŸéš›ã«ã€select_typeã«ã¯ã‚¯ã‚¨ãƒªã®ç¨®é¡žãŒè¡¨ç¤ºã•ã‚Œã‚‹ã®ã ãŒã€ä»£è¡¨çš„ãªã‚µãƒ–ã‚¯ã‚¨ãƒªã«ã¯æ¬¡ã®3ã¤ã®ãƒ‘ã‚¿ãƒ¼ãƒ³ãŒã‚ã‚‹ã€‚ SUBQUERY DEPENDENT SUBQUERY DERIVED çµè«–ã‹ã‚‰è¨€ãŠã†ã€‚é…ã„ã®ã¯2ç•ªç›®ã€DEPENDENT SUBQUERYã§ã‚ã‚‹ã€‚DEPENDENT SUBQUERYã¨ã¯ã„ã‚ã‚†ã‚‹ç›¸é–¢ã‚µãƒ–ã‚¯ã‚¨ãƒªã«ç›¸å½“ã™ã‚‹ã‚‚ã®ã§ã€ã‚µãƒ–ã‚¯ã‚¨ãƒªã«ãŠã„ã¦å¤–éƒ¨ã‚¯ã‚¨ãƒªã®ã‚«ãƒ©ãƒ ã‚’å‚ç…§ã—ã¦ã„ã‚‹ã‚µãƒ–ã‚¯ã‚¨ãƒªã®ã“ã¨ã§ã‚ã‚‹ã€‚ãã—
koji-watanabe 2009/03/25
ä»Šæ—¥ã¯MySQLãŒã©ã‚“ãªé¢¨ã«ã‚µãƒ–ã‚¯ã‚¨ãƒªã‚’å®Ÿè¡Œã—ã€ã©ã®ã‚ˆã†ãªå ´åˆã«é…ã„ã®ã‹ã¨ã„ã†ã“ã¨ã«ã¤ã„ã¦èª¬æ˜Žã—ã‚ˆã†ã€‚

tips

MySQL

tuning

ã‚ã¨ã§èªã‚€
ãƒªãƒ³ã‚¯
æ¼¢(ã‚ªãƒˆã‚³)ã®ã‚³ãƒ³ãƒ”ãƒ¥ãƒ¼ã‚¿é“: MySQLã‚’é«˜é€ŸåŒ–ã™ã‚‹10ã®æ–¹æ³•
ã¡ã‚‡ã£ã¨ã‚ãƒ£ãƒƒãƒâˆ’ãªã‚¿ã‚¤ãƒˆãƒ«ã‚’ã¤ã‘ã¦ã—ã¾ã£ãŸãŒã€ä»Šæ—¥ã¯ç‹¬æ–ã¨åè¦‹ã§MySQLã‚’é«˜é€ŸåŒ–ã™ã‚‹æ–¹æ³•ã‚’10å€‹ç´¹ä»‹ã—ã‚ˆã†ã€‚MySQLã‚µãƒ¼ãƒã‚’ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã™ã‚‹ã¨ãã‚„åˆæœŸå°Žå…¥ã™ã‚‹å ´åˆãªã©ã«å‚è€ƒã«ã—ã¦ã‚‚ã‚‰ã„ãŸã„ã€‚ 1. ãƒãƒƒãƒ•ã‚¡ã‚’å¢—ã‚„ã™ã€ã¾ãŸã¯æ¸›ã‚‰ã™ ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®åŸºæœ¬ä¸ã®åŸºæœ¬ã§ã‚ã‚‹ãŒã€é©åˆ‡ãªãƒãƒƒãƒ•ã‚¡ã‚µã‚¤ã‚ºã‚’è¨å®šã™ã‚‹ã“ã¨ã¯ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®è¦ã§ã‚ã‚‹ã€‚ä¸»ãªãƒãƒƒãƒ•ã‚¡ã¯æ¬¡ã®é€šã‚Šã€‚ innodb_buffer_pool_sizeãƒ»ãƒ»ãƒ»InnoDBã ã‘ã‚’åˆ©ç”¨ã™ã‚‹å ´åˆã¯ç©ºããƒ¡ãƒ¢ãƒªã®7ã€œ8å‰²ç¨‹åº¦ã‚’å‰²ã‚Šå½“ã¦ã‚‹æœ€ã‚‚é‡è¦ãªãƒãƒƒãƒ•ã‚¡ã§ã‚ã‚‹ã€‚ä½™è«‡ã ãŒã€å®Ÿéš›ã«ã¯ã“ã“ã§å‰²ã‚Šå½“ã¦ãŸå€¤ã®5ã€œ10%ãã‚‰ã„ã‚’å¤šã‚ã«ãƒ¡ãƒ¢ãƒªã‚’ä½¿ã†ã®ã§æ³¨æ„ãŒå¿…è¦ã ã€‚ key_buffer_sizeãƒ»ãƒ»ãƒ»MyISAMã ã‘ã‚’åˆ©ç”¨ã™ã‚‹å ´åˆã¯ã€ç©ºããƒ¡ãƒ¢ãƒªã®3å‰²ç¨‹åº¦ã‚’å‰²ã‚Šå½“ã¦ã‚‹ã¨ã„ã„ã€‚æ®‹ã‚Šã¯ãƒ•ã‚¡ã‚¤ãƒ«ã‚·ã‚¹ãƒ†ãƒ ã®ã‚ãƒ£ãƒƒã‚·ãƒ¥ç”¨ã«æ®‹ã—ã¦ãŠã“ã†ã€‚ sort_buffer_
koji-watanabe 2009/02/19
MySQLãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°

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

tuning

*mysql
ãƒªãƒ³ã‚¯
ãƒ¡ãƒ¢ãƒªã‚’é£Ÿã„ã¾ãã‚‹ãƒ—ãƒã‚»ã‚¹ãŒãƒ¡ãƒ¢ãƒªä½¿ç”¨é‡ã«ä¸Žãˆã‚‹å½±éŸ¿ã‚’topã§è¿½ã†
æš´èµ°ã—ã¦ã©ã‚“ã©ã‚“ãƒ¡ãƒ¢ãƒªã‚’é£Ÿã†ã‚¹ã‚¯ãƒªãƒ—ãƒˆãŒ OSå…¨ä½“ã®ãƒ¡ãƒ¢ãƒªä½¿ç”¨é‡(CentOS5 ... ã‚«ãƒ¼ãƒãƒ«ã¯2.6ç³»ã«ãªã‚‹)ã®å‹•ä½œã«ã©ã‚“ãªå½±éŸ¿ã‚’ä¸Žãˆã‚‹ã®ã‹ã€€ã£ã¦ã®ã‚’è¦‹ã‚‹ãŸã‚ã«ä»¥ä¸‹ã®ã‚ˆã†ãªãƒ†ã‚¹ãƒˆã‚’ã—ã¦ã¿ã¾ã—ãŸã€‚ä»•çµ„ã¿ã¯ã ã„ãŸã„ç†è§£ã—ã¦ã‚‹ã‘ã©ã€ç´°ã‹ã„æ•°å€¤ã‚’è¿½ã£ãŸã“ã¨ã¯ãªã‹ã£ãŸã®ã§ã‚„ã£ã¦ã¿ã¾ã—ãŸã€‚ sshã§ãƒã‚°ã‚¤ãƒ³ã—ã¦ã€topã‚’ç«‹ã¡ä¸Šã’ã‚‹ã€‚ãƒ—ãƒã‚»ã‚¹ã‚’è¦‹å¼µã‚‹ç”¨æ„ã‚’ã—ã¦ãŠã åˆ¥ã®sshã‚’ãŸã¡ã‚ã’ã¦ã€ Perlãƒ¯ãƒ³ãƒ©ã‚¤ãƒŠãƒ¼ã§ä»¥ä¸‹ã®ã‚ˆã†ãªãƒ—ãƒã‚»ã‚¹ã‚’èµ°ã‚‰ã›ã‚‹(ã“ã®ãƒ—ãƒã‚»ã‚¹ã‚’topã§è¦‹å¼µã‚‹) # 1ç§’ã”ã¨ã«5MBå˜ä½ã§ãƒ¡ãƒ¢ãƒªã‚’é£Ÿã†ãƒ—ãƒã‚»ã‚¹ # æ•°å€¤ã¯ãŠå¥½ã¿ã§ perl -e "while(1){ sleep 1; push @h , 1 x 1024 x 1024 x 5 } " ã¡ãªã¿ã«topã§è¦‹å¼µã‚‹ã¨ãã¯ ãƒ¡ãƒ¢ãƒªä½¿ç”¨é‡ã§ã‚½ãƒ¼ãƒˆã•ã‚Œã‚‹ã‚ˆã†ã«ã—ã¦ topèµ·å‹•ä¸ã« shift + o ã‚’æŠ¼ã—ã¦ n ã‚’æŠ¼ã™ã¨ å®Ÿãƒ¡ãƒ¢ãƒª
koji-watanabe 2009/02/18
*ã‚ã¨ã§èªã‚€

tips

tuning

linux

memory

top
ãƒªãƒ³ã‚¯
Firefoxé«˜é€ŸåŒ–æˆåŠŸ - ã‚†ã†ã·ãºã®æ–¹æ³•è«–
Firefoxå¿«é©å¿«é©ã€‚ Greasemonkeyã¨ã‹Addonså…¥ã‚ŒéŽãŽãŸã‚‰ã€ã‹ãªã‚Šé‡ããªã£ã¦ã€ ã‚ã‚ãƒ¼ãƒ¼å…ƒã®æœ¨ç¶²ã£ã¦æ€ã£ã¦ãŸã‚‰ã€ä»¥ä¸‹ã®ãƒšãƒ¼ã‚¸ã§è§£æ±ºã€‚ ã‘ã£ã“ã†å¤ã„ã‚¨ãƒ³ãƒˆãƒªã ã£ãŸã‹ã‚‰ã€ã¡ã‚ƒã‚“ã¨å‹•ãã‹å¿ƒé…ã ã£ãŸã‘ã©ã€ Firefox ãƒãƒ¼ã‚¸ãƒ§ãƒ³3ã«ãªã£ã¦ã‚‚åŸºæœ¬ä»•æ§˜ã¯å¤‰ã‚ã£ã¦ãªã„æ¨¡æ§˜ã§ã€ è©¦ã—ãŸã‚‰æ™®é€šã«é€Ÿããªã£ãŸã®ã§ã€ï¼’å¹´å‰ã«è¦‹ã¤ã‘ã¦ãŸã‚‰ãƒ»ãƒ» ãªã‚“ã¦æ€ã„ãªãŒã‚‰ã€Firefoxå†ãƒ‡ãƒ“ãƒ¥ãƒ¼ã‚’æžœãŸã—ãŸã®ã ã£ãŸã€‚ã€‚ http://apple-shop.jugem.jp/?eid=67 â—† 2004.12.16 Thursday â—† é…ã‚Œã°ã›ãªãŒã‚‰Firefoxé«˜é€ŸåŒ–, ã‹ãªãƒ¼ã‚Šé€Ÿããªã‚Šã¾ã—ãŸ<è¿½è¨˜> ã™ã£ã‹ã‚Šä¹—ã‚Šæ›ãˆã¦ã—ã¾ã£ãŸFirefoxã«ã¤ã„ã¦ã§ã™ã€‚ æ›¸ã“ã†æ›¸ã“ã†ã¨æ€ã£ã¦ã„ã¦å…ˆå»¶ã°ã—ã«ãªã£ã¦ã„ãŸã®ã§ã™ãŒã€ãƒ¡ãƒ¢ã¨ã—ã¦æ›¸ã„ã¦ãŠãã¾ã™ã€‚ ã¾ã è©¦ã—ã¦ãªã„æ–¹ã¯çµæ§‹ä½“æ„Ÿé€Ÿåº¦ãŒä¸ŠãŒã‚Šã¾ã™ã®ã§ãŠè©¦ã—ä¸‹ã•ã„ã€‚ ãƒ»
koji-watanabe 2008/12/16
browser

tips

firefox

tuning
ãƒªãƒ³ã‚¯
1