這是Jay Pipes 在Google 演講時有關MySQL Tuning 的Tips Direct URL: http://video.google.com/videoplay?docid=2524524540025172110 [02:20] Don’t benchmark without a goal. Have a goal like “improve performance by 20%”. Otherwise you’ll waste a lot of time tuning milliseconds out of your application. [02:50] Change just one thing at a time and re-run the benchmarks. [03:40] Disable the query cache by setting [...]
一如往常..在看訂閱的rss 的時後.. 其中這篇 有介紹幾個mysql 的工具.. 其中mytop 已經快樂使用中… 另一個就是 MySQL Active Report 看起來挺不錯的.. 一樣在ports 裡面也有.. #cd /usr/ports/databases/mysqlard/ #make install clean 裝好後的提示似乎不是很完整 1) Add the ‘mysqlar’ user with USAGE privileges to your mysql server: $ mysql -u root -p mysql mysql> GRANT USAGE ON *.* TO mysqlar@localhost; mysql> FLUSH PRIVILEGES; 2) Add the mysqlard crontab to root’s [...]