System Monitoring Plugins and Connectors (MOSC)

MOSC Banner

MyQuery analyser not working

MySQL Monitor Version: 8.0.29.1359

MySQL Enterprise Server Version: 5.6


MySQL Analyser is not working for any hosts.

mysql> SELECT * FROM performance_schema.setup_consumers WHERE name = 'statements_digest';

+-------------------+---------+

| NAME       | ENABLED |

+-------------------+---------+

| statements_digest | YES   |

+-------------------+---------+

1 row in set (0.00 sec)


mysql> SHOW GLOBAL VARIABLES LIKE 'performance_schema_digests_size';

+---------------------------------+-------+

| Variable_name          | Value |

+---------------------------------+-------+

| performance_schema_digests_size | 10000 |

+---------------------------------+-------+

1 row in set (0.00 sec)


mysql> SHOW GLOBAL STATUS LIKE 'Performance_schema_digest_lost';

+--------------------------------+-------+

| Variable_name         | Value |

+--------------------------------+-------+

| Performance_schema_digest_lost | 0   |

+--------------------------------+-------+

1 row in set (0.00 sec)


mysql> SELECT * FROM performance_schema.setup_consumers where name =

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center