MySQL Tuning Tips with Scout

August 19 Bullet_white By Andre Bullet_white Posted in Plugins Bullet_white Comments Comments

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

Weekly Reports

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.

Get Started!

Sound interesting? Install the MySQL Stats w/MySQLTuner Plugin and start getting MySQLTuner reports automatically.

Get notified of new posts.

Once a month, we'll deliver a finely-curated selection of optimization tips to your inbox.

Comments

comments powered by Disqus