I upgraded from 2.4.* to 3.2 and ever since the loading of "monitoring >latest data" is very slow. All other components are snappy.
As soon as I open this view the database is going over 100% load in top.
When using pre3.2.3 (3.2.2 and 3.2.1) I couldn't load the page at all. It reloaded every 30 seconds (before the view was showed) and it was crashing the server: in the dashboard all zabbix agents went 'down' probably because specific treads of the zabbix server were killed off because of resource depletion.
I noticed I am not the only one having this issue: https://www.zabbix.com/forum/showthread.php?t=56070

I have a 38GB Mysql database with partition maintenance enabled with 8 AMD Opteron 4376 HE.

Let me know what additional information I can provide that help shed light on the cause.