概述
MySQLTuner is a script written in Perl that allows you to review a MySQL installation quickly and make adjustments to increase performance and stability. The current configuration variables and status data is retrieved and presented in a brief format along with some basic performance suggestions.
MySQLTuner supports ~300 indicators for MySQL/MariaDB/Percona Server in this last version.
今天主要分析一个实用脚本,一键生成MySQL数据库优化建议。
1、下载脚本
wget http://mysqltuner.pl/ -O mysqltuner.plwget https://raw.githubusercontent.com/major/MySQLTuner-perl/master/basic_passwords.txt -O basic_passwords.txtwget https://raw.githubusercontent.com/major/MySQLTuner-perl/master/vulnerabilities.csv -O vulnerabilities.csv
![d4efa845d4e1af7eb96c9c43b42506a7.png](https://i-blog.csdnimg.cn/blog_migrate/416f6fd089d7cc526f1535277d6e424f.jpeg)
2、用法
Usage: Minimal usage remotely
perl mysqltuner.pl --host targetDNS_IP --user admin_user --pass admin_password
Usage: Enable maximum output information around MySQL/MariaDb without debugging
perl mysqltuner.pl --verboseperl mysqltuner.pl --buffers --dbstat --idxstat --sysstat --pfstat --tbstat
Usage: Enable CVE vulnerabilities check for your MariaDB or MySQL version
perl mysqltuner.pl --cvefile=vulnerabilities.csv
Usage: Write your result in a file with information displayed
perl mysqltuner.pl --outputfile /tmp/result_mysqltuner.txt
Usage: Write your result in a file without outputting information
perl mysqltuner.pl --silent --outputfile /tmp/result_mysqltuner.txt
Usage: Using template model to customize your reporting file based on Text::Template syntax.
perl mysqltuner.pl --silent --reportfile /tmp/result_mysqltuner.txt --template=/tmp/mymodel.tmpl
Usage: Enable debugging information
perl mysqltuner.pl --debug
Usage: Update MySQLTuner and data files (password and cve) if needed
perl mysqltuner.pl --checkversion --updateversion
3、实例
简单测试如下:
![4488af848904d1e2564fad50793c6662.png](https://i-blog.csdnimg.cn/blog_migrate/f3087b5c4cc09caad5cfcf7cce75ca8e.jpeg)
![8a390119c10f0e948143af92741da81e.png](https://i-blog.csdnimg.cn/blog_migrate/9f63a36e4a48be9c00c4750680688096.jpeg)
![613f2158b9a54e019d99d7f588cc01ce.png](https://i-blog.csdnimg.cn/blog_migrate/3740b6a46c9ed2ad2a602463ab87f349.jpeg)
![6da2efdf7916728f9ee30f8e3e74eac2.png](https://i-blog.csdnimg.cn/blog_migrate/98728cc29fc9b59e2f0d840fd2d72317.jpeg)
perl mysqltuner.pl --host localhost --user root --pass 密码 --buffers --dbstat --idxstat --sysstat --pfstat --tbstat
![2400151ccd737891f1bb1c96e8b4fd82.png](https://i-blog.csdnimg.cn/blog_migrate/cf12fb6296dfa11e261c9c8c33ad82a7.jpeg)
剩下的就靠大家自己挖掘了...
觉得有用的朋友多帮忙转发哦!后面会分享更多devops和DBA方面的内容,感兴趣的朋友可以关注下~
![c94f5cf28cfba1753cfc929ca06c0c5b.gif](https://i-blog.csdnimg.cn/blog_migrate/21ed1eda9f4874c32c7a1cb28abd269c.gif)