Re: Monitor Agent creates massive slow queries
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
Subject
Views
Written By
Posted
5177
April 07, 2014 12:08AM
Re: Monitor Agent creates massive slow queries
2847
April 07, 2014 06:11PM
2453
April 08, 2014 12:17AM
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.