mysql

Important variables of a MySQL server

Whether you are using a MySQL server or a cluster, one thing is sure among users. To optimize your MySQL server as much as possible. Something that MySQL's developers know about and are giving us access to a series of comprehensive variables, that one can use to monitor in realtime the status and performance of a MySQL server.

Those variables are accessible via SHOW STATUS command. Below you can find a list of 10 important variables aiding us to draw conclusions about the status of our MySQL server.

1. Threads_connected

Optimizing MySQL database using mysqltuner.pl

MySQLTuner is a script written in perl which based to MySQL logs, it generates some pretty safe suggestions about which variables can be changed in MySQL config file for a little extra performance

First, we download the script and make it executable:

wget https://raw.github.com/major/MySQLTuner-perl/master/mysqltuner.pl
chmod +x mysqltuner.pl

Then we run it:

Subscribe to RSS - mysql