Zabbix Slow Access because table problem

[lesomora]

Hello Guys,

I need some help!

My database has partition history and treands for data...so we turn off housekeeper

But, we have 1 year activity of Zabbix production and now we face some problems with performance

with i running select count(eventid) from problem;

has 8Milion of registers, but how i can cleanup this ?

i turn on the housekeeper only to Events and alerts, but thoose data dont delete.

We catch slow queries to this table