Book Image

Zabbix Performance Tuning

By : Luciano Alves, Luciano de C Alves
Book Image

Zabbix Performance Tuning

By: Luciano Alves, Luciano de C Alves

Overview of this book

Table of Contents (20 chapters)
Zabbix Performance Tuning
Credits
Foreword
About the Author
Acknowledgements
About the Reviewers
www.PacktPub.com
Preface
Index

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