Reports seems taking forever (alpha7)

[Dutch]

The 'reports entry page' (report1.php) seems to take forever (5-10 mins), resulting in giving this result:

STATUS OF ZABBIX
Parameter Value
ZABBIX server is running Yes
Number of values stored 9449419
Number of trends stored 78212
Number of alarms 10722
Number of alerts 0
Number of triggers (enabled/disabled) 944(944/0)
Number of items (active/trapper/not active/not supported) 1433(1431/0/1/1)
Number of users 4
Number of hosts (monitored/not monitored/templates) 27(18/9/0)


Is this 'by design' or maybe some sql tuning needed?

The Mysql is on a dedicated dual PIII 650, with SCSI Raid and has never caused problems before with other dbs. We used all prefered zabbix settings; innodb.

This is collected information for about 1 week, so what can we expect later on ;)

Any idea?

Thanks !

[Alexei]

This is because "select count(*) from ..." is not optimised in InnoDB, so basically it performs sequential scan which is extremenly resource hungry.

I don't know how to solve the problem nicely. Perhaps I should exclude statistics of large tables from the report.

[Dutch]

Ah, ok clear. But overall Innodb is still performing better then the other types?


May I sugguest to at least disable this 'overview' when browsing to the reports menu?

Thanks,

- Dutch