Why does Query Analyzer not display any queries for the monitored instance?
updated at
MySQL / MariaDB
For General Log & Slow Query Log, Navicat Monitor uses queries to get the log information. You need to enable the general log and slow query log and set log_output to TABLE. Please run the following SQLs
SET GLOBAL general_log = 1;
SET GLOBAL slow_query_log = 1;
SET GLOBAL log_output = 'TABLE';
To enable Performance Schema, you need to start the server with the performance_schema variable set to an appropriate value. For example, use these lines in your my.cnf file:
[mysqld]
performance_schema=ON
Have more questions?
-
Support
-
About Us