Linux performance tuning & stabilization tips (mysqlconf2010)
This document provides tips for optimizing Linux performance and stability when running MySQL. It discusses managing memory and swap space, including keeping hot application data cached in RAM. Direct I/O is recommended over buffered I/O to fully utilize memory. The document warns against allocating too much memory or disabling swap completely, as this could trigger the out-of-memory killer to cra
Linux ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚° - Ext3 ã®ãƒ‘フォーマンスを最大化ã•ã›ã‚‹
ã˜ã¤ã¯è‡ªå®…サーãƒã®ãƒãƒ¼ãƒ‰ã‚¢ãƒ™ãƒ¬ãƒ¼ã‚¸ãŒä¸ŠãŒã‚Šç¶šã‘ã¦ã„ã¾ã™ã€‚分æžã®çµæžœã€ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã¯ I/O 処ç†ã§ã—ãŸã€‚CPU 㯠Athlon64 X2 4400+ ã§ã™ãŒã€ã¾ã ã¾ã 当分ã“ã® CPU ã§é–“ã«åˆã„ãã†ã§ã™ã€‚HDD ã¯å½“時㯠7200 回転ã§æœ€é€Ÿã ã£ãŸ HITACHI Deskstar T7K250 SATA2 250GB ã‚’ RAID1 構æˆã«ã—ãŸã®ã§ã™ãŒã€ä»Šæ€ãˆã°é€Ÿåº¦å„ªå…ˆã§ RAID0 ã«ã—ã¦ãŠã‘ã°è‰¯ã‹ã£ãŸã¨å°‘ã—ã ã‘後悔。 I/O ãŒãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã«æˆã£ã¦ã„ã‚‹ç†ç”±ã§ã™ãŒã€Drk7jp ãŒå…¬é–‹ã—ã¦ã„るサービスã®å…¨ã¦ãŒã‚ャッシュファイルを利用ã—ãŸé«˜é€ŸåŒ–手法をå–ã£ã¦ã„ã‚‹ã®ã§ã™ãŒã€å˜ç´”ã«ãれらファイル㮠write 処ç†ãŒè¿½ã„ã¤ã„ã¦ã„ã¾ã›ã‚“。常ã«ä½•ã‚‰ã‹ã®ãƒ—ãƒã‚»ã‚¹ã§ I/O å¾…ã¡çŠ¶æ…‹ãŒç™ºç”Ÿã—ã¦ã„るよã†ãªçŠ¶æ³ã§ã™ã€‚抜本的ãªè§£æ±ºæ–¹æ³•ã¨ã—ã¦ã¯ disk を高速ãªã‚‚ã®ã«äº¤æ›ã™ã‚‹ä»¥å¤–ã‚ã‚Šã¾ã›ã‚“。 ã¨ã„ã†ã‚ã‘ã§
1
リリースã€éšœå®³æƒ…å ±ãªã©ã®ã‚µãƒ¼ãƒ“スã®ãŠçŸ¥ã‚‰ã›
最新ã®äººæ°—エントリーã®é…ä¿¡
処ç†ã‚’実行ä¸ã§ã™
j次ã®ãƒ–ックマーク
kå‰ã®ãƒ–ックマーク
lã‚ã¨ã§èªã‚€
eコメント一覧を開ã
oページを開ã
{{#tags}}- {{label}}
{{/tags}}