How to disable a graph
Posted by: Oliver Candelario
Date: April 19, 2012 08:52PM

Hi,

Anybody knows how to disable a graph in MySQL Enterprise Monitor? I have this query that is always logged in the slow-query log and is taking 2-3 seconds every .01 second. I just want to get rid of them in the log. I just cant adjust the slow-query-time because I consider more than 2 seconds as slow already.

This is the query and I suspect that it is the (2) graphs, the Backup Locked Time and the Backup Run Time querying this every .01 second. Just like to try disabling these graphs. Please help. Thank you. - Oliver

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) AS lock_time
FROM mysql.backup_history
ORDER BY end_time
DESC LIMIT 1;

Options: ReplyQuote


Subject
Views
Written By
Posted
How to disable a graph
4581
April 19, 2012 08:52PM
2287
April 20, 2012 09:26AM
2304
April 22, 2012 08:29PM
2298
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.