Zabbix Slow Access because table problem

[Madara]

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; mobdro kodi

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.

[tim.mooney]

In your zabbix_serverd.log, when the housekeeper runs, what does it report for what is has deleted?

What is "HousekeepingFrequency" set to in your zabbix_server.conf? It's not 0, is it?