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: