O'Reilly logo

Zabbix Performance Tuning by Luciano Alves

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required