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</li>
  • Innodb_log_file_size = 256MB</li>
    For Innodb_log_file_size I am using  1G as the value.

    A good read: