Chapter 4. Tuning the MySQL Database

So far, we have talked about the settings of the Zabbix server and its internal components. Also, you learned how Zabbix's caches and buffers minimize the database hardware requirements. But we must be attentive to the database's performance settings. I often say that the correct database configuration is one of the keys to success in a Zabbix implementation. Administrators often simply define the Zabbix database and start using Zabbix, without making the adjustments necessary for good performance. In this chapter, we will talk about these topics:

• Comparisons between databases
• Why choose MySQL?
• The main configuration parameters
• Tuning for reading or writing