MariaDB社区

标题: mysqltuner数据库优化工具 [打印本页]
作者: kider    时间: 2013-5-9 17:09
标题: mysqltuner数据库优化工具
作者：未知， 整理：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    时间: 2013-5-16 17:26
支持楼主.好东西分享



欢迎光临 MariaDB社区 (http://123.56.88.72/) Powered by Discuz! X3.2