August 19, 2010
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:
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.
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!
Sound interesting? Install the MySQL Stats w/MySQLTuner Plugin and start getting MySQLTuner reports automatically.