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;
10
drop table if exists test.no_index_tab;
11
update performance_schema.setup_consumers set enabled='YES';
12
insert into marker set a = 1;
13
create table test.no_index_tab
14
( a varchar(255) not null, b int not null) engine = CSV;
15
insert into marker set a = 1;
16
show create table test.no_index_tab;
18
no_index_tab CREATE TABLE `no_index_tab` (
19
`a` varchar(255) NOT NULL,
21
) ENGINE=CSV DEFAULT CHARSET=latin1
22
insert into marker set a = 1;
23
insert into test.no_index_tab set a = 'foo', b = 1;
24
insert into marker set a = 1;
25
insert into test.no_index_tab set a = 'foo', b = 2;
26
insert into marker set a = 1;
27
insert into test.no_index_tab set a = 'foo', b = 3;
28
insert into marker set a = 1;
29
select * from test.no_index_tab;
34
insert into marker set a = 1;
35
update test.no_index_tab set a = 'bar';
36
insert into marker set a = 1;
37
select * from test.no_index_tab limit 2;
41
insert into marker set a = 1;
42
delete from test.no_index_tab where b = 3;
43
insert into marker set a = 1;
44
select * from test.no_index_tab;
48
insert into marker set a = 1;
49
optimize table test.no_index_tab;
50
Table Op Msg_type Msg_text
51
test.no_index_tab optimize note The storage engine for the table doesn't support optimize
52
insert into marker set a = 1;
53
select * from test.no_index_tab;
57
insert into marker set a = 1;
58
truncate table test.no_index_tab;
59
insert into marker set a = 1;
60
drop table test.no_index_tab;
61
update performance_schema.setup_consumers set enabled='NO';
63
left(source, locate(":", source)) as short_source,
64
object_type, object_schema,
65
if (locate("#sql-", object_name), "#sql-XXXX", object_name)
67
operation, number_of_bytes
68
from performance_schema.events_waits_history_long
69
where event_name like 'wait/io/table/%'
70
and object_schema in ("test")
71
order by thread_id, event_id;
72
event_name short_source object_type object_schema pretty_name operation number_of_bytes
73
wait/io/table/sql/handler handler.cc: TABLE test marker insert NULL
74
wait/io/table/sql/handler handler.cc: TABLE test marker insert NULL
75
wait/io/table/sql/handler handler.cc: TABLE test marker insert NULL
76
wait/io/table/sql/handler handler.cc: TABLE test no_index_tab insert NULL
77
wait/io/table/sql/handler handler.cc: TABLE test marker insert NULL
78
wait/io/table/sql/handler handler.cc: TABLE test no_index_tab insert NULL
79
wait/io/table/sql/handler handler.cc: TABLE test marker insert NULL
80
wait/io/table/sql/handler handler.cc: TABLE test no_index_tab insert NULL
81
wait/io/table/sql/handler handler.cc: TABLE test marker insert NULL
82
wait/io/table/sql/handler handler.cc: TABLE test no_index_tab fetch NULL
83
wait/io/table/sql/handler handler.cc: TABLE test no_index_tab fetch NULL
84
wait/io/table/sql/handler handler.cc: TABLE test no_index_tab fetch NULL
85
wait/io/table/sql/handler handler.cc: TABLE test no_index_tab fetch NULL
86
wait/io/table/sql/handler handler.cc: TABLE test marker insert NULL
87
wait/io/table/sql/handler handler.cc: TABLE test no_index_tab fetch NULL
88
wait/io/table/sql/handler handler.cc: TABLE test no_index_tab update NULL
89
wait/io/table/sql/handler handler.cc: TABLE test no_index_tab fetch NULL
90
wait/io/table/sql/handler handler.cc: TABLE test no_index_tab update NULL
91
wait/io/table/sql/handler handler.cc: TABLE test no_index_tab fetch NULL
92
wait/io/table/sql/handler handler.cc: TABLE test no_index_tab update NULL
93
wait/io/table/sql/handler handler.cc: TABLE test no_index_tab fetch NULL
94
wait/io/table/sql/handler handler.cc: TABLE test marker insert NULL
95
wait/io/table/sql/handler handler.cc: TABLE test no_index_tab fetch NULL
96
wait/io/table/sql/handler handler.cc: TABLE test no_index_tab fetch NULL
97
wait/io/table/sql/handler handler.cc: TABLE test marker insert NULL
98
wait/io/table/sql/handler handler.cc: TABLE test no_index_tab fetch NULL
99
wait/io/table/sql/handler handler.cc: TABLE test no_index_tab fetch NULL
100
wait/io/table/sql/handler handler.cc: TABLE test no_index_tab fetch NULL
101
wait/io/table/sql/handler handler.cc: TABLE test no_index_tab delete NULL
102
wait/io/table/sql/handler handler.cc: TABLE test no_index_tab fetch NULL
103
wait/io/table/sql/handler handler.cc: TABLE test marker insert NULL
104
wait/io/table/sql/handler handler.cc: TABLE test no_index_tab fetch NULL
105
wait/io/table/sql/handler handler.cc: TABLE test no_index_tab fetch NULL
106
wait/io/table/sql/handler handler.cc: TABLE test no_index_tab fetch NULL
107
wait/io/table/sql/handler handler.cc: TABLE test marker insert NULL
108
wait/io/table/sql/handler handler.cc: TABLE test marker insert NULL
109
wait/io/table/sql/handler handler.cc: TABLE test no_index_tab fetch NULL
110
wait/io/table/sql/handler handler.cc: TABLE test no_index_tab fetch NULL
111
wait/io/table/sql/handler handler.cc: TABLE test no_index_tab fetch NULL
112
wait/io/table/sql/handler handler.cc: TABLE test marker insert NULL
113
wait/io/table/sql/handler handler.cc: TABLE test marker insert NULL
114
show status like 'performance_schema_%';
116
Performance_schema_accounts_lost 0
117
Performance_schema_cond_classes_lost 0
118
Performance_schema_cond_instances_lost 0
119
Performance_schema_digest_lost 0
120
Performance_schema_file_classes_lost 0
121
Performance_schema_file_handles_lost 0
122
Performance_schema_file_instances_lost 0
123
Performance_schema_hosts_lost 0
124
Performance_schema_locker_lost 0
125
Performance_schema_mutex_classes_lost 0
126
Performance_schema_mutex_instances_lost 0
127
Performance_schema_rwlock_classes_lost 0
128
Performance_schema_rwlock_instances_lost 0
129
Performance_schema_session_connect_attrs_lost 0
130
Performance_schema_socket_classes_lost 0
131
Performance_schema_socket_instances_lost 0
132
Performance_schema_stage_classes_lost 0
133
Performance_schema_statement_classes_lost 0
134
Performance_schema_table_handles_lost 0
135
Performance_schema_table_instances_lost 0
136
Performance_schema_thread_classes_lost 0
137
Performance_schema_thread_instances_lost 0
138
Performance_schema_users_lost 0
139
truncate performance_schema.events_waits_history_long;
141
update performance_schema.setup_consumers set enabled='NO';
142
truncate performance_schema.events_waits_history_long;
143
drop table test.marker;
145
update performance_schema.setup_instruments set enabled='YES';
146
update performance_schema.setup_consumers set enabled='YES';