Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Does Query Analyzer work with all versions of MySQL and the MySQL Client Libraries?

April 26, 2017analyzer client Libraries MySQL query versions

0

Posted

Does Query Analyzer work with all versions of MySQL and the MySQL Client Libraries?

1 Answer

0

Posted

The MySQL Proxy component, and Query Analyzer, require that clients connecting through MySQL Enterprise Monitor Agent are using MySQL 5.0 or later. Clients that use the library provided with MySQL 4.1 or earlier will not work with MySQL Enterprise Monitor Agent. 15.12.8: I have enabled EXPLAIN queries for Query Analyzer, but no queries with the EXPLAIN data are showing up in the display. Query Analyzer only obtains EXPLAIN information when the MySQL Enterprise Monitor Agent identifies a long running query. If none of your queries exceed the defined threshold, then the EXPLAIN information is not obtain and provided to the Query Analyze for display. To change the query duration at which an EXPLAIN is triggered, you must edit the share/mysql-proxy/quan.lua file within the MySQL Enterprise Monitor Agent directory on each server. You need to change the value configured in the auto_explain_min_exec_time_us.