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.
No related posts.
Related posts brought to you by Yet Another Related Posts Plugin.
