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
Comparisons between databases
To understand why MySQL is ...
Get Zabbix Performance Tuning now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
