MySQL Tuning Tips with Scout
If you’ve used Major Hayden’s MySQLTuner before, you know it’s a great source of MySQL optimization tips.
Now you can get MySQLTuner reports automatically delivered through Scout. All you need to do is install the MySQL Stats w/MySQLTuner plugin, or update the plugin if you already have it installed. You will be informed if:
- the amount of memory you have allocated to MySQL needs adjusting
- tables are fragmented and need to be optimized
- query cache sizes, max heap sizes, or buffer pool sizes need adjusting
- queries are requiring an excessive number of temp tables
You’ll get your first report right away after installing the plugin. After that, you’ll automatically get a weekly follow-up report, so your database stays nice and optimized. You can change the frequency of the tuner reports to suit your needs.
Here’s an example report of a MySQLTuner report.
In case you’re wondering—you don’t need to install the MySQLTuner script on your server. All you need to do is select the Scout plugin from the plugin directory.
Real-time Query Activity
In addition to the MySQLTuner reports, you’ll get real-time statistics on MySQL query activity.
Like all Scout metrics, these can be charted and compared, you can get alerts on thresholds and trends, etc!
Where Credit’s Due
A huge thank-you to Major Hayden AKA Racker Hacker for the MySQLTuner Script. Also thanks to Eric Lindvall for creating the original MySQL Statistics plugin.
Sound interesting? Install the MySQL Stats w/MySQLTuner Plugin and start getting MySQLTuner reports automatically.