Re: Monitor Agent creates massive slow queries
Posted by: Mark Matthews
Date: April 07, 2014 06:11PM

Hi Christian,

Those queries are against PERFORMANCE_SCHEMA to gather the information for query analysis. They're not actually slow, but I'm guessing they trigger in the slow query log for you because they don't use indexes? Note, PERFORMANCE_SCHEMA tables are completely in-memory, aren't indexed and the queries themselves are sub-millisecond according to your slow query log entry....


-Mark

Mark Matthews
Consulting Member Technical Staff - MySQL Enterprise Tools
Oracle
http://www.mysql.com/products/enterprise/monitor.html

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Monitor Agent creates massive slow queries
2782
April 07, 2014 06:11PM


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.