Debian Codegraph @

mysql-test/suite/sysschema/r/pr_ps_setup_show_enabled_instruments.result

raw
1 UPDATE performance_schema.setup_instruments
2 SET ENABLED = 'NO'
3 WHERE NAME NOT LIKE 'memory/performance_schema/%'
4 AND NAME NOT LIKE 'stage/innodb/%'
5 AND NAME NOT LIKE 'statement/com/%'
6 AND NAME <> 'idle';
7 CALL sys.ps_setup_show_enabled_instruments();
8 enabled_instruments timed
9 idle YES
10 memory/performance_schema/accounts NO
11 memory/performance_schema/cond_class NO
12 memory/performance_schema/cond_instances NO
13 memory/performance_schema/events_stages_history NO
14 memory/performance_schema/events_stages_history_long NO
15 memory/performance_schema/events_stages_summary_by_account_by_event_name NO
16 memory/performance_schema/events_stages_summary_by_host_by_event_name NO
17 memory/performance_schema/events_stages_summary_by_thread_by_event_name NO
18 memory/performance_schema/events_stages_summary_by_user_by_event_name NO
19 memory/performance_schema/events_stages_summary_global_by_event_name NO
20 memory/performance_schema/events_statements_current NO
21 memory/performance_schema/events_statements_current.sqltext NO
22 memory/performance_schema/events_statements_current.tokens NO
23 memory/performance_schema/events_statements_history NO
24 memory/performance_schema/events_statements_history.sqltext NO
25 memory/performance_schema/events_statements_history.tokens NO
26 memory/performance_schema/events_statements_history_long NO
27 memory/performance_schema/events_statements_history_long.sqltext NO
28 memory/performance_schema/events_statements_history_long.tokens NO
29 memory/performance_schema/events_statements_summary_by_account_by_event_name NO
30 memory/performance_schema/events_statements_summary_by_digest NO
31 memory/performance_schema/events_statements_summary_by_digest.tokens NO
32 memory/performance_schema/events_statements_summary_by_host_by_event_name NO
33 memory/performance_schema/events_statements_summary_by_program NO
34 memory/performance_schema/events_statements_summary_by_thread_by_event_name NO
35 memory/performance_schema/events_statements_summary_by_user_by_event_name NO
36 memory/performance_schema/events_statements_summary_global_by_event_name NO
37 memory/performance_schema/events_transactions_history NO
38 memory/performance_schema/events_transactions_history_long NO
39 memory/performance_schema/events_transactions_summary_by_account_by_event_name NO
40 memory/performance_schema/events_transactions_summary_by_host_by_event_name NO
41 memory/performance_schema/events_transactions_summary_by_thread_by_event_name NO
42 memory/performance_schema/events_transactions_summary_by_user_by_event_name NO
43 memory/performance_schema/events_waits_history NO
44 memory/performance_schema/events_waits_history_long NO
45 memory/performance_schema/events_waits_summary_by_account_by_event_name NO
46 memory/performance_schema/events_waits_summary_by_host_by_event_name NO
47 memory/performance_schema/events_waits_summary_by_thread_by_event_name NO
48 memory/performance_schema/events_waits_summary_by_user_by_event_name NO
49 memory/performance_schema/file_class NO
50 memory/performance_schema/file_handle NO
51 memory/performance_schema/file_instances NO
52 memory/performance_schema/hosts NO
53 memory/performance_schema/memory_class NO
54 memory/performance_schema/memory_summary_by_account_by_event_name NO
55 memory/performance_schema/memory_summary_by_host_by_event_name NO
56 memory/performance_schema/memory_summary_by_thread_by_event_name NO
57 memory/performance_schema/memory_summary_by_user_by_event_name NO
58 memory/performance_schema/memory_summary_global_by_event_name NO
59 memory/performance_schema/metadata_locks NO
60 memory/performance_schema/mutex_class NO
61 memory/performance_schema/mutex_instances NO
62 memory/performance_schema/prepared_statements_instances NO
63 memory/performance_schema/rwlock_class NO
64 memory/performance_schema/rwlock_instances NO
65 memory/performance_schema/scalable_buffer NO
66 memory/performance_schema/session_connect_attrs NO
67 memory/performance_schema/setup_actors NO
68 memory/performance_schema/setup_objects NO
69 memory/performance_schema/socket_class NO
70 memory/performance_schema/socket_instances NO
71 memory/performance_schema/stage_class NO
72 memory/performance_schema/statement_class NO
73 memory/performance_schema/table_handles NO
74 memory/performance_schema/table_io_waits_summary_by_index_usage NO
75 memory/performance_schema/table_lock_waits_summary_by_table NO
76 memory/performance_schema/table_shares NO
77 memory/performance_schema/threads NO
78 memory/performance_schema/thread_class NO
79 memory/performance_schema/users NO
80 stage/innodb/alter table (end) YES
81 stage/innodb/alter table (insert) YES
82 stage/innodb/alter table (log apply index) YES
83 stage/innodb/alter table (log apply table) YES
84 stage/innodb/alter table (merge sort) YES
85 stage/innodb/alter table (read PK and internal sort) YES
86 stage/innodb/buffer pool load YES
87 statement/com/Binlog Dump YES
88 statement/com/Bulk_execute YES
89 statement/com/Change user YES
90 statement/com/Close stmt YES
91 statement/com/Connect YES
92 statement/com/Connect Out YES
93 statement/com/Create DB YES
94 statement/com/Daemon YES
95 statement/com/Debug YES
96 statement/com/Delayed insert YES
97 statement/com/Drop DB YES
98 statement/com/Error YES
99 statement/com/Execute YES
100 statement/com/Fetch YES
101 statement/com/Field List YES
102 statement/com/Init DB YES
103 statement/com/Kill YES
104 statement/com/Long Data YES
105 statement/com/Ping YES
106 statement/com/Prepare YES
107 statement/com/Processlist YES
108 statement/com/Quit YES
109 statement/com/Refresh YES
110 statement/com/Register Slave YES
111 statement/com/Reset connection YES
112 statement/com/Reset stmt YES
113 statement/com/Set option YES
114 statement/com/Shutdown YES
115 statement/com/Slave_IO YES
116 statement/com/Slave_SQL YES
117 statement/com/Slave_worker YES
118 statement/com/Sleep YES
119 statement/com/Statistics YES
120 statement/com/Table Dump YES
121 statement/com/Time YES
122 statement/com/Unimpl get tid YES
123 UPDATE performance_schema.setup_instruments SET enabled = 'YES', timed = 'YES';
124 TRUNCATE TABLE performance_schema.setup_actors;
125 INSERT INTO performance_schema.setup_actors VALUES ('%', '%', '%', 'YES', 'YES');
126 UPDATE performance_schema.setup_consumers SET enabled = 'YES';
127 UPDATE performance_schema.threads SET instrumented = 'YES';