mysqltuner数据库优化工具

kider

作者：未知， 整理：mysqlpub.com

mysqltuner是一个mysql数据库优化工具，mysqltuner可以针对你现有mysql数据库使用情况进行分析并给出优化建议。

安装mysqltuner：

wget http://mysqltuner.pl/mysqltuner.pl;

chmod +x mysqltuner.pl

运行：perl mysqltuner.pl

一般建议mysql运行1天以上，在运行mysqltuner分析，这样相对准确些。

运行mysqltuner后，会给出相关参数建议，可以根据自己的情况进行微调修改my.cnf数据库配置文件。

建议定期运行mysqltuner优化工具。

工具自带的说明：

1. # mysqltuner.pl - Version 1.2.0
   
2. # High Performance MySQL Tuning Script
   
3. # Copyright (C) 2006-2011 Major Hayden - major@mhtx.net
   
4. #
   
5. # For the latest updates, please visit http://mysqltuner.com/
   
6. # Git repository available at http://github.com/rackerhacker/MySQLTuner-perl
   
7. #
   
8. # This program is free software: you can redistribute it and/or modify
   
9. # it under the terms of the GNU General Public License as published by
   
10. # the Free Software Foundation, either version 3 of the License, or
    
11. # (at your option) any later version.
    
12. #
    
13. # This program is distributed in the hope that it will be useful,
    
14. # but WITHOUT ANY WARRANTY; without even the implied warranty of
    
15. # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
    
16. # GNU General Public License for more details.
    
17. #
    
18. # You should have received a copy of the GNU General Public License
    
19. # along with this program.  If not, see <http://www.gnu.org/licenses/>.
    
20. #
    
21. # This project would not be possible without help from:
    
22. #   Matthew Montgomery     Paul Kehrer          Dave Burgess
    
23. #   Jonathan Hinds         Mike Jackson         Nils Breunese
    
24. #   Shawn Ashlee           Luuk Vosslamber      Ville Skytta
    
25. #   Trent Hornibrook       Jason Gill           Mark Imbriaco
    
26. #   Greg Eden              Aubin Galinotti      Giovanni Bechis
    
27. #   Bill Bradford          Ryan Novosielski     Michael Scheidell
    
28. #   Blair Christensen      Hans du Plooy        Victor Trac
    
29. #   Everett Barnes         Tom Krouper          Gary Barrueto
    
30. #   Simon Greenaway        Adam Stein           Isart Montane
    
31. #   Baptiste M.
    
32. #
    
33. # Inspired by Matthew Montgomery's tuning-primer.sh script:
    
34. # http://forge.mysql.com/projects/view.php?id=44

复制代码

kingtiy

支持楼主.好东西分享