Follow

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.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

Powered by Zendesk