1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
|
# Tests for PERFORMANCE_SCHEMA table io
--source include/not_embedded.inc
--source include/have_perfschema.inc
--source ../include/table_io_setup_helper.inc
# Remove "deleted" records from mysql.db that may come from previous tests,
# to avoid displaying spurious fetch.
# There are two possible server reactions which are both ok.
# Table Op Msg_type Msg_text
# mysql.db optimize status OK
# or
# mysql.db optimize status Table is already up to date
# Therefore we suppress the query_log here.
--echo # We are forced to suppress here the server response.
--disable_result_log
optimize table mysql.host;
optimize table mysql.user;
optimize table mysql.db;
optimize table mysql.proxies_priv;
optimize table mysql.tables_priv;
optimize table mysql.procs_priv;
optimize table mysql.servers;
--enable_result_log
# Start recording events
update performance_schema.setup_consumers set enabled='YES';
update performance_schema.setup_objects set enabled='YES'
where object_type='TABLE' and object_schema= 'mysql';
# Code to test
flush privileges;
# This will cause table io in mysql system security tables
insert into test.marker set a = 1;
# This will not, the ACL cache is already loaded
insert into test.marker set a = 1;
insert into test.marker set a = 1;
show variables where
`Variable_name` != "performance_schema_max_statement_classes" and
`Variable_name` like "performance_schema%";
show status like "performance_schema%";
# Stop recording events + pull results
let $schema_to_dump= "test", "mysql";
--source ../include/table_io_result_helper.inc
# Cleanup
--source ../include/table_io_cleanup_helper.inc
update performance_schema.setup_objects set enabled='NO'
where object_type='TABLE' and object_schema= 'mysql';
|
