Re: How to disable a graph
Posted by: Oliver Candelario
Date: April 22, 2012 08:29PM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
4571
April 19, 2012 08:52PM
2284
April 20, 2012 09:26AM
Re: How to disable a graph
2298
April 22, 2012 08:29PM
2296
April 23, 2012 12:36AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.