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