How To Run mysqltuner.pl on a 4.x System

Applies To

• Zenoss 4.x

Summary

Administrators may wish to run the mysqltuner.pl script against the ZenDS database to optimize performance.  

Procedure

1. As root:

   # wget mysqltuner.pl
   # mv mysqltuner.pl /home/zenoss/
   # cd /home/zenoss/
   # chown zenoss:zenoss mysqltuner.pl
   # su - zenoss
   $ vi mysqltuner.pl 

2. Change line that reads:

   my $command = `which mysqladmin`;

   to read:

    my $command = '/opt/zends/bin/.mysqladmin';

3. As root edit:

   # vi /opt/zends/etc/zends.conf

4. Comment out max_allowed_packet = 64M from the client section of the configuration file

   [client]
   socket = /opt/zends/data/zends.sock
   user = zenoss
   #max_allowed_packet = 64M

5. Restart zends:

   # service zends restart

   NOTE: only in the client section

   # su - zenoss

   run the tuner with:

   $./mysqltuner.pl -user zenoss -pass zenoss -port 13306

At this point mysqltuner.pl should work, you can run it and make small tweaks to your zends.conf file, restart the database and repeat. It is recommended to allow some time to pass between runs for best results.