Debian Codegraph @

mysql-test/suite/perfschema/r/temp_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 drop temporary 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 temporary table test.no_index_tab
14 ( a varchar(255) not null, b int not null) engine = MyISAM;
15 insert into marker set a = 1;
16 show create table test.no_index_tab;
17 Table Create Table
18 no_index_tab CREATE TEMPORARY TABLE `no_index_tab` (
19 `a` varchar(255) NOT NULL,
20 `b` int NOT NULL
21 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
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;
30 a b
31 foo 1
32 foo 2
33 foo 3
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;
38 a b
39 bar 1
40 bar 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;
45 a b
46 bar 1
47 bar 2
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 status OK
52 insert into marker set a = 1;
53 select * from test.no_index_tab;
54 a b
55 bar 1
56 bar 2
57 insert into marker set a = 1;
58 truncate table test.no_index_tab;
59 insert into marker set a = 1;
60 drop temporary table test.no_index_tab;
61 update performance_schema.setup_consumers set enabled='NO';
62 select event_name,
63 left(source, locate(":", source)) as short_source,
64 object_type, object_schema,
65 if (locate("#sql-", object_name), "#sql-XXXX", object_name)
66 as pretty_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 1
74 wait/io/table/sql/handler handler.cc: TABLE test marker insert 1
75 wait/io/table/sql/handler handler.cc: TABLE test marker insert 1
76 wait/io/table/sql/handler handler.cc: TABLE test marker insert 1
77 wait/io/table/sql/handler handler.cc: TABLE test marker insert 1
78 wait/io/table/sql/handler handler.cc: TABLE test marker insert 1
79 wait/io/table/sql/handler handler.cc: TABLE test marker insert 1
80 wait/io/table/sql/handler handler.cc: TABLE test marker insert 1
81 wait/io/table/sql/handler handler.cc: TABLE test marker insert 1
82 wait/io/table/sql/handler handler.cc: TABLE test marker insert 1
83 wait/io/table/sql/handler handler.cc: TABLE test marker insert 1
84 wait/io/table/sql/handler handler.cc: TABLE test marker insert 1
85 wait/io/table/sql/handler handler.cc: TABLE test marker insert 1
86 wait/io/table/sql/handler handler.cc: TABLE test marker insert 1
87 show global status like 'performance_schema_%_lost';
88 Variable_name Value
89 Performance_schema_accounts_lost 0
90 Performance_schema_cond_classes_lost 0
91 Performance_schema_cond_instances_lost 0
92 Performance_schema_digest_lost 0
93 Performance_schema_file_classes_lost 0
94 Performance_schema_file_handles_lost 0
95 Performance_schema_file_instances_lost 0
96 Performance_schema_hosts_lost 0
97 Performance_schema_index_stat_lost 0
98 Performance_schema_locker_lost 0
99 Performance_schema_memory_classes_lost 0
100 Performance_schema_metadata_lock_lost 0
101 Performance_schema_mutex_classes_lost 0
102 Performance_schema_mutex_instances_lost 0
103 Performance_schema_nested_statement_lost 0
104 Performance_schema_prepared_statements_lost 0
105 Performance_schema_program_lost 0
106 Performance_schema_rwlock_classes_lost 0
107 Performance_schema_rwlock_instances_lost 0
108 Performance_schema_session_connect_attrs_lost 0
109 Performance_schema_socket_classes_lost 0
110 Performance_schema_socket_instances_lost 0
111 Performance_schema_stage_classes_lost 0
112 Performance_schema_statement_classes_lost 0
113 Performance_schema_table_handles_lost 0
114 Performance_schema_table_instances_lost 0
115 Performance_schema_table_lock_stat_lost 0
116 Performance_schema_thread_classes_lost 0
117 Performance_schema_thread_instances_lost 0
118 Performance_schema_users_lost 0
119 truncate performance_schema.events_waits_history_long;
120 flush status;
121 update performance_schema.setup_consumers set enabled='NO';
122 truncate performance_schema.events_waits_history_long;
123 drop table test.marker;
124 flush status;
125 update performance_schema.setup_instruments set enabled='YES';
126 update performance_schema.setup_consumers set enabled='YES';