[B! *ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°] masa_matyaã®ãƒ

masa_matya id:masa_matya

*ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã«é–¢ã™ã‚‹masa_matyaã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (79)

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

Completed,Rendering,DBã®ç¶šãï¼ˆã‚½ãƒ¼ã‚¹ã‚’ã‚ˆã‚€ï¼‰ - urekatã®ã‚¹ã‚«ãƒ³ã‚¯æ—¥è¨˜ï¼“
actionpack-2.0.2/lib/action_controller/benchmarking.rb activerecord-2.0.2/lib/active_record/connection_adapters/abstract_adapter.rb actionpack-2.0.2/lib/action_controller/base.rb actionpack-2.0.2/lib/action_controller/filters.rb activerecord-2.0.2/lib/active_record/connection_adapters/mysql_adapter.rb å‡¦ç†é † process{ [routeã®å‡¦ç†ãŸã¶ã‚“ã“ã“ã€‚paramsã®æ§‹ç¯‰ã€controller/actionã®æ±ºå®š] perform_action_with_benchmark{ # benc
masa_matya 2011/09/09
completed : before_filter -> action -> view -> after_filterã¾ã§ã®å‡¦ç†æ™‚é–“

rails

*ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ãƒªãƒ³ã‚¯
IO Accounting æ©Ÿèƒ½ã§ I/O è² è·ã®é«˜ã„ãƒ—ãƒã‚»ã‚¹ã‚’ç‰¹å®š
éšåˆ†ä¹…ã€…ã® Linux ãƒã‚¿ã§ã™ã€‚ä»¥å‰ã«ãƒãƒ¼ãƒ‰ã‚¢ãƒ™ãƒ¬ãƒ¼ã‚¸ã«é–¢ã™ã‚‹è€ƒå¯Ÿãªã©ã®è¨˜äº‹ã‚‚æ›¸ãã¾ã—ãŸãŒã€å¤šãã®ã‚µãƒ¼ãƒãƒ¼ã‚µã‚¤ãƒ‰ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã¯ã‚µãƒ¼ãƒè² è·ã¨æ—¥ã€…æˆ¦ã£ã¦ã„ã‚‹ã“ã¨ã‹ã¨æ€ã„ã¾ã™ã€‚éŽåŽ»å¤šãã®å ´åˆã€è² è·ã®åŽŸå› ç‰¹å®šã¯ãŠãŠã‚ˆãä¸‹è¨˜ã®ã‚ˆã†ãªæ‰‹é †ã§åˆ†æžã‚’ã—ã¦ã„ãŸã“ã¨ã‹ã¨æ€ã„ã¾ã™ã€‚â€»è©³ã—ã„æ‰‹é †ã¯åˆ¥ã‚¨ãƒ³ãƒˆãƒªã¨ã—ã¦è¨˜è¼‰äºˆå®šã€‚ top ã‚’ã¿ã¦ä¸Šä½ã«å¼µã‚Šä»˜ã„ã¦ã„ã‚‹ãƒ—ãƒã‚»ã‚¹ã‚’ç¢ºèªã—ã¤ã¤ CPU or I/O ã®ã©ã¡ã‚‰ãŒåŽŸå› ã‹åˆ¤åˆ¥ ps ã‚’ä½¿ã£ã¦ãƒ—ãƒã‚»ã‚¹ã®çŠ¶æ…‹ã‚’ç¢ºèªã—ã¦(T),(D)ã®çŠ¶æ…‹ã‹ã‚‰ CPU or I/O ã®ã©ã¡ã‚‰ãŒåŽŸå› ã‹åˆ¤åˆ¥ vmstat ã§ procs ã® r, b ã®æ•°ã€swap ã® si, so ã®çŠ¶æ…‹ã€I/O ã® bi, bo ã®çŠ¶æ…‹ã‚’ç¢ºèª iostat ã‚’ä½¿ã£ã¦ disk ã® read/write ã®çŠ¶æ…‹ã‚’ã•ã‚‰ã«è©³ã—ãç¢ºèª sar ã‚’ä½¿ã£ã¦ os ã®çŠ¶æ…‹ã‚’ã•ã‚‰ã«è©³ã—ãç¢ºèª ãŠãŠã‚ˆãã®åŽŸå› ç‰¹å®šã‹ã‚‰è¨å®šã‚’
masa_matya 2011/07/27
*ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ãƒªãƒ³ã‚¯
é«˜è² è·ã‚µã‚¤ãƒˆã®ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã‚’è¦‹ã¤ã‘ã‚‹ã«ã¯ : DSASé–‹ç™ºè€…ã®éƒ¨å±‹
ã¯ã˜ã‚ã« ã‚¢ã‚¯ã‚»ã‚¹ãŒæ€¥å¢—ã™ã‚‹ã¨ã€å¿œç”æ™‚é–“ãŒè‘—ã—ãæ‚ªåŒ–ã™ã‚‹ã‚µã‚¤ãƒˆã¯ã‚ã‚Šã¾ã›ã‚“ã‹ï¼Ÿ æ™®æ®µã¯200ãƒŸãƒªç§’ä»¥å†…ã§å®‰å®šã—ã¦ã‚¢ã‚¯ã‚»ã‚¹ã‚’ã•ã°ã„ã¦ã„ã‚‹ã®ã«ã€ã‚¤ãƒ™ãƒ³ãƒˆã‚„ã‚‰ã‚ãƒ£ãƒ³ãƒšãƒ¼ãƒ³ã‚„ã‚‰ã‚’é–‹å§‹ã—ãŸçž¬é–“ã‹ã‚‰ã€æ™®æ®µã®ï¼’å€ã‚„ï¼“å€ã®ã‚¢ã‚¯ã‚»ã‚¹ãŒæ®ºåˆ°ã—ã€ãã®çµæžœã€ãƒ¬ã‚¹ãƒãƒ³ã‚¹ã‚¿ã‚¤ãƒ ãŒ3ç§’ã¨ã‹9ç§’ã¨ã‹ã‹ã‹ã‚‹ã‚ˆã†ã«ãªã£ã¦ã—ã¾ã†ã“ã¨ã£ã¦ã‚ã‚Šã¾ã™ã‚ˆãã€‚ ã‚ã‚‹ã‚µã‚¤ãƒˆã®å®ŸçŠ¶ ã¤ã„å…ˆæ—¥ã¾ã§ã€ãã‚“ãªã‚µã‚¤ãƒˆãŒç§ã®ç›®ã®å‰ã«ã‚‚ã‚ã‚Šã¾ã—ãŸã€‚è‡ªç¤¾ã§é‹å–¶ã—ã¦ã„ã‚‹æŸã‚½ãƒ¼ã‚·ãƒ£ãƒ«ç³»ã®ã‚µã‚¤ãƒˆãªã‚“ã§ã™ãŒã€ã‚¤ãƒ™ãƒ³ãƒˆé–‹å§‹æ™‚åˆ»ã¨åŒæ™‚ã«ã‚¢ã‚¯ã‚»ã‚¹æ•°ãŒæ€¥å¢—ã™ã‚‹ã®ã§ã™ã€‚ã¨ã¯ã„ãˆã€æ‰€è©®ã¯æ™®æ®µã®2å€ã¨ã‹3å€ç¨‹åº¦ã®æ•°ãªã®ã ã‹ã‚‰ã€å°‘ãªãã¨ã‚‚1ç§’ä»¥å†…ã«ãƒ¬ã‚¹ãƒãƒ³ã‚¹ã‚’è¿”ã›ã‚‹ãã‚‰ã„ã®æ€§èƒ½ã¯ç¶æŒã—ãŸã„ã‚‚ã®ã§ã™ã€‚ ã—ã‹ã—å®Ÿéš›ã¯å›°ã£ãŸã“ã¨ã«ã€å¿œç”ã«3ç§’ä»¥ä¸Šã‚‚ã‹ã‹ã£ã¦ã—ã¾ã†å‡¦ç†ãŒå¤§é‡ã«ç™ºç”Ÿã—ã¦ã—ã¾ã†çŠ¶æ³ã«é™¥ã£ã¦ã—ã¾ã£ã¦ã„ã¾ã—ãŸã€‚ã“ã‚Œã¯ãã£ã¨ã€ã©ã“ã‹ã«ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ãŒã‚ã‚‹ã«é•ã„ã‚ã‚Šã¾ã›ã‚“ã€‚ ä»®èª¬ã‚’ç«‹
masa_matya 2011/07/22
*ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ãƒªãƒ³ã‚¯
Av-jyo.com
The domain av-jyo.com maybe for sale. Click here for more information. Av-jyo.com Related Searches: International Dating Sites MatchMaking Services Divorced Dating Speed Dating Christian Dating Privacy Policy
masa_matya 2011/07/10
nginx

apache

*ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ãƒªãƒ³ã‚¯
http://www.mysqlpracticewiki.com/index.php/MySQL%E3%82%B5%E3%83%BC%E3%83%90%E3%81%8C%E6%B6%88%E8%B2%BB%E3%81%99%E3%82%8B%E3%83%A1%E3%83%A2%E3%83%AA
masa_matya 2011/03/11
ãƒ¡ãƒ¢ãƒªå‰²ã‚Šå½“ã¦å¯¾è±¡ã¨å€¤ã®è€ƒå¯Ÿ

mysql

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

clip
ãƒªãƒ³ã‚¯
MySQL :: MySQL 8.4 Reference Manual :: 17.14 InnoDB Startup Options and System Variables
Enabling Automatic InnoDB Configuration for a Dedicated MySQL Server
masa_matya 2011/03/11
å¤‰æ•°ä¸€è¦§

mysql

innodb

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

*document

clip
ãƒªãƒ³ã‚¯
MySQL innodb_flush_method = O_DIRECTã®æ¤œè¨Ž - SH2ã®æ—¥è¨˜
MySQL InnoDBã®ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã§innodb_flush_methodã¨ã„ã†ã‚‚ã®ãŒã‚ã‚Šã¾ã™ã€‚ã“ã‚Œã¯UNIX/Linuxã«ãŠã„ã¦ãƒ‡ãƒ¼ã‚¿ãƒ•ã‚¡ã‚¤ãƒ«ã€ãƒã‚°ãƒ•ã‚¡ã‚¤ãƒ«ã®èªã¿æ›¸ãæ–¹å¼ã‚’æŒ‡å®šã™ã‚‹ãŸã‚ã®ã‚‚ã®ã§ã€ãƒžãƒ‹ãƒ¥ã‚¢ãƒ«ã®13.6.3. InnoDB Startup Options and System Variablesã«ã‚ˆã‚‹ã¨ä»¥ä¸‹ã®3ç¨®é¡žã®è¨å®šãŒå¯èƒ½ã¨ã•ã‚Œã¦ã„ã¾ã™ã€‚ ç„¡æŒ‡å®š(fdatasync)ï¼šãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã®è¨å®šã§ã™ã€‚ç‰¹åˆ¥ãªãƒ•ãƒ©ã‚°ãªã—ã§ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ã‚ªãƒ¼ãƒ—ãƒ³ã—ã€æ›¸ãè¾¼ã¿æ™‚ã«fsync()ã‚’è¡Œã„ã¾ã™ã€‚ O_DSYNCï¼šãƒ‡ãƒ¼ã‚¿ãƒ•ã‚¡ã‚¤ãƒ«ã«ã¤ã„ã¦ã¯fdatasyncã¨åŒã˜ã§ã™ã€‚ãƒã‚°ãƒ•ã‚¡ã‚¤ãƒ«ã«ã¤ã„ã¦O_SYNCãƒ•ãƒ©ã‚°ã‚’ã¤ã‘ã¦ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ã‚ªãƒ¼ãƒ—ãƒ³ã—ã¾ã™ã€‚ O_DIRECTï¼šãƒ‡ãƒ¼ã‚¿ãƒ•ã‚¡ã‚¤ãƒ«ã«ã¤ã„ã¦O_DIRECTãƒ•ãƒ©ã‚°ã‚’ã¤ã‘ã¦ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ã‚ªãƒ¼ãƒ—ãƒ³ã—ã¾ã™ã€‚ãƒã‚°ãƒ•ã‚¡ã‚¤ãƒ«ã«ã¤ã„ã¦ã¯fdatasyncã¨åŒã˜ã§ã™ã€‚ ä»Šå›žã¯ã“ã®ãƒ‘
masa_matya 2011/03/11
innodb_flush_methodã«é–¢ã™ã‚‹è€ƒå¯Ÿã€‚O_DIRECTã«ã™ã‚‹ã®ã¯ã€MySQLã®ãƒ¡ãƒ¢ãƒªé‡ã‚’æ„å›³çš„ã«åˆ¶é™ã—ãŸã„ã¨ãã€‚sh2ã•ã‚“ã®ãŠã™ã™ã‚ã¯O_DIRECTåˆ©ç”¨&innodb_buffer_pool_sizeãŒç‰©ç†ãƒ¡ãƒ¢ãƒªã®åŠåˆ†ä½ã€‚ã‚‚ã¡ã‚ã‚“ç’°å¢ƒãƒ»çŠ¶æ³ã«ã‚ˆã£ã¦å¤‰æ›´

mysql

innodb

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

clip
ãƒªãƒ³ã‚¯
The Art of Workï¼šMySQL InnoDB Pluginã®ãƒ‡ãƒ¼ã‚¿åœ§ç¸®æ©Ÿèƒ½ æ€§èƒ½ç·¨ - SH2ã®æ—¥è¨˜
MySQL InnoDB Pluginã®ãƒ‡ãƒ¼ã‚¿åœ§ç¸®æ©Ÿèƒ½ã®ç¶šãã§ã™ã€‚å‰å›žã¯InnoDB Pluginã®ç‹¬è‡ªæ©Ÿèƒ½ã§ã‚ã‚‹ãƒ‡ãƒ¼ã‚¿åœ§ç¸®ã®ä»•çµ„ã¿ã‚’è§£èª¬ã—ã€Wikipediaæ—¥æœ¬èªžç‰ˆã®ãƒ‡ãƒ¼ã‚¿ãŒç´„åŠåˆ†ã«ã¾ã§åœ§ç¸®ã•ã‚Œã‚‹ã“ã¨ã‚’ç¢ºèªã—ã¾ã—ãŸã€‚ä»Šå›žã¯ãƒ‡ãƒ¼ã‚¿åœ§ç¸®ã«ã‚ˆã£ã¦æ€§èƒ½ãŒã©ã®ã‚ˆã†ã«å¤‰åŒ–ã™ã‚‹ã‹ã‚’ã€å®Ÿéš›ã«ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯è©¦é¨“ã‚’è¡Œã£ã¦è¦‹ã¦ã„ãã¾ã™ã€‚ è©¦é¨“ã®æ–¹é‡ ãƒ‡ãƒ¼ã‚¿åœ§ç¸®ã«ã‚ˆã‚‹æ€§èƒ½ã¸ã®å½±éŸ¿ã¯ã€ä»¥ä¸‹ã®äºŒç‚¹ãŒè€ƒãˆã‚‰ã‚Œã¾ã™ã€‚ ãƒ¡ãƒªãƒƒãƒˆï¼šãƒ‡ãƒ¼ã‚¿ã‚µã‚¤ã‚ºãŒå°ã•ããªã‚‹ãŸã‚ã€ãƒ‡ã‚£ã‚¹ã‚¯I/OãŒæ¸›ã‚‹ ãƒ‡ãƒ¡ãƒªãƒƒãƒˆï¼šåœ§ç¸®ãƒ»å±•é–‹ã®å‡¦ç†ãŒè¡Œã‚ã‚Œã‚‹ãŸã‚ã€CPUè² è·ãŒé«˜ããªã‚‹ ãã“ã§ã€ã“ã‚Œã‚‰ã®ç‰¹å¾´ãŒã‚ˆãåˆ†ã‹ã‚‹ã‚ˆã†ã«è©¦é¨“ãƒ‘ã‚¿ãƒ¼ãƒ³ã‚’å·¥å¤«ã—ã¾ã™ã€‚Wikipediaæ—¥æœ¬èªžç‰ˆã®ãƒ‡ãƒ¼ã‚¿ã¯InnoDBä¸Šã§ãŠã‚ˆã5GBã‚ã‚Šã¾ã™ãŒã€ã¾ãšç‹ã„ç¯„å›²ã«çµžã£ã¦èªã¿å–ã‚Šå‡¦ç†ã‚’è¡Œã†ã“ã¨ã§ãƒ‡ã‚£ã‚¹ã‚¯I/OãŒã‚ã¾ã‚Šç™ºç”Ÿã—ãªã„ã‚ˆã†ã«ã—ã¾ã™ã€‚ã“ã‚Œã§CPUè² è·ã®å‚¾å‘ã‚’ç¢ºèªã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚æ¬¡
masa_matya 2011/03/10
compressedã«ã‚ˆã‚‹æ€§èƒ½å¤‰åŒ–ã®æ¤œè¨¼ã€‚åœ§ç¸®ã—ãªãã¦ã‚‚ãƒ‡ãƒ¼ã‚¿ãŒä¹—ã‚‹å ´åˆã¯éžåœ§ç¸®ã«æ¯”ã¹90%ã€ä¹—ã‚Šåˆ‡ã‚‰ãªããªã£ã¦ãã‚‹ã¨350%ã€åœ§ç¸®ã§ã‚‚ä¹—ã‚‰ãªã„é‡ã ã¨110%ã®æ€§èƒ½ã¨ãªã‚‹ã€‚CPUã‚³ã‚¹ãƒˆã‚‚é«˜ããªã‚‹ã€‚å˜ã«åœ§ç¸®=>å±•é–‹ã‚’ã‚„ã£ã¦ã„ã‚‹ã‚ã‘ã§ã¯ç„¡

mysql

innodb

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

clip
ãƒªãƒ³ã‚¯
MySQL InnoDB Pluginã®ãƒ‡ãƒ¼ã‚¿åœ§ç¸®æ©Ÿèƒ½ - SH2ã®æ—¥è¨˜
InnoDB Pluginã®é¢ç™½ã„æ©Ÿèƒ½ã®ä¸€ã¤ã«ã€ãƒ‡ãƒ¼ã‚¿åœ§ç¸®æ©Ÿèƒ½ãŒã‚ã‚Šã¾ã™ã€‚ä»Šå›žã¯ãã®ä»•çµ„ã¿ã¨åŠ¹æžœã«ã¤ã„ã¦è¦‹ã¦ã„ããŸã„ã¨æ€ã„ã¾ã™ã€‚ã¾ãšã¯ã‚°ãƒ©ãƒ•ã‚’ã”è¦§ãã ã•ã„ã€‚ ã“ã‚Œã¯Wikipediaæ—¥æœ¬èªžç‰ˆã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã—ã€è¨˜äº‹æœ¬æ–‡ã®æ ¼ç´ã•ã‚Œã¦ã„ã‚‹textãƒ†ãƒ¼ãƒ–ãƒ«ã‚’MySQL 5.1ï¼‹InnoDB Plugin 1.0ã®ç’°å¢ƒã«ãƒãƒ¼ãƒ‰ã—ãŸã‚‚ã®ã§ã™ã€‚ å…ƒãƒ†ã‚ã‚¹ãƒˆï¼šä»Šå›žåˆ©ç”¨ã—ãŸãƒ‡ãƒ¼ã‚¿ã¯2009/06/21ç‰ˆã®ã‚‚ã®ã§ã™(jawiki-20090621-pages-articles.xml.bz2)ã€‚å…ƒãƒ†ã‚ã‚¹ãƒˆã¯ã“ã“ã‹ã‚‰Xml2sqlã‚’ç”¨ã„ã¦ã‚¿ãƒ–åŒºåˆ‡ã‚Šãƒ†ã‚ã‚¹ãƒˆã‚’å–ã‚Šå‡ºã—ãŸã‚‚ã®ã‚’ç”¨ã„ã¦ã„ã¾ã™ã€‚ã“ã®ãƒ•ã‚¡ã‚¤ãƒ«ã«ã¯1,167,411ä»¶ã®è¨˜äº‹ãŒæ ¼ç´ã•ã‚Œã¦ãŠã‚Šã€å®¹é‡ã¯3,436MBã¨ãªã£ã¦ã„ã¾ã™ã€‚ å…ƒãƒ†ã‚ã‚¹ãƒˆ gzipï¼šå…ƒãƒ†ã‚ã‚¹ãƒˆã‚’gzipã‚³ãƒžãƒ³ãƒ‰ã§åœ§ç¸®ã—ãŸã‚‚ã®ã§ã™ã€‚ MyISAMï¼šè¨˜äº‹ã‚’MyISAMã®ãƒ†ãƒ¼ãƒ–ãƒ«ã«
masa_matya 2011/03/10
row_formatã«ã¤ã„ã¦ã®è§£èª¬ã‚‚ã‚ã‚Šã€‚ãƒšãƒ¼ã‚¸ã‚µã‚¤ã‚ºã¯ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆ8KBã ãŒã€ã“ã‚Œã¯zlibãŒãƒ‡ãƒ¼ã‚¿ã‚’åŠåˆ†ä»¥ä¸‹ã®ã‚µã‚¤ã‚ºã«åœ§ç¸®ã—ã¦ã„ã‚‹ã“ã¨ã‚’æœŸå¾…ã—ã¦ã„ã‚‹ãŸã‚ã€‚åœ§ç¸®ãŒã†ã¾ãkey_block_sizeã«åŽã¾ã£ãŸã‹ã¯information_schemaã®InnoDB_CMPã§ç¢ºèªå¯

mysql

innodb

*ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ãƒªãƒ³ã‚¯
MySQLã‚’è¨ºæ–ã—ã¦ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ãƒã‚¤ãƒ³ãƒˆã‚’æ•™ãˆã¦ãã‚Œã‚‹ãƒ„ãƒ¼ãƒ«ã€ŒMySQLTunerã€ã®ç´¹ä»‹
MySQLã‚’è¨ºæ–ã—ã¦ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ãƒã‚¤ãƒ³ãƒˆã‚’æ•™ãˆã¦ãã‚Œã‚‹ãƒ„ãƒ¼ãƒ«ã€ŒMySQLTunerã€ ã“ã®ãƒ„ãƒ¼ãƒ«ã®CentOS5.3ã¸ã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã‚’å®Ÿæ–½ã—ã¦ã¿ã¾ã™ã€‚ ã€ŒMySQLTunerã€ã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã‹ã‚‰ã€ä½¿ç”¨æ–¹æ³•ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ ã“ã®ãƒ„ãƒ¼ãƒ«ã¯MySQLã‚’è¨ºæ–ã—ã€è¨å®šå€¤ã‚’ã©ã®ã‚ˆã†ã«æ›¸ãæ›ãˆãŸã‚‰ã„ã„ã‹æ•™ãˆã¦ãã‚Œã¾ã™ã€‚ (å…¨éƒ¨ã“ã‚Œã«é ¼ã‚‹ã¨ã„ã†ã‚ˆã‚Šã¯å‚è€ƒç¨‹åº¦ã®ã‚ˆã†ã§ã™ã®ã§ã€æ³¨æ„ãŒå¿…è¦ã§ã™) ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã¯ç°¡å˜ã€‚ ä»»æ„ã®ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªã«ã‚¹ã‚¯ãƒªãƒ—ãƒˆã‚’ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã—ã€å®Ÿè¡Œæ¨©é™ã‚’ä¸Žãˆã‚‹ã ã‘ã§ã™ã€‚ # ./mysqltuner.pl >> MySQLTuner 1.0.0 - Major Hayden <major @mhtx.net> >> Bug reports, feature requests, and downloads at http://mysqltuner.com/ >> Run with '--hel
masa_matya 2011/03/10
MySQLTunerã€‚ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®å‚è€ƒã«

mysql

*ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ãƒªãƒ³ã‚¯
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
masa_matya 2011/03/10
å¤šç”¨ãªãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã«ã¤ã„ã¦è§£èª¬

mysql

innodb

*ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ãƒªãƒ³ã‚¯
MySQLã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚° - ãƒ¢ãƒŽãƒŽãƒ•æ—¥è¨˜
ã¨ã‚ã‚‹å‹‰å¼·ä¼šã§Sunã®ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®äººã®ãƒ—ãƒ¬ã‚¼ãƒ³ã‚’ç›´æŽ¥èžãæ©Ÿä¼šãŒã‚ã£ãŸã®ã§ãƒ¡ãƒ¢ã£ãŸã“ã¨ã‚’å…¬é–‹ã—ã¾ã™ã€‚åŸºæœ¬çš„ãªäº‹ãŒå¤šã„ã‚“ã ã‚ã†ã‘ã©ã€éžå¸¸ã«å‚è€ƒã«ãªã‚Šã¾ã—ãŸã€‚ ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã¨ã¯ ã‚¹ãƒ«ãƒ¼ãƒ—ãƒƒãƒˆ ãƒ¬ã‚¹ãƒãƒ³ã‚¹ã‚¿ã‚¤ãƒ /ãƒ¬ã‚¤ãƒ†ãƒ³ã‚· ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ ä¸Šè¨˜ã®ã‚³ãƒ³ãƒ“ãƒãƒ¼ã‚·ãƒ§ãƒ³ ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã¨ã¯ Connection Thread Pool Query Cache Parser SQLã‚¯ã‚¨ãƒªã‚’ãƒ‘ãƒ¼ã‚¹ Optimizer Storage Engines ã‚¢ãƒ—ãƒªã«ã‚ˆã£ã¦æœ€é©ãªã‚¨ãƒ³ã‚¸ãƒ³ã‚’é¸æŠžã™ã¹ã ã‚µãƒ¼ãƒã®ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³&ã‚¹ãƒ¬ãƒƒãƒ‰ my.cnf max_connection (100) å¤šã™ãŽã‚‹ã¨ãƒ¡ãƒ¢ãƒªã‚’æ¶ˆè²»ã—ãã‚‹å¯èƒ½æ€§ã‚ã‚Š thread_cache_size (8) ã‚¹ãƒ¬ãƒƒãƒ‰ã‚’ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ã®åˆ‡æ–å¾Œã«ã‚‚ã‚ãƒ£ãƒƒã‚·ãƒ¥ã—ã¦ãŠãæ•° ä¸€èˆ¬çš„ã«ã¯ max_connections / 3 sort_buffer_size(2M)
masa_matya 2011/03/10
mysql

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

mysql

*ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ãƒªãƒ³ã‚¯
MySQL Casual Talks #1 ç™ºè¡¨è³‡æ–™ - Craftworks Tech Blog - Branch
MySQL Casual Talks #1 ã®ç™ºè¡¨è³‡æ–™ã‚’ UP ã—ã¾ã—ãŸã€‚ MySQL åˆã‚ã¦ã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°View more presentations from Craft works. è³‡æ–™ã®ä¸ã§ã‚‚è¨€åŠã—ã¾ã—ãŸã€hirose ã•ã‚“ãŒä½œæˆã•ã‚ŒãŸ mymemcheck ã¨ã„ã†ç´ æ™´ã‚‰ã—ã„ãƒ„ãƒ¼ãƒ«ã‚’ !includedir ã«å¯¾å¿œã—ã¦ Readonly.pm ä¾å˜ã‚’ç„¡ãã—ãŸãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚’ github ã® ã“ã¡ã‚‰ã«ã‚ã’ã¦ã‚ã‚Šã¾ã™ã€‚
masa_matya 2011/03/10
è¨å®šé …ç›®ã«ã¤ã„ã¦ã€‚ã‚¹ãƒ¯ãƒƒãƒ—ã—ãªã„ã‚ˆã†ã«è¨è¨ˆã—ã¤ã¤ãªã‚‹ã¹ãå¤šãã®ãƒ¡ãƒ¢ãƒªã‚’å‰²ã‚Šå½“ã¦ã€SHOW STATUSã§ç›£è¦–é‹ç”¨ã—ãªãŒã‚‰ã„ã˜ã‚‹ã€‚é …ç›®ã«ã¯ã€ã‚°ãƒãƒ¼ãƒãƒ«ãƒãƒƒãƒ•ã‚¡ã€ã‚¹ãƒ¬ãƒƒãƒ‰ãƒãƒƒãƒ•ã‚¡ã€ãƒ¡ãƒ¢ãƒªå¤–ãŒã‚ã‚‹ã€‚

mysqll

*ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ãƒªãƒ³ã‚¯
SysBench manual
SysBench is a modular, cross-platform and multi-threaded benchmark tool for evaluating OS parameters that are important for a system running a database under intensive load. The idea of this benchmark suite is to quickly get an impression about system performance without setting up complex database benchmarks or even without installing a database at all.
masa_matya 2011/03/09
mysql

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

sysbench

*document

clip
ãƒªãƒ³ã‚¯
DSASé–‹ç™ºè€…ã®éƒ¨å±‹:5åˆ†ã§ã§ãã‚‹ã€MySQLã®ãƒ¡ãƒ¢ãƒªé–¢ä¿‚ã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ï¼
MySQLã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã«ãŠã„ã¦éžå¸¸ã«é‡è¦ã¨ãªã‚‹ãƒ¡ãƒ¢ãƒª(ãƒãƒƒãƒ•ã‚¡)é–¢é€£ã®ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã«ã¤ã„ã¦ã€ ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®ãƒã‚¤ãƒ³ãƒˆ DSASã®ã¨ã‚ã‚‹DBã‚µãƒ¼ãƒ(å®Ÿãƒ¡ãƒ¢ãƒª4GB)ã®å®Ÿéš›ã®è¨å®šå€¤ ã‚’ã¾ã¨ã‚ã¦ã¿ã¾ã™ã€‚ ã¾ãŸã€å¿…è¦ãƒ¡ãƒ¢ãƒªã®ç·é‡ã®è¨ˆç®—ã‚„é™ç•Œå€¤ã‚’è¶Šãˆã¦ãªã„ã‹ãƒã‚§ãƒƒã‚¯ã—ã¦ãã‚Œã‚‹ã‚¹ã‚¯ãƒªãƒ—ãƒˆã‚‚ç´¹ä»‹ã—ã¾ã™ã€‚ æ˜¯éžã€å‚è€ƒã«ã—ã¦ã¿ã¦ãã ã•ã„ï¼ ã¾ãšæœ€åˆã«æ³¨æ„ç‚¹ã‚’ã€‚ ãƒãƒƒãƒ•ã‚¡ã«ã¯2ã¤ã®ã‚¿ã‚¤ãƒ—ãŒã‚ã‚Šã¾ã™ã€‚ ã‚°ãƒãƒ¼ãƒãƒ«ãƒãƒƒãƒ•ã‚¡ ã‚¹ãƒ¬ãƒƒãƒ‰ãƒãƒƒãƒ•ã‚¡ ã‚°ãƒãƒ¼ãƒãƒ«ãƒãƒƒãƒ•ã‚¡ã¯mysqldå…¨ä½“ã§ãã®ãƒãƒƒãƒ•ã‚¡ãŒ1ã¤ã ã‘ç¢ºä¿ã•ã‚Œã‚‹ã‚‚ã®ã§ã€ ã“ã‚Œã«å¯¾ã—ã€ ã‚¹ãƒ¬ãƒƒãƒ‰ãƒãƒƒãƒ•ã‚¡ã¯ã‚¹ãƒ¬ãƒƒãƒ‰(ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³)ã”ã¨ã«ç¢ºä¿ã•ã‚Œã‚‹ã‚‚ã®ã§ã™ã€‚ ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®éš›ã«ã¯ã‚°ãƒãƒ¼ãƒãƒ«/ã‚¹ãƒ¬ãƒƒãƒ‰ã®é•ã„ã‚’æ„è˜ã™ã‚‹ã‚ˆã†ã«ã—ã¾ã—ã‚‡ã†ã€‚ ãªãœãªã‚‰ã€ã‚¹ãƒ¬ãƒƒãƒ‰ãƒãƒƒãƒ•ã‚¡ã«å¤šãã®ãƒ¡ãƒ¢ãƒªã‚’å‰²ã‚Šå½“ã¦ã‚‹ã¨ã€ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãŒå¢—ãˆãŸã¨ãŸã‚“ã«ã‚¢ãƒƒã¨ã„ã†é–“ã«ãƒ¡ãƒ¢ãƒªä¸è¶³ã«ãªã£ã¦ã—ã¾ã†ã‹ã‚‰ã§ã™ã€‚ in
masa_matya 2011/02/25
mysql

innodb

*ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ãƒªãƒ³ã‚¯
BirdLab | phpç ”ç©¶æ‰€
åå‰ : ã‚³ãƒ¡ãƒ³ãƒˆ (2023-05-04 22:41:02) åå‰ : ã‚³ãƒ¡ãƒ³ãƒˆ (2023-05-04 22:41:01) åå‰ : ã‚³ãƒ¡ãƒ³ãƒˆ (2023-05-04 22:41:01) åå‰ : ã‚³ãƒ¡ãƒ³ãƒˆ (2023-05-04 22:41:00) åå‰ : ã‚³ãƒ¡ãƒ³ãƒˆ (2023-05-04 22:40:59) åå‰ : ã‚³ãƒ¡ãƒ³ãƒˆ (2023-05-04 22:40:58) åå‰ : ã‚³ãƒ¡ãƒ³ãƒˆ (2023-05-04 22:40:57) åå‰ : ã‚³ãƒ¡ãƒ³ãƒˆ (2023-05-04 22:40:56) åå‰ : ã‚³ãƒ¡ãƒ³ãƒˆ (2023-05-04 22:40:56) åå‰ : ã‚³ãƒ¡ãƒ³ãƒˆ (2023-05-04 22:40:55) åå‰ : ã‚³ãƒ¡ãƒ³ãƒˆ (2023-05-04 22:40:54) åå‰ : ã‚³ãƒ¡ãƒ³ãƒˆ (2023-05-04 22:40:53) åå‰ : ã‚³ãƒ¡ãƒ³ãƒˆ (2023-
masa_matya 2011/02/25
mysql

innodb

*ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ãƒªãƒ³ã‚¯
ã‚¦ã‚§ãƒ–ã‚µã‚¤ãƒˆã®é«˜é€ŸåŒ–å‡¦ç†ã‚’è‡ªå‹•çš„ã« - Apache å‘ã‘ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ« mod_pagespeed ã‚’è©¦ã—ã¦ã¿ã‚ˆã†ï¼
+1 ãƒœã‚¿ãƒ³ 2 AMP 11 API 3 App Indexing 8 CAPTCHA 1 Chrome 2 First Click Free 1 Google ã‚¢ã‚·ã‚¹ã‚¿ãƒ³ãƒˆ 1 Google ãƒ‹ãƒ¥ãƒ¼ã‚¹ 1 Google ãƒ—ãƒ¬ã‚¤ã‚¹ 2 Javascript 1 Lighthouse 4 Merchant Center 8 NoHacked 4 PageSpeed Insights 1 reCAPTCHA v3 1 Search Console 101 speed 1 ã‚¤ãƒ™ãƒ³ãƒˆ 25 ã‚¦ã‚§ãƒ–ãƒžã‚¹ã‚¿ãƒ¼ã‚¬ã‚¤ãƒ‰ãƒ©ã‚¤ãƒ³ 57 ã‚¦ã‚§ãƒ–ãƒžã‚¹ã‚¿ãƒ¼ã‚¯ã‚¤ã‚º 2 ã‚¦ã‚§ãƒ–ãƒžã‚¹ã‚¿ãƒ¼ãƒ„ãƒ¼ãƒ« 83 ã‚¦ã‚§ãƒ–ãƒžã‚¹ã‚¿ãƒ¼ãƒ•ã‚©ãƒ¼ãƒ©ãƒ 10 ã‚ªãƒ¼ãƒˆã‚³ãƒ³ãƒ—ãƒªãƒ¼ãƒˆ 1 ãŠçŸ¥ã‚‰ã› 69 ã‚¯ãƒãƒ¼ãƒ«ã¨ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ 75 ã‚µã‚¤ãƒˆã‚¯ãƒªãƒ‹ãƒƒã‚¯ 4 ã‚µã‚¤ãƒˆãƒžãƒƒãƒ— 15 ã—ã”ã¨æ¤œç´¢ 1 ã‚¹ãƒžãƒ¼ãƒˆãƒ•ã‚©ãƒ³ 11 ã‚»ãƒ¼ãƒ•ãƒ–ãƒ©ã‚¦ã‚¸ãƒ³ã‚° 5 ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ 1
masa_matya 2011/02/24
mod_pagespeedã€‚ãƒ»HTMLå†…ã‹ã‚‰ã‚³ãƒ¡ãƒ³ãƒˆå‰Šé™¤ç‰ã€€ãƒ»ç”»åƒã®å®¹é‡ã‚’è‡ªå‹•èª¿æ•´ã€‚ã€€ãƒ»ã‚ãƒ£ãƒƒã‚·ãƒ¥æœŸé™ã‚’ï¼‘å¹´é–“ã«(æ›´æ–°ã¯å¯èƒ½)

apache

*ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ãƒªãƒ³ã‚¯
å…¨ãƒ†ãƒ¼ãƒ–ãƒ«ã®çµ±è¨ˆæƒ…å ±ã‚’ã‚µã‚¤ã‚ºé †ã«ä¸€è¦§è¡¨ç¤ºã™ã‚‹
MySQLã«ãŠã„ã¦ã€ãƒ†ãƒ¼ãƒ–ãƒ«ã‚µã‚¤ã‚ºã‚„ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚µã‚¤ã‚ºã€ãƒ¬ã‚³ãƒ¼ãƒ‰æ•°ã€å¹³å‡ãƒ¬ã‚³ãƒ¼ãƒ‰é•·ãªã©ã®çµ±è¨ˆæƒ…å ±ã‚’çŸ¥ã‚‹ä¸Šã§show table statusã¯å®šç•ªã§ã™ã€‚ãŸã é›‘å¤šãªè¡¨ç¤ºé …ç›®ã‚‚å¤šã„ã®ã§ã€ãŸãã•ã‚“ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã®çµ±è¨ˆã‚’è¦‹ã‚‹å ´åˆã€å¿…è¦ãªæƒ…å ±ã ã‘ã‚’è¿”ã—ãŸã„ã“ã¨ã¯å¤šã„ã§ã™ã€‚ã¾ãŸå…¨ãƒ†ãƒ¼ãƒ–ãƒ«ã®ã†ã¡ã€ã©ã®ãƒ†ãƒ¼ãƒ–ãƒ«ãŒä¸€ç•ªå¤§ãã„ã®ã‹ã‚’çŸ¥ã‚ŠãŸã„ã¨ã‹ã€ã‚µã‚¤ã‚ºãŒå¤šã„é †ã«ä¸€è¦§è¡¨ç¤ºã—ãŸã„ã¨ã‹ã€ä¸€ç›®ã§åˆ†ã‹ã‚‹ã‚ˆã†ãªæƒ…å ±ãŒã»ã—ã„ã“ã¨ã‚‚å¤šã„ã§ã™ã€‚ ã“ã†ã„ã†ã¨ãã¯information_schema.tablesã‚’ä½¿ã†ã¨ä¾¿åˆ©ã§ã™ã€‚ä»¥ä¸‹ã®ä¾‹ã§ã¯ã€appãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®å…¨ãƒ†ãƒ¼ãƒ–ãƒ«ã«ã¤ã„ã¦ã€ã€Œãƒ†ãƒ¼ãƒ–ãƒ«ã‚µã‚¤ã‚º+ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚µã‚¤ã‚ºã€ã®å¤§ãã„é †ã«ã€ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã€ãƒ¬ã‚³ãƒ¼ãƒ‰æ•°ã€å¹³å‡ãƒ¬ã‚³ãƒ¼ãƒ‰é•·ã€ãƒ†ãƒ¼ãƒ–ãƒ«ã‚µã‚¤ã‚º(MB)ã€ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚µã‚¤ã‚º(MB)ãªã©ã‚’è¿”ã—ã¦ã„ã¾ã™ã€‚ use app; select table_name, engine, table_
masa_matya 2011/02/12
mysql

*ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ãƒªãƒ³ã‚¯
Webã‚µãƒ¼ãƒã®è¨å®š - Apacheï¼štech.ckme.co.jp
ç›®æ¬¡ >> Apache >> è¨å®š Webã‚µãƒ¼ãƒã®è¨å®š - Apacheã®è¨å®š ä¸»è¦ãªè¨å®šã¯OpenSUSE 11.2ãªã©ã§ã¯ /etc/apache2/httpd.conf OpenSUSE 10.0ãªã©ã§ã¯ /etc/httpd/conf/httpd.conf ã§è¡Œã†ã€‚httpd.confã®æ—¥æœ¬èªžè¨³ã¯ã“ã“ã€‚openSUSE ã®å ´åˆã¯ã€ãƒ•ã‚¡ã‚¤ãƒ«ãŒç´°ã‹ãåˆ†ã‹ã‚Œã¦ãŠã‚Šã€httpd.confã¯ãã‚Œã‚‰ã®ãƒ•ã‚¡ã‚¤ãƒ«ã‚’includeã§èªã¿è¾¼ã‚“ã§ã„ã‚‹ã®ã§æ³¨æ„ã€‚ä»¥ä¸‹ç‰¹ã«æ³¨é‡ˆãŒãªã„å ´åˆã¯ã€httpd.confã‚‚ã—ãã¯ãã“ã§includeã•ã‚Œã‚‹ãƒ•ã‚¡ã‚¤ãƒ«ã«è¨˜è¿°ã™ã‚‹ã€‚ ãªãŠã€ubuntuãªã©debianç³»ã®OSã§ã¯ã€ /etc/apache2/apache2.conf ãŒåŸºæœ¬è¨å®šã§ã€ãƒ¦ãƒ¼ã‚¶ã®è¿½åŠ ã®è¨å®šã¯ä¸‹è¨˜ã®ä¸ /etc/apache2/httpd.conf ãŠã‚ˆã³ã€ãã®ã‚µãƒ–ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªã§è¡Œã†ã“ã¨ã¨ãªã£ã¦ã„ã‚‹ã€‚
masa_matya 2011/01/14
è¨å®šã‹ã‚‰ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã¾ã§

apache

setup

*ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ãƒªãƒ³ã‚¯
1 2 3 4 æ¬¡ã®ãƒšãƒ¼ã‚¸