Zabbix mysql tunning

Over the past six months, I have search search to find how to make my Zabbix installation work well. As it was, nobody wanted to use it because it was too slow. I was about to move to postgres which was something I did not want to do.

Of all the changes made, these two seemed to work the best:

  • Innodb_buffer_pool_size = 512MB
  • Innodb_log_file_size = 256MB

    For Innodb_log_file_size I am using  1G as the value.

    A good read:

    http://www.zabbix.com/img/zabconf2013/presentations/Which_Database_is_Better_for_Zabbix.pdf