Debian Codegraph @

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

raw
1 drop table if exists test.marker;
2 create table test.marker(a int);
3 update performance_schema.setup_consumers set enabled='NO';
4 update performance_schema.setup_instruments set enabled='NO';
5 update performance_schema.setup_instruments set enabled='YES'
6 where name like "wait/io/table/%";
7 truncate table performance_schema.events_waits_history_long;
8 flush status;
9 flush tables;
10 # We are forced to suppress here the server response.
11 optimize table mysql.host;
12 optimize table mysql.user;
13 optimize table mysql.db;
14 optimize table mysql.proxies_priv;
15 optimize table mysql.tables_priv;
16 optimize table mysql.procs_priv;
17 optimize table mysql.servers;
18 flush privileges;
19 show create table test.marker;
20 show global status;
21 show global variables;
22 update performance_schema.setup_consumers set enabled='YES';
23 update performance_schema.setup_objects set enabled='YES'
24 where object_type='TABLE' and object_schema= 'mysql';
25 flush privileges;
26 insert into test.marker set a = 1;
27 insert into test.marker set a = 1;
28 insert into test.marker set a = 1;
29 show global variables like "performance_schema%table%";
30 Variable_name Value
31 performance_schema_max_table_handles -1
32 performance_schema_max_table_instances -1
33 performance_schema_max_table_lock_stat -1
34 show global status like "performance_schema%table%";
35 Variable_name Value
36 Performance_schema_table_handles_lost 0
37 Performance_schema_table_instances_lost 0
38 Performance_schema_table_lock_stat_lost 0
39 update performance_schema.setup_consumers set enabled='NO';
40 select event_name,
41 left(source, locate(":", source)) as short_source,
42 object_type, object_schema,
43 if (locate("#sql-", object_name), "#sql-XXXX", object_name)
44 as pretty_name,
45 operation, number_of_bytes
46 from performance_schema.events_waits_history_long
47 where event_name like 'wait/io/table/%'
48 and object_schema in ("test", "mysql")
49 order by thread_id, event_id;
50 event_name short_source object_type object_schema pretty_name operation number_of_bytes
51 wait/io/table/sql/handler handler.cc: TABLE mysql user fetch 1
52 wait/io/table/sql/handler handler.cc: TABLE mysql user fetch 1
53 wait/io/table/sql/handler handler.cc: TABLE mysql user fetch 1
54 wait/io/table/sql/handler handler.cc: TABLE mysql user fetch 1
55 wait/io/table/sql/handler handler.cc: TABLE mysql user fetch 1
56 wait/io/table/sql/handler handler.cc: TABLE mysql db fetch 1
57 wait/io/table/sql/handler handler.cc: TABLE mysql db fetch 1
58 wait/io/table/sql/handler handler.cc: TABLE mysql db fetch 1
59 wait/io/table/sql/handler handler.cc: TABLE mysql db fetch 1
60 wait/io/table/sql/handler handler.cc: TABLE mysql proxies_priv fetch 1
61 wait/io/table/sql/handler handler.cc: TABLE mysql proxies_priv fetch 1
62 wait/io/table/sql/handler handler.cc: TABLE mysql global_grants fetch 1
63 wait/io/table/sql/handler handler.cc: TABLE mysql global_grants fetch 1
64 wait/io/table/sql/handler handler.cc: TABLE mysql global_grants fetch 1
65 wait/io/table/sql/handler handler.cc: TABLE mysql global_grants fetch 1
66 wait/io/table/sql/handler handler.cc: TABLE mysql global_grants fetch 1
67 wait/io/table/sql/handler handler.cc: TABLE mysql global_grants fetch 1
68 wait/io/table/sql/handler handler.cc: TABLE mysql global_grants fetch 1
69 wait/io/table/sql/handler handler.cc: TABLE mysql global_grants fetch 1
70 wait/io/table/sql/handler handler.cc: TABLE mysql global_grants fetch 1
71 wait/io/table/sql/handler handler.cc: TABLE mysql global_grants fetch 1
72 wait/io/table/sql/handler handler.cc: TABLE mysql global_grants fetch 1
73 wait/io/table/sql/handler handler.cc: TABLE mysql global_grants fetch 1
74 wait/io/table/sql/handler handler.cc: TABLE mysql global_grants fetch 1
75 wait/io/table/sql/handler handler.cc: TABLE mysql global_grants fetch 1
76 wait/io/table/sql/handler handler.cc: TABLE mysql global_grants fetch 1
77 wait/io/table/sql/handler handler.cc: TABLE mysql global_grants fetch 1
78 wait/io/table/sql/handler handler.cc: TABLE mysql global_grants fetch 1
79 wait/io/table/sql/handler handler.cc: TABLE mysql global_grants fetch 1
80 wait/io/table/sql/handler handler.cc: TABLE mysql global_grants fetch 1
81 wait/io/table/sql/handler handler.cc: TABLE mysql global_grants fetch 1
82 wait/io/table/sql/handler handler.cc: TABLE mysql global_grants fetch 1
83 wait/io/table/sql/handler handler.cc: TABLE mysql global_grants fetch 1
84 wait/io/table/sql/handler handler.cc: TABLE mysql global_grants fetch 1
85 wait/io/table/sql/handler handler.cc: TABLE mysql global_grants fetch 1
86 wait/io/table/sql/handler handler.cc: TABLE mysql global_grants fetch 1
87 wait/io/table/sql/handler handler.cc: TABLE mysql global_grants fetch 1
88 wait/io/table/sql/handler handler.cc: TABLE mysql global_grants fetch 1
89 wait/io/table/sql/handler handler.cc: TABLE mysql global_grants fetch 1
90 wait/io/table/sql/handler handler.cc: TABLE mysql global_grants fetch 1
91 wait/io/table/sql/handler handler.cc: TABLE mysql global_grants fetch 1
92 wait/io/table/sql/handler handler.cc: TABLE mysql global_grants fetch 1
93 wait/io/table/sql/handler handler.cc: TABLE mysql global_grants fetch 1
94 wait/io/table/sql/handler handler.cc: TABLE mysql global_grants fetch 1
95 wait/io/table/sql/handler handler.cc: TABLE mysql global_grants fetch 1
96 wait/io/table/sql/handler handler.cc: TABLE mysql global_grants fetch 1
97 wait/io/table/sql/handler handler.cc: TABLE mysql global_grants fetch 1
98 wait/io/table/sql/handler handler.cc: TABLE mysql global_grants fetch 1
99 wait/io/table/sql/handler handler.cc: TABLE mysql global_grants fetch 1
100 wait/io/table/sql/handler handler.cc: TABLE mysql global_grants fetch 1
101 wait/io/table/sql/handler handler.cc: TABLE mysql global_grants fetch 1
102 wait/io/table/sql/handler handler.cc: TABLE mysql global_grants fetch 1
103 wait/io/table/sql/handler handler.cc: TABLE mysql global_grants fetch 1
104 wait/io/table/sql/handler handler.cc: TABLE mysql global_grants fetch 1
105 wait/io/table/sql/handler handler.cc: TABLE mysql global_grants fetch 1
106 wait/io/table/sql/handler handler.cc: TABLE mysql global_grants fetch 1
107 wait/io/table/sql/handler handler.cc: TABLE mysql global_grants fetch 1
108 wait/io/table/sql/handler handler.cc: TABLE mysql global_grants fetch 1
109 wait/io/table/sql/handler handler.cc: TABLE mysql global_grants fetch 1
110 wait/io/table/sql/handler handler.cc: TABLE mysql global_grants fetch 1
111 wait/io/table/sql/handler handler.cc: TABLE mysql global_grants fetch 1
112 wait/io/table/sql/handler handler.cc: TABLE mysql global_grants fetch 1
113 wait/io/table/sql/handler handler.cc: TABLE mysql global_grants fetch 1
114 wait/io/table/sql/handler handler.cc: TABLE mysql global_grants fetch 1
115 wait/io/table/sql/handler handler.cc: TABLE mysql role_edges fetch 1
116 wait/io/table/sql/handler handler.cc: TABLE mysql default_roles fetch 1
117 wait/io/table/sql/handler handler.cc: TABLE mysql tables_priv fetch 1
118 wait/io/table/sql/handler handler.cc: TABLE mysql tables_priv fetch 1
119 wait/io/table/sql/handler handler.cc: TABLE mysql tables_priv fetch 1
120 wait/io/table/sql/handler handler.cc: TABLE mysql procs_priv fetch 1
121 wait/io/table/sql/handler handler.cc: TABLE mysql servers fetch 1
122 wait/io/table/sql/handler handler.cc: TABLE test marker insert 1
123 wait/io/table/sql/handler handler.cc: TABLE test marker insert 1
124 wait/io/table/sql/handler handler.cc: TABLE test marker insert 1
125 show global status like 'performance_schema_%_lost';
126 Variable_name Value
127 Performance_schema_accounts_lost 0
128 Performance_schema_cond_classes_lost 0
129 Performance_schema_cond_instances_lost 0
130 Performance_schema_digest_lost 0
131 Performance_schema_file_classes_lost 0
132 Performance_schema_file_handles_lost 0
133 Performance_schema_file_instances_lost 0
134 Performance_schema_hosts_lost 0
135 Performance_schema_index_stat_lost 0
136 Performance_schema_locker_lost 0
137 Performance_schema_memory_classes_lost 0
138 Performance_schema_metadata_lock_lost 0
139 Performance_schema_mutex_classes_lost 0
140 Performance_schema_mutex_instances_lost 0
141 Performance_schema_nested_statement_lost 0
142 Performance_schema_prepared_statements_lost 0
143 Performance_schema_program_lost 0
144 Performance_schema_rwlock_classes_lost 0
145 Performance_schema_rwlock_instances_lost 0
146 Performance_schema_session_connect_attrs_lost 0
147 Performance_schema_socket_classes_lost 0
148 Performance_schema_socket_instances_lost 0
149 Performance_schema_stage_classes_lost 0
150 Performance_schema_statement_classes_lost 0
151 Performance_schema_table_handles_lost 0
152 Performance_schema_table_instances_lost 0
153 Performance_schema_table_lock_stat_lost 0
154 Performance_schema_thread_classes_lost 0
155 Performance_schema_thread_instances_lost 0
156 Performance_schema_users_lost 0
157 truncate performance_schema.events_waits_history_long;
158 flush status;
159 update performance_schema.setup_consumers set enabled='NO';
160 truncate performance_schema.events_waits_history_long;
161 drop table test.marker;
162 flush status;
163 update performance_schema.setup_instruments set enabled='YES';
164 update performance_schema.setup_consumers set enabled='YES';
165 update performance_schema.setup_objects set enabled='NO'
166 where object_type='TABLE' and object_schema= 'mysql';