工具的下载及部署
解决环境依赖,因为工具是perl脚本开发的,需要perl脚本环境
# yun install -y perl*
下载脚本
在http://mysqltuner.com/下载major-MySQLTuner-perl-1.6.0-142-g42593c6.zip将下载的mysqltuner.pl文件上传到需要测试的mysql服务器中
# chmod +x mysqltuner.pl
执行脚本
# ./mysqltuner.pl根据提示输入管理员账号密码,得出建议:
报错
# ./mysqltuner.pl
>> MySQLTuner 1.6.9 - Major Hayden <major@mhtx.net>
>> Bug reports, feature requests, and downloads at http://mysqltuner.com/
>> Run with '--help' for additional options and output filtering
which: no mysqladmin in (/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin)
[!!] Couldn't find mysqladmin in your $PATH. Is MySQL installed?
添加环境变量
# vi /etc/profile.d/mysql.sh
加入
export PATH=/opt/lampp/bin:$PATH
>> MySQLTuner 1.6.9 - Major Hayden <major@mhtx.net>
>> Bug reports, feature requests, and downloads at http://mysqltuner.com/
>> Run with '--help' for additional options and output filtering
Please enter your MySQL adm