Zabbix History table tuning

[ataylo13]

I have been asked to provide utilization reports for our ~2000 servers. This data is then pumped into another DB to do whatever they want to do with it. When these reports the whole system slows waaaaay down.

My question is has anyone tried to make queries on the History table faster, by using indexes, table partitions, mirrored database, etc.?

Thoughts and/or opinions would be greatly appreciated here.

[xs-]

I am facing a similar problem and i was testing with a mirror read-only database.
I am reluctant to play around with indexes because i want to keep the database 'stock' where possible.