Data update time delay

[hipikll]

Hi,
i'm facing the problem with late data update.
Running zabbix 1.8.1 with MySQL 5.0. (default installation) on debian.

I have noticed, that in the screen of Latest Values, the items, are updated with too high time delay.
For example, the simplest ICMP ping to host, which has to run each 30 seconds sometimes takes 20 minits to update the data on Latest Values screen.

It seems, that the update of data are pending somewhere (DB?).
As when I created a new item and the period to run I set to 5 minutes, it sometimes shows the data after 20 minutes. And when I disable the item for example in 10:00, the items values are updated (in Latest Values screen) also in 10:20 - so it is pending somewhere.

I run the select (*) from history and it takes about 5 minutes to return value (during the zabbix server was down).

Please, can you advice me what I need to check to find out what the problem is?

thank you

[bashman]

Running a select (*) from history is normal to last 5 minutes because it's a big table.

Please give more information, your zabbix_server.conf, do you use proxys?

[hipikll]

Thank you for reply,
I solved the problem (it seems to work well).

I do not use the zabbix proxies. So I suggested, it is a db performance problem.

I changed the default configuration of Apache - decreased the 'number of clients' and also change the default MySQL configuration - increased the table_cash, query_cash_limit, query_cash_size and innodb_buffer_pool_size.

To obtain the DB performance statistics and hints, I used mysqltuner

If you have some more suggestions, ideas, hints - please provide.