Hi, with the 1.3.3-Version, there is very much load on my mysql Database.
i can see some "create" and "delete tmp tables" .. not sure if they are responsible for that impact. I have only 1 item at 30 second polltime (icmpping) all the others at 60 up to 300 seconds polltime...
The impact seems to hit the CPU.
model name : Dual Core AMD Opteron(tm) Processor 280
stepping : 2
cpu MHz : 2400.000
(its a dual dualcore machine, with 4 Cores)
top:
25119 mysql 15 0 469m 78m 5760 S 198 1.1 1093:35 mysqld
uptime:
20:29:30 up 17 days, 2:09, 6 users, load average: 6.92, 6.80, 6.84
iowait:
0-2 (very little)
Updated: Mon, 05 Mar 2007 19:23:26 +0000
Refreshed every: 30 sec (refresh now)
Users (online): 4(0)
Logged in as medic
ZABBIX server is running
Hosts (m/n/t/d): 32(17/2/13/0)
Items (m/d/n)[t]: 217(178/20/19)[0]
Triggers (e/d)[t/u/f]: 194(193/1)[3/15/175]
can someone please verify ?
Can this be the reason?:
15605:20070305:204355 Expression [{13373}=1] cannot be evaluated [Unable to get value for functionid [13373]]
mysql> select * from triggers where expression like "%13373%";
+-----------+------------+--------------------+-----+--------+-------+----------+------------+-----------+----------+----------------------------------------------+------------+
| triggerid | expression | description | url | status | value | priority | lastchange | dep_level | comments | error | templateid |
+-----------+------------+--------------------+-----+--------+-------+----------+------------+-----------+----------+----------------------------------------------+------------+
| 12585 | {13373}=1 | Last Agent Version | | 0 | 2 | 1 | 0 | 0 | | Trigger just added. No status update so far. | 12508 |
+-----------+------------+--------------------+-----+--------+-------+----------+------------+-----------+----------+----------------------------------------------+------------+
mysql> select * from functions where functionid = 13373;
+------------+--------+-----------+-----------+----------+-----------+
| functionid | itemid | triggerid | lastvalue | function | parameter |
+------------+--------+-----------+-----------+----------+-----------+
| 13373 | 17815 | 12585 | NULL | str | 1.3.3 |
+------------+--------+-----------+-----------+----------+-----------+
Trigger: Host_At:agent.version.str(1.3.3)=1
Note: Disabling the item drops CPU Load for about 200% ...
i can see some "create" and "delete tmp tables" .. not sure if they are responsible for that impact. I have only 1 item at 30 second polltime (icmpping) all the others at 60 up to 300 seconds polltime...
The impact seems to hit the CPU.
model name : Dual Core AMD Opteron(tm) Processor 280
stepping : 2
cpu MHz : 2400.000
(its a dual dualcore machine, with 4 Cores)
top:
25119 mysql 15 0 469m 78m 5760 S 198 1.1 1093:35 mysqld
uptime:
20:29:30 up 17 days, 2:09, 6 users, load average: 6.92, 6.80, 6.84
iowait:
0-2 (very little)
Updated: Mon, 05 Mar 2007 19:23:26 +0000
Refreshed every: 30 sec (refresh now)
Users (online): 4(0)
Logged in as medic
ZABBIX server is running
Hosts (m/n/t/d): 32(17/2/13/0)
Items (m/d/n)[t]: 217(178/20/19)[0]
Triggers (e/d)[t/u/f]: 194(193/1)[3/15/175]
can someone please verify ?
Can this be the reason?:
15605:20070305:204355 Expression [{13373}=1] cannot be evaluated [Unable to get value for functionid [13373]]
mysql> select * from triggers where expression like "%13373%";
+-----------+------------+--------------------+-----+--------+-------+----------+------------+-----------+----------+----------------------------------------------+------------+
| triggerid | expression | description | url | status | value | priority | lastchange | dep_level | comments | error | templateid |
+-----------+------------+--------------------+-----+--------+-------+----------+------------+-----------+----------+----------------------------------------------+------------+
| 12585 | {13373}=1 | Last Agent Version | | 0 | 2 | 1 | 0 | 0 | | Trigger just added. No status update so far. | 12508 |
+-----------+------------+--------------------+-----+--------+-------+----------+------------+-----------+----------+----------------------------------------------+------------+
mysql> select * from functions where functionid = 13373;
+------------+--------+-----------+-----------+----------+-----------+
| functionid | itemid | triggerid | lastvalue | function | parameter |
+------------+--------+-----------+-----------+----------+-----------+
| 13373 | 17815 | 12585 | NULL | str | 1.3.3 |
+------------+--------+-----------+-----------+----------+-----------+
Trigger: Host_At:agent.version.str(1.3.3)=1
Note: Disabling the item drops CPU Load for about 200% ...
Comment