slow maps display

[dsipe]

Hello,

Since Zabbix 1.4.1, maps are very long to display.
I just migrate to 1.4.2, but the problem remain the same.
Has anyone else notice that ?

My Zabb conf :
Parameter Value
ZABBIX server is running Yes
Number of hosts (monitored/not monitored/templates/deleted) 213(135/43/35/0)
Number of items (monitored/disabled/not supported)[trapper] 3271(2956/136/179)[186]
Number of triggers (enabled/disabled)[true/unknown/false] 907(818/89)[1/13/804]
Number of events 19058
Number of alerts 2736

The mysql database size is about 12Go.
The server is a HP Proliant bi-Xeon 3ghz with 1Go ram.

The two following map take more then 20s to get displayed ! and that's the same for all the maps. The number of objects on it doesn't seem to have much impact on time spend to display. :(

Any ideas ????

[dsipe]

just forget to tell that i'm the ONLY user conected to the frontend

[dsipe]

Can someone give me a mysql configuration file for a Zabbix server with 2Go RAM please.

I think that my problems came from the fact that the mysql's my.cnf file is not good for the Innodb mysql zabbix database and my server memory.

thanx

[Alexei]

I cannot imagine what might be wrong on your system. The map generation is a super-fast operation.

[dsipe]

ok, but how can i investigate to find to problem ?

at the moment, 5 different users are connected to zabbix, and more to come.

I'd like to known if the problem is a database tuning one, or an apache one , ...

Any help welcome!

Thanx

nb: graph are very very speedy ( less than 0.5s to complete ). So i don't understand why maps are so slowly

[dsipe]

is it possible to put database query in debug mode to get them displayed on HTML's screens ?

[Palmertree]

Seperate your web frontend from your database and pollers. Sounds like you might have a load issue. This is just a guess. Need more informaiton to be able to determine root cause. Also, make sure you use inndob database type with innodb caching at 60% to 70% of ram if available. It's really hard to determine root cause unless more information is provided. I have huge network maps (800k png outputs) that load within 2 to 3 seconds. I don't think it's a Zabbix issue. :-)

[dsipe]

Thanx for this reply!

Could you share with me your mysql config file ?
I'm not @all a database admin, so maybe good parameters are not set !