MySQL Forums :: Performance :: performance_schema.events_statements_* not populating


Advanced Search

performance_schema.events_statements_* not populating
Posted by: Ryan Streb ()
Date: March 14, 2017 06:23PM

Hello,

I believe I've configured the relevant variables and setup tables properly, but I cannot get a single statement to appear in the 'performance_schema.events_statements_*' tables.

First, here are the pertinent variables:

mysql> select version();
+-----------------+
| version() |
+-----------------+
| 5.7.17-0011-log |
+-----------------+


mysql> show variables like 'perfo%';
+----------------------------------------------------------+--------+
| Variable_name | Value |
+----------------------------------------------------------+--------+
| performance_schema | ON |
| performance_schema_accounts_size | 100 |
| performance_schema_digests_size | 10000 |
| performance_schema_events_stages_history_long_size | 10000 |
| performance_schema_events_stages_history_size | 10 |
| performance_schema_events_statements_history_long_size | 10000 |
| performance_schema_events_statements_history_size | 10 |
| performance_schema_events_transactions_history_long_size | 10000 |
| performance_schema_events_transactions_history_size | 10 |
| performance_schema_events_waits_history_long_size | 10000 |
| performance_schema_events_waits_history_size | 10 |
| performance_schema_hosts_size | 100 |
| performance_schema_max_cond_classes | 80 |
| performance_schema_max_cond_instances | 33868 |
| performance_schema_max_digest_length | 1024 |
| performance_schema_max_file_classes | 50 |
| performance_schema_max_file_handles | 32768 |
| performance_schema_max_file_instances | 100825 |
| performance_schema_max_index_stat | -1 |
| performance_schema_max_memory_classes | 320 |
| performance_schema_max_metadata_locks | -1 |
| performance_schema_max_mutex_classes | 200 |
| performance_schema_max_mutex_instances | 166340 |
| performance_schema_max_prepared_statements_instances | -1 |
| performance_schema_max_program_instances | -1 |
| performance_schema_max_rwlock_classes | 30 |
| performance_schema_max_rwlock_instances | 99204 |
| performance_schema_max_socket_classes | 10 |
| performance_schema_max_socket_instances | 520 |
| performance_schema_max_sql_text_length | 1024 |
| performance_schema_max_stage_classes | 150 |
| performance_schema_max_statement_classes | 168 |
| performance_schema_max_statement_stack | 10 |
| performance_schema_max_table_handles | 32768 |
| performance_schema_max_table_instances | 20480 |
| performance_schema_max_table_lock_stat | -1 |
| performance_schema_max_thread_classes | 50 |
| performance_schema_max_thread_instances | 600 |
| performance_schema_session_connect_attrs_size | 512 |
| performance_schema_setup_actors_size | 100 |
| performance_schema_setup_objects_size | 100 |
| performance_schema_users_size | 100 |
+----------------------------------------------------------+--------+

and next, each of the P_S.setup_* tables:


mysql> select * from setup_actors;
+------+------+------+---------+---------+
| HOST | USER | ROLE | ENABLED | HISTORY |
+------+------+------+---------+---------+
| % | % | % | YES | YES |
+------+------+------+---------+---------+

mysql> select * from setup_objects;
+-------------+--------------------+-------------+---------+-------+
| OBJECT_TYPE | OBJECT_SCHEMA | OBJECT_NAME | ENABLED | TIMED |
+-------------+--------------------+-------------+---------+-------+
| EVENT | mysql | % | NO | NO |
| EVENT | performance_schema | % | NO | NO |
| EVENT | information_schema | % | NO | NO |
| EVENT | % | % | YES | YES |
| FUNCTION | mysql | % | NO | NO |
| FUNCTION | performance_schema | % | NO | NO |
| FUNCTION | information_schema | % | NO | NO |
| FUNCTION | % | % | YES | YES |
| PROCEDURE | mysql | % | NO | NO |
| PROCEDURE | performance_schema | % | NO | NO |
| PROCEDURE | information_schema | % | NO | NO |
| PROCEDURE | % | % | YES | YES |
| TABLE | mysql | % | NO | NO |
| TABLE | performance_schema | % | NO | NO |
| TABLE | information_schema | % | NO | NO |
| TABLE | % | % | YES | YES |
| TRIGGER | mysql | % | NO | NO |
| TRIGGER | performance_schema | % | NO | NO |
| TRIGGER | information_schema | % | NO | NO |
| TRIGGER | % | % | YES | YES |
+-------------+--------------------+-------------+---------+-------+
20 rows in set (0.00 sec)



mysql> select * from setup_consumers;
+----------------------------------+---------+
| NAME | ENABLED |
+----------------------------------+---------+
| events_stages_current | YES |
| events_stages_history | YES |
| events_stages_history_long | YES |
| events_statements_current | YES |
| events_statements_history | YES |
| events_statements_history_long | YES |
| events_transactions_current | YES |
| events_transactions_history | YES |
| events_transactions_history_long | YES |
| events_waits_current | YES |
| events_waits_history | YES |
| events_waits_history_long | YES |
| global_instrumentation | YES |
| thread_instrumentation | YES |
| statements_digest | YES |
+----------------------------------+---------+
15 rows in set (0.00 sec)




# (all instruments enabled; not pasting output to save space..)
mysql> select count(*) from setup_instruments where enabled = 'YES';
+----------+
| count(*) |
+----------+
| 982 |
+----------+
1 row in set (0.00 sec)


Now, I run a simple query on a test schema

mysql> use rtest;

mysql> update c set c_id = 9 where c_id = 1;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

# observe, nothing was collected.
mysql> select count(*) from performance_schema.events_statements_history;
+----------+
| count(*) |
+----------+
| 0 |
+----------+

mysql> select count(*) from performance_schema.events_statements_current;
+----------+
| count(*) |
+----------+
| 0 |
+----------+

Am I missing something?

Options: ReplyQuote


Subject Views Written By Posted
performance_schema.events_statements_* not populating 61 Ryan Streb 03/14/2017 06:23PM
Re: performance_schema.events_statements_* not populating 46 Øystein Grøvlen 03/15/2017 02:00AM
Re: performance_schema.events_statements_* not populating 15 Ryan Streb 03/15/2017 01:16PM
Re: performance_schema.events_statements_* not populating 19 Ryan Streb 03/17/2017 02:26PM
Re: performance_schema.events_statements_* not populating 14 Ryan Streb 03/15/2017 01:38PM


Sorry, only registered users may post in this forum.

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.