Debian Codegraph @

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

raw
1 drop table if exists test.t1;
2 create table test.t1 (col1 bigint, col2 varchar(30)) engine = InnoDB;
3 show create table test.t1;
4 Table Create Table
5 t1 CREATE TABLE `t1` (
6 `col1` bigint DEFAULT NULL,
7 `col2` varchar(30) DEFAULT NULL
8 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
9 insert into test.t1 values(1,'One');
10 drop table if exists test.marker;
11 create table test.marker(a int);
12 update performance_schema.setup_consumers set enabled='NO';
13 update performance_schema.setup_instruments set enabled='NO';
14 update performance_schema.setup_instruments set enabled='YES'
15 where name like "wait/io/table/%";
16 truncate table performance_schema.events_waits_history_long;
17 flush status;
18 flush tables;
19 update performance_schema.setup_consumers set enabled = 'YES';
20 set autocommit = off;
21 delete from test.t1 where col1 = 1;
22 insert into marker set a = 1;
23 rollback;
24 insert into marker set a = 1;
25 update test.t1 set col2 = 'Updated' where col1 = 1;
26 insert into marker set a = 1;
27 rollback;
28 insert into marker set a = 1;
29 insert into test.t1 values(2,'Two');
30 insert into marker set a = 1;
31 rollback;
32 update performance_schema.setup_consumers set enabled='NO';
33 select event_name,
34 left(source, locate(":", source)) as short_source,
35 object_type, object_schema,
36 if (locate("#sql-", object_name), "#sql-XXXX", object_name)
37 as pretty_name,
38 operation, number_of_bytes
39 from performance_schema.events_waits_history_long
40 where event_name like 'wait/io/table/%'
41 and object_schema in ('test')
42 order by thread_id, event_id;
43 event_name short_source object_type object_schema pretty_name operation number_of_bytes
44 wait/io/table/sql/handler handler.cc: TABLE test t1 fetch 1
45 wait/io/table/sql/handler handler.cc: TABLE test t1 delete 1
46 wait/io/table/sql/handler handler.cc: TABLE test t1 fetch 1
47 wait/io/table/sql/handler handler.cc: TABLE test marker insert 1
48 wait/io/table/sql/handler handler.cc: TABLE test marker insert 1
49 wait/io/table/sql/handler handler.cc: TABLE test t1 fetch 1
50 wait/io/table/sql/handler handler.cc: TABLE test t1 update 1
51 wait/io/table/sql/handler handler.cc: TABLE test t1 fetch 1
52 wait/io/table/sql/handler handler.cc: TABLE test marker insert 1
53 wait/io/table/sql/handler handler.cc: TABLE test marker insert 1
54 wait/io/table/sql/handler handler.cc: TABLE test t1 insert 1
55 wait/io/table/sql/handler handler.cc: TABLE test marker insert 1
56 show global status like 'performance_schema_%_lost';
57 Variable_name Value
58 Performance_schema_accounts_lost 0
59 Performance_schema_cond_classes_lost 0
60 Performance_schema_cond_instances_lost 0
61 Performance_schema_digest_lost 0
62 Performance_schema_file_classes_lost 0
63 Performance_schema_file_handles_lost 0
64 Performance_schema_file_instances_lost 0
65 Performance_schema_hosts_lost 0
66 Performance_schema_index_stat_lost 0
67 Performance_schema_locker_lost 0
68 Performance_schema_memory_classes_lost 0
69 Performance_schema_metadata_lock_lost 0
70 Performance_schema_mutex_classes_lost 0
71 Performance_schema_mutex_instances_lost 0
72 Performance_schema_nested_statement_lost 0
73 Performance_schema_prepared_statements_lost 0
74 Performance_schema_program_lost 0
75 Performance_schema_rwlock_classes_lost 0
76 Performance_schema_rwlock_instances_lost 0
77 Performance_schema_session_connect_attrs_lost 0
78 Performance_schema_socket_classes_lost 0
79 Performance_schema_socket_instances_lost 0
80 Performance_schema_stage_classes_lost 0
81 Performance_schema_statement_classes_lost 0
82 Performance_schema_table_handles_lost 0
83 Performance_schema_table_instances_lost 0
84 Performance_schema_table_lock_stat_lost 0
85 Performance_schema_thread_classes_lost 0
86 Performance_schema_thread_instances_lost 0
87 Performance_schema_users_lost 0
88 truncate performance_schema.events_waits_history_long;
89 flush status;
90 drop table test.t1;
91 update performance_schema.setup_consumers set enabled='NO';
92 truncate performance_schema.events_waits_history_long;
93 drop table test.marker;
94 flush status;
95 update performance_schema.setup_instruments set enabled='YES';
96 update performance_schema.setup_consumers set enabled='YES';