Debian Codegraph @

mysql-test/suite/perfschema/r/start_server_no_prepared_stmts_instances.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 5
12 select count(*) from performance_schema.setup_consumers;
13 count(*)
14 16
15 select count(*) > 4 from performance_schema.setup_instruments;
16 count(*) > 4
17 1
18 select * from performance_schema.accounts;
19 select * from performance_schema.cond_instances;
20 select * from performance_schema.events_stages_current;
21 select * from performance_schema.events_stages_history;
22 select * from performance_schema.events_stages_history_long;
23 select * from performance_schema.events_stages_summary_by_account_by_event_name;
24 select * from performance_schema.events_stages_summary_by_host_by_event_name;
25 select * from performance_schema.events_stages_summary_by_thread_by_event_name;
26 select * from performance_schema.events_stages_summary_by_user_by_event_name;
27 select * from performance_schema.events_stages_summary_global_by_event_name;
28 select * from performance_schema.events_statements_current;
29 select * from performance_schema.events_statements_histogram_by_digest;
30 select * from performance_schema.events_statements_histogram_global;
31 select * from performance_schema.events_statements_history;
32 select * from performance_schema.events_statements_history_long;
33 select * from performance_schema.events_statements_summary_by_account_by_event_name;
34 select * from performance_schema.events_statements_summary_by_digest;
35 select * from performance_schema.events_statements_summary_by_host_by_event_name;
36 select * from performance_schema.events_statements_summary_by_thread_by_event_name;
37 select * from performance_schema.events_statements_summary_by_user_by_event_name;
38 select * from performance_schema.events_statements_summary_global_by_event_name;
39 select * from performance_schema.events_transactions_current;
40 select * from performance_schema.events_transactions_history;
41 select * from performance_schema.events_transactions_history_long;
42 select * from performance_schema.events_transactions_summary_by_account_by_event_name;
43 select * from performance_schema.events_transactions_summary_by_host_by_event_name;
44 select * from performance_schema.events_transactions_summary_by_thread_by_event_name;
45 select * from performance_schema.events_transactions_summary_by_user_by_event_name;
46 select * from performance_schema.events_transactions_summary_global_by_event_name;
47 select * from performance_schema.events_waits_current;
48 select * from performance_schema.events_waits_history;
49 select * from performance_schema.events_waits_history_long;
50 select * from performance_schema.events_waits_summary_by_account_by_event_name;
51 select * from performance_schema.events_waits_summary_by_host_by_event_name;
52 select * from performance_schema.events_waits_summary_by_instance;
53 select * from performance_schema.events_waits_summary_by_thread_by_event_name;
54 select * from performance_schema.events_waits_summary_by_user_by_event_name;
55 select * from performance_schema.events_waits_summary_global_by_event_name;
56 select * from performance_schema.memory_summary_by_account_by_event_name;
57 select * from performance_schema.memory_summary_by_host_by_event_name;
58 select * from performance_schema.memory_summary_by_thread_by_event_name;
59 select * from performance_schema.memory_summary_by_user_by_event_name;
60 select * from performance_schema.memory_summary_global_by_event_name;
61 select * from performance_schema.events_errors_summary_by_account_by_error;
62 select * from performance_schema.events_errors_summary_by_host_by_error;
63 select * from performance_schema.events_errors_summary_by_thread_by_error;
64 select * from performance_schema.events_errors_summary_by_user_by_error;
65 select * from performance_schema.events_errors_summary_global_by_error;
66 select * from performance_schema.file_instances;
67 select * from performance_schema.file_summary_by_event_name;
68 select * from performance_schema.file_summary_by_instance;
69 select * from performance_schema.host_cache;
70 select * from performance_schema.hosts;
71 select * from performance_schema.memory_summary_by_account_by_event_name;
72 select * from performance_schema.memory_summary_by_host_by_event_name;
73 select * from performance_schema.memory_summary_by_thread_by_event_name;
74 select * from performance_schema.memory_summary_by_user_by_event_name;
75 select * from performance_schema.memory_summary_global_by_event_name;
76 select * from performance_schema.metadata_locks;
77 select * from performance_schema.mutex_instances;
78 select * from performance_schema.objects_summary_global_by_type;
79 select * from performance_schema.performance_timers;
80 select * from performance_schema.rwlock_instances;
81 select * from performance_schema.data_locks;
82 select * from performance_schema.data_lock_waits;
83 select * from performance_schema.session_account_connect_attrs;
84 select * from performance_schema.session_connect_attrs;
85 select * from performance_schema.setup_actors;
86 select * from performance_schema.setup_consumers;
87 select * from performance_schema.setup_instruments;
88 select * from performance_schema.setup_objects;
89 select * from performance_schema.setup_threads;
90 select * from performance_schema.socket_instances;
91 select * from performance_schema.socket_summary_by_instance;
92 select * from performance_schema.socket_summary_by_event_name;
93 select * from performance_schema.table_handles;
94 select * from performance_schema.table_io_waits_summary_by_index_usage;
95 select * from performance_schema.table_io_waits_summary_by_table;
96 select * from performance_schema.table_lock_waits_summary_by_table;
97 select * from performance_schema.threads;
98 select * from performance_schema.users;
99 select * from performance_schema.replication_connection_configuration;
100 select * from performance_schema.replication_connection_status;
101 select * from performance_schema.replication_applier_configuration;
102 select * from performance_schema.replication_applier_status;
103 select * from performance_schema.replication_applier_status_by_coordinator;
104 select * from performance_schema.replication_applier_status_by_worker;
105 select * from performance_schema.global_status;
106 select * from performance_schema.status_by_thread;
107 select * from performance_schema.status_by_user;
108 select * from performance_schema.status_by_host;
109 select * from performance_schema.status_by_account;
110 select * from performance_schema.session_status;
111 select * from performance_schema.global_variables;
112 select * from performance_schema.variables_by_thread;
113 select * from performance_schema.session_variables;
114 show engine PERFORMANCE_SCHEMA status;
115 show global status like "performance_schema%";
116 CREATE DATABASE db;
117 USE db;
118 show global variables like "performance_schema_max_prepared_statements_instances";
119 Variable_name Value
120 performance_schema_max_prepared_statements_instances 0
121 select count(*) from performance_schema.prepared_statements_instances;
122 count(*)
123 0
124 truncate table performance_schema.prepared_statements_instances;
125 CREATE TABLE t1 (a INT NOT NULL);
126 INSERT INTO t1 VALUES (4), (8), (11), (32), (80);
127 PREPARE st1 FROM 'SELECT SQRT(POW(?,2) + POW(?,2)) AS hypotenuse';
128 SET @table = 't1';
129 SET @s = CONCAT('SELECT * FROM ', @table);
130 PREPARE st2 FROM @s;
131 PREPARE st3 FROM 'INSERT INTO t1 SELECT * FROM t1 WHERE a<=?';
132 PREPARE st4 FROM
133 '(SELECT a FROM t1) UNION (SELECT a+10 FROM t1) ORDER BY RAND()*0+a';
134 show global status like "%performance_schema_prepared_statements_lost%";
135 Variable_name Value
136 Performance_schema_prepared_statements_lost 4
137 SET @a = 3;
138 SET @b = 4;
139 EXECUTE st1 USING @a, @b;
140 hypotenuse
141 5
142 EXECUTE st2;
143 a
144 4
145 8
146 11
147 32
148 80
149 SET @c=3;
150 EXECUTE st3 using @c;
151 EXECUTE st4;
152 a
153 4
154 8
155 11
156 14
157 18
158 21
159 32
160 42
161 80
162 90
163 show global status like "%performance_schema_prepared_statements_lost%";
164 Variable_name Value
165 Performance_schema_prepared_statements_lost 4
166 DEALLOCATE PREPARE st1;
167 DEALLOCATE PREPARE st2;
168 DEALLOCATE PREPARE st3;
169 DEALLOCATE PREPARE st4;
170 DROP TABLE t1;
171 show global status like "%performance_schema_prepared_statements_lost%";
172 Variable_name Value
173 Performance_schema_prepared_statements_lost 4
174 flush status;
175 show global status like "%performance_schema_prepared_statements_lost%";
176 Variable_name Value
177 Performance_schema_prepared_statements_lost 0
178 DROP DATABASE db;