Hi everyone,
I have a Zabbix server with MySQL on InnoDB setup for work, I monitor 300 hosts / 44k items / 340 nvps / ~100GB database and today I highly struggle with almost constant 100% disk utilization on the server. I tweaked MySQL following perconna's guide for Zabbix and my server is 4c / 10GB RAM (8 for InnoDB).
Do you have any suggestions on how to improve the situation ? Would partitionning the history tables solve the problem ? Migrate to PostgreSQL ?
Thank you !