Debian Codegraph @

mysql-test/suite/perfschema/r/processlist_no_pfs.result

raw
1 show databases;
2 Database
3 information_schema
4 mtr
5 mysql
6 performance_schema
7 sys
8 test
9 select count(*) from performance_schema.performance_timers;
10 count(*)
11 0
12 select count(*) from performance_schema.setup_consumers;
13 count(*)
14 0
15 select count(*) > 4 from performance_schema.setup_instruments;
16 count(*) > 4
17 0
18 select count(*) from performance_schema.setup_timers;
19 count(*)
20 0
21 Warnings:
22 Warning 1681 'performance_schema.setup_timers' is deprecated and will be removed in a future release.
23 select * from performance_schema.accounts;
24 select * from performance_schema.cond_instances;
25 select * from performance_schema.events_stages_current;
26 select * from performance_schema.events_stages_history;
27 select * from performance_schema.events_stages_history_long;
28 select * from performance_schema.events_stages_summary_by_account_by_event_name;
29 select * from performance_schema.events_stages_summary_by_host_by_event_name;
30 select * from performance_schema.events_stages_summary_by_thread_by_event_name;
31 select * from performance_schema.events_stages_summary_by_user_by_event_name;
32 select * from performance_schema.events_stages_summary_global_by_event_name;
33 select * from performance_schema.events_statements_current;
34 select * from performance_schema.events_statements_history;
35 select * from performance_schema.events_statements_history_long;
36 select * from performance_schema.events_statements_summary_by_account_by_event_name;
37 select * from performance_schema.events_statements_summary_by_digest;
38 select * from performance_schema.events_statements_summary_by_host_by_event_name;
39 select * from performance_schema.events_statements_summary_by_thread_by_event_name;
40 select * from performance_schema.events_statements_summary_by_user_by_event_name;
41 select * from performance_schema.events_statements_summary_global_by_event_name;
42 select * from performance_schema.events_transactions_current;
43 select * from performance_schema.events_transactions_history;
44 select * from performance_schema.events_transactions_history_long;
45 select * from performance_schema.events_transactions_summary_by_account_by_event_name;
46 select * from performance_schema.events_transactions_summary_by_host_by_event_name;
47 select * from performance_schema.events_transactions_summary_by_thread_by_event_name;
48 select * from performance_schema.events_transactions_summary_by_user_by_event_name;
49 select * from performance_schema.events_transactions_summary_global_by_event_name;
50 select * from performance_schema.events_waits_current;
51 select * from performance_schema.events_waits_history;
52 select * from performance_schema.events_waits_history_long;
53 select * from performance_schema.events_waits_summary_by_account_by_event_name;
54 select * from performance_schema.events_waits_summary_by_host_by_event_name;
55 select * from performance_schema.events_waits_summary_by_instance;
56 select * from performance_schema.events_waits_summary_by_thread_by_event_name;
57 select * from performance_schema.events_waits_summary_by_user_by_event_name;
58 select * from performance_schema.events_waits_summary_global_by_event_name;
59 select * from performance_schema.memory_summary_by_account_by_event_name;
60 select * from performance_schema.memory_summary_by_host_by_event_name;
61 select * from performance_schema.memory_summary_by_thread_by_event_name;
62 select * from performance_schema.memory_summary_by_user_by_event_name;
63 select * from performance_schema.memory_summary_global_by_event_name;
64 select * from performance_schema.file_instances;
65 select * from performance_schema.file_summary_by_event_name;
66 select * from performance_schema.file_summary_by_instance;
67 select * from performance_schema.host_cache;
68 select * from performance_schema.hosts;
69 select * from performance_schema.memory_summary_by_account_by_event_name;
70 select * from performance_schema.memory_summary_by_host_by_event_name;
71 select * from performance_schema.memory_summary_by_thread_by_event_name;
72 select * from performance_schema.memory_summary_by_user_by_event_name;
73 select * from performance_schema.memory_summary_global_by_event_name;
74 select * from performance_schema.metadata_locks;
75 select * from performance_schema.mutex_instances;
76 select * from performance_schema.objects_summary_global_by_type;
77 select * from performance_schema.performance_timers;
78 select * from performance_schema.rwlock_instances;
79 select * from performance_schema.session_account_connect_attrs;
80 select * from performance_schema.session_connect_attrs;
81 select * from performance_schema.setup_actors;
82 select * from performance_schema.setup_consumers;
83 select * from performance_schema.setup_instruments;
84 select * from performance_schema.setup_objects;
85 select * from performance_schema.setup_timers;
86 select * from performance_schema.socket_instances;
87 select * from performance_schema.socket_summary_by_instance;
88 select * from performance_schema.socket_summary_by_event_name;
89 select * from performance_schema.table_handles;
90 select * from performance_schema.table_io_waits_summary_by_index_usage;
91 select * from performance_schema.table_io_waits_summary_by_table;
92 select * from performance_schema.table_lock_waits_summary_by_table;
93 select * from performance_schema.threads;
94 select * from performance_schema.users;
95 select * from performance_schema.replication_connection_configuration;
96 select * from performance_schema.replication_connection_status;
97 select * from performance_schema.replication_applier_configuration;
98 select * from performance_schema.replication_applier_status;
99 select * from performance_schema.replication_applier_status_by_coordinator;
100 select * from performance_schema.replication_applier_status_by_worker;
101 select * from performance_schema.global_status;
102 select * from performance_schema.status_by_thread;
103 select * from performance_schema.status_by_user;
104 select * from performance_schema.status_by_host;
105 select * from performance_schema.status_by_account;
106 select * from performance_schema.session_status;
107 select * from performance_schema.global_variables;
108 select * from performance_schema.variables_by_thread;
109 select * from performance_schema.session_variables;
110 show global variables like "performance_schema%";
111 Variable_name Value
112 performance_schema OFF
113 performance_schema_accounts_size 0
114 performance_schema_digests_size 0
115 performance_schema_events_stages_history_long_size 0
116 performance_schema_events_stages_history_size 0
117 performance_schema_events_statements_history_long_size 0
118 performance_schema_events_statements_history_size 0
119 performance_schema_events_transactions_history_long_size 0
120 performance_schema_events_transactions_history_size 0
121 performance_schema_events_waits_history_long_size 0
122 performance_schema_events_waits_history_size 0
123 performance_schema_hosts_size 0
124 performance_schema_max_cond_classes 0
125 performance_schema_max_cond_instances 0
126 performance_schema_max_digest_length 0
127 performance_schema_max_file_classes 0
128 performance_schema_max_file_handles 0
129 performance_schema_max_file_instances 0
130 performance_schema_max_index_stat 0
131 performance_schema_max_memory_classes 0
132 performance_schema_max_metadata_locks 0
133 performance_schema_max_mutex_classes 0
134 performance_schema_max_mutex_instances 0
135 performance_schema_max_prepared_statements_instances 0
136 performance_schema_max_program_instances 0
137 performance_schema_max_rwlock_classes 0
138 performance_schema_max_rwlock_instances 0
139 performance_schema_max_socket_classes 0
140 performance_schema_max_socket_instances 0
141 performance_schema_max_sql_text_length 0
142 performance_schema_max_stage_classes 0
143 performance_schema_max_statement_classes 0
144 performance_schema_max_statement_stack 0
145 performance_schema_max_table_handles 0
146 performance_schema_max_table_instances 0
147 performance_schema_max_table_lock_stat 0
148 performance_schema_max_thread_classes 0
149 performance_schema_max_thread_instances 0
150 performance_schema_session_connect_attrs_size 0
151 performance_schema_setup_actors_size 0
152 performance_schema_setup_objects_size 0
153 performance_schema_show_processlist ON
154 performance_schema_users_size 0
155 show engine PERFORMANCE_SCHEMA status;
156 show global status like "performance_schema%";
157
158 select * from information_schema.engines
159 where engine = "PERFORMANCE_SCHEMA";
160 ENGINE SUPPORT COMMENT TRANSACTIONS XA SAVEPOINTS
161 PERFORMANCE_SCHEMA YES Performance Schema NO NO NO
162
163 # If the Performance Schema is disabled, then expect
164 # performance-schema-show-processlist = OFF
165 # regardless of its initial setting
166
167 select @@global.performance_schema_show_processlist;
168 @@global.performance_schema_show_processlist
169 1
170
171 # If the Performance Schema is disabled, then setting
172 # performance-schema-show-processlist = ON
173 # succeeds, SHOW PROCESSLIST returns no data.
174
175 set @@global.performance_schema_show_processlist = ON;
176 SHOW PROCESSLIST;
177 Id User Host db Command Time State Info
178
179 show global variables like "performance_schema";
180 Variable_name Value
181 performance_schema OFF