Specifications

Performance Tuning

4.4. Tuning MySQL

Zenoss Core performance is directly impacted by the performance of the MySQL database that supports the event

system. MySQL configuration parameters are located in the/etc/my.cnf file.

Zenoss recommends that you run the MySQLTuner Perl script periodically to analyze your MySQL performance.

Based on the statistics it gathers, the script provides optimization recommendations.

To download the MySQLTuner script, enter this command:

wget http://mysqltuner.com/mysqltuner.pl

4.5. Increasing Maximum File Descriptors

A Zenoss Core host can require in excess of 10000 open files. For optimal performance, Zenoss recommends that you

increase the minimum number of open files for the zenoss user to 4096, and the maximum number of open files to a

value greater than the anticipated number of open files needed by Zenoss Core.

For example, to configure a host for a minimum of 4096 and a maximum of 10240 open files, follow these steps:

1. Log in to the host as root.

2. Add the minimum open files value to /etc/security/limits.conf:

/bin/echo "zenoss soft nofile 4096" >> /etc/security/limits.conf

3. Add the maximum open files value:

/bin/echo "zenoss hard nofile 10240" >> /etc/security/limits.conf

4. Add the following lines to the zenoss user's $HOME/.bash_profile file:

if [ "${USER}" = "zenoss" ]; then

ulimit -n 10240

5. Source the $HOME/.bash_profile file, or log in as user zenoss to use the new value.

Note

In the preceding example, the value specified with the ulimit command may be decreased (but not increased)

without editing the /etc/security/limits.conf file.