Home  >  Article  >  Database  >  MySQL的性能调优工具_MySQL

MySQL的性能调优工具_MySQL

WBOY
WBOYOriginal
2016-06-01 13:51:451031browse

转载:MySQL的性能调优工具:比mysqlreport更方便的tuning-primer.sh

 

年初的时候收藏过一篇关于 mysqlreport 的报表解读,和内置的 show status,和 show variables 相比 mysqlreport 输出一个可读性更好的报表;但 Sundry MySQL 提供的脚本相比 mysqlreport 更进一步:除了报表还进一步提供了修改建议。安装和使用非常简单:

wget http://www.day32.com/MySQL/tuning-primer.sh
chmod +x tuning-primer.sh
./tuning-primer.sh

 

运行前需要先创建配置文件 ~/.my.cnf

[client]
user = USERNAME
password = PASSWORD
socket = /tmp/mysql.sock

 

 

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn