I don’t know why I didn’t know about this before (or why I forgot about it, more likely), but I came across MySQLTuner recently and was most pleasantly surprised. It’s a Perl script that only requires your MySQL user and password to provide detailed and useful checks of a running MySQL instance. First though, check out the awesome URL you download it at:
1 | wget mysqltuner.pl |
Yeah, that’s the actual URL that works. Pretty sweet.
Anyway, next you make it executable, run it, enter creds:
Then the goodies appear:
Oh, that query_cache_limit is tiny! At this point, no changes have been made to your setup. But at a glance you get helpful stats, validate that changes you’ve decided to make are in place, and get alerted to potential improvements.
If I knew Perl now and refreshed my MySQL tuning knowledge, I’d love to help as a maintainer of this lovely script. Maybe sometime soon…
Possibly Related (no promises):
Related posts brought to you by Yet Another Related Posts Plugin.
