MySQLTuner - An excellent free MySQL tool

Some thoughts on MySQLTuner and how to go about setting it up

MySQLTuner is a fairly small perl script that you can run on the linux box that contains your MySQL setup.

It quickly checks your configuration and produces an actionable report of recommendations.

You shouldn’t just blindly follow exactly what it recommends, but it did point out some glaring omissions in one of my setups and it will certainly give you some food for thought.

Running the script is very easy, to get everything setup you run through the following steps;

  1. Grab the script wget mysqltuner.pl -O mysqltuner.pl
  2. Set permissions on it to allow you to execute it chmod +x mysqltuner.pl
  3. Run it ./mysqltuner.pl

The wget works because the owner owns the domain mysqltuner.pl, it was a very clever idea since perl scripts are commonly given the extension .pl

Given how quick it is to install and run I am not sure why you wouldn’t give it a go.


Recent posts View all

Web Dev

Creating Docker images with M1 Macs

I ran into an issue with my Dockerfile when using it on a Linux machine, setting a platform fixed the issue

Web Dev

What does --no-owner mean in Postgres?

You have read a guide to doing Postgres exports or imports and seen --no-owner, this is what it means