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 Matthews
Consulting Member Technical Staff - MySQL Enterprise Tools

Options: ReplyQuote

Written By
Re: Monitor Agent creates massive slow queries
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.