mysqltuner

Analyzes MySQL performance and provides optimization recommendations

brewmacoslinux

Try with needOr install directly

About

Increase performance and stability of a MySQL installation

mysqltuner.plmysqltuner

Analyze MySQL server on localhost with credentials$ mysqltuner --host localhost --user root --password

Generate a report for remote MySQL server$ mysqltuner --host 192.168.1.100 --user admin --password secret123

Run analysis and save output to file for review$ mysqltuner --host localhost --user root --password > mysql_report.txt