Definetely, Dynamic items in screens are not usable (yet)

[sebelk]

Well, I'm sorry to say it, but I found that screens with dynamic items are not usable. I started with a fresh installation (database too) of zabbix 1.5 and I did this simple test: I checked a graphic as dynamic of Zabbix Server the screens that is out of the box as dynamic item and again the nightmare, mysqld eats up the cpu...

Please if someone has a different experience I'd be glad to read about...

[sebelk]

Perhaps my slow-query-log is useful:

tail /var/log/mysqld/slow-query-log


use zabbix15;
SELECT DISTINCT g.groupid, g.name FROM groups g, hosts_groups hg, hosts h, items i, graphs_items gi WHERE g.groupid in (2,5,1,3,4) AND hg.groupid=g.groupid AND h.status=0 AND h.hostid=i.hostid AND hg.hostid=h.hostid ORDER BY g.name;
/usr/libexec/mysqld, Version: 5.0.27-log. started with:
Tcp port: 3306 Unix socket: /var/lib/mysql/mysql.sock
Time Id Command Argument
# Time: 080410 12:42:51
# User@Host: zabbix[zabbix] @ localhost []
# Query_time: 106 Lock_time: 0 Rows_sent: 1 Rows_examined: 62367282
use zabbix15;
SELECT DISTINCT g.groupid, g.name FROM groups g, hosts_groups hg, hosts h, items i, graphs_items gi WHERE g.groupid in (2,5,1,3,4) AND hg.groupid=g.groupid AND h.status=0 AND h.hostid=i.hostid AND hg.hostid=h.hostid ORDER BY g.name;

[Aly]

Check this Link

[sebelk]

Check this Link

Thanks Aly.