Re: How to disable a graph
Hi Mark,
The table has only 71 rows and the query is checking every 1 minute (sorry for my mistake on my previous message, it should be 1 minute). Yes, we finally find out how to disable it through the items-mysql-monitor.xml on the agent directory. This query took 3-6 seconds longer.
Below is the sample log.
# Time: 120420 14:50:04
# User@Host: agent_user[agent_user] @ [127.0.0.1]
# Query_time: 3.004318 Lock_time: 0.000068 Rows_sent: 1 Rows_examined: 71
SET timestamp=1334904604;
SELECT IF(end_time >= (NOW() - INTERVAL 60 SECOND), TIMESTAMPDIFF(SECOND, start_time, end_time), 0) AS total_time, IF((end_time >= (NOW() - INTERVAL 60 SECOND)), lock_time, 0) $
# Time: 120420 14:50:10
# User@Host: agent_user[agent_user] @ [127.0.0.1]
# Query_time: 6.741716 Lock_time: 0.000167 Rows_sent: 1 Rows_examined: 356
SET timestamp=1334904610;
SELECT start_time AS start_time_raw, UNIX_TIMESTAMP(start_time) AS start_time_ts, end_time AS end_time_raw, UNIX_TIMESTAMP(end_time) AS end_time_ts, IFNULL(TIMESTAMPDIFF(SECOND$
# Time: 120420 14:51:03
# User@Host: agent_user[agent_user] @ [127.0.0.1]
# Query_time: 2.953057 Lock_time: 0.000067 Rows_sent: 1 Rows_examined: 71
SET timestamp=1334904663;
SELECT IF(end_time >= (NOW() - INTERVAL 60 SECOND), TIMESTAMPDIFF(SECOND, start_time, end_time), 0) AS total_time, IF((end_time >= (NOW() - INTERVAL 60 SECOND)), lock_time, 0) $
# Time: 120420 14:52:04
# User@Host: agent_user[agent_user] @ [127.0.0.1]
# Query_time: 2.989693 Lock_time: 0.000071 Rows_sent: 1 Rows_examined: 71
SET timestamp=1334904724;
SELECT IF(end_time >= (NOW() - INTERVAL 60 SECOND), TIMESTAMPDIFF(SECOND, start_time, end_time), 0) AS total_time, IF((end_time >= (NOW() - INTERVAL 60 SECOND)), lock_time, 0) $
# Time: 120420 14:53:04
# User@Host: agent_user[agent_user] @ [127.0.0.1]
# Query_time: 3.027503 Lock_time: 0.000066 Rows_sent: 1 Rows_examined: 71