mirror of
https://github.com/MariaDB/server.git
synced 2025-02-13 17:05:35 +01:00
0633d0e2ed
because FLUSH STATUS does not reset them, so their values are affected by previously run tests since the last server restart.
83 lines
3.4 KiB
Text
83 lines
3.4 KiB
Text
drop table if exists test.t1;
|
|
create table test.t1 (col1 bigint, col2 varchar(30)) engine = InnoDB;
|
|
show create table test.t1;
|
|
Table Create Table
|
|
t1 CREATE TABLE `t1` (
|
|
`col1` bigint(20) DEFAULT NULL,
|
|
`col2` varchar(30) DEFAULT NULL
|
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1
|
|
insert into test.t1 values(1,'One');
|
|
set default_storage_engine=InnoDB;
|
|
drop table if exists test.marker;
|
|
create table test.marker(a int);
|
|
update performance_schema.setup_consumers set enabled='NO';
|
|
update performance_schema.setup_instruments set enabled='NO';
|
|
update performance_schema.setup_instruments set enabled='YES'
|
|
where name like "wait/io/table/%";
|
|
truncate table performance_schema.events_waits_history_long;
|
|
flush status;
|
|
flush tables;
|
|
update performance_schema.setup_consumers set enabled = 'YES';
|
|
set autocommit = off;
|
|
delete from test.t1 where col1 = 1;
|
|
insert into marker set a = 1;
|
|
rollback;
|
|
insert into marker set a = 1;
|
|
update test.t1 set col2 = 'Updated' where col1 = 1;
|
|
insert into marker set a = 1;
|
|
rollback;
|
|
insert into marker set a = 1;
|
|
insert into test.t1 values(2,'Two');
|
|
insert into marker set a = 1;
|
|
rollback;
|
|
update performance_schema.setup_consumers set enabled='NO';
|
|
select event_name,
|
|
left(source, locate(":", source)) as short_source,
|
|
object_type, object_schema,
|
|
if (locate("#sql-", object_name), "#sql-XXXX", object_name)
|
|
as pretty_name,
|
|
operation, number_of_bytes
|
|
from performance_schema.events_waits_history_long
|
|
where event_name like 'wait/io/table/%'
|
|
and object_schema in ('test')
|
|
order by thread_id, event_id;
|
|
event_name short_source object_type object_schema pretty_name operation number_of_bytes
|
|
wait/io/table/sql/handler handler.cc: TABLE test t1 fetch NULL
|
|
wait/io/table/sql/handler handler.cc: TABLE test t1 delete NULL
|
|
wait/io/table/sql/handler handler.cc: TABLE test t1 fetch NULL
|
|
wait/io/table/sql/handler handler.cc: TABLE test marker insert NULL
|
|
wait/io/table/sql/handler handler.cc: TABLE test marker insert NULL
|
|
wait/io/table/sql/handler handler.cc: TABLE test t1 fetch NULL
|
|
wait/io/table/sql/handler handler.cc: TABLE test t1 update NULL
|
|
wait/io/table/sql/handler handler.cc: TABLE test t1 fetch NULL
|
|
wait/io/table/sql/handler handler.cc: TABLE test marker insert NULL
|
|
wait/io/table/sql/handler handler.cc: TABLE test marker insert NULL
|
|
wait/io/table/sql/handler handler.cc: TABLE test t1 insert NULL
|
|
wait/io/table/sql/handler handler.cc: TABLE test marker insert NULL
|
|
show status where Variable_name like 'performance_schema_%' and
|
|
Variable_name not like 'performance_schema_%_classes_lost';
|
|
Variable_name Value
|
|
Performance_schema_accounts_lost 0
|
|
Performance_schema_cond_instances_lost 0
|
|
Performance_schema_digest_lost 0
|
|
Performance_schema_file_handles_lost 0
|
|
Performance_schema_file_instances_lost 0
|
|
Performance_schema_hosts_lost 0
|
|
Performance_schema_locker_lost 0
|
|
Performance_schema_mutex_instances_lost 0
|
|
Performance_schema_rwlock_instances_lost 0
|
|
Performance_schema_session_connect_attrs_lost 0
|
|
Performance_schema_socket_instances_lost 0
|
|
Performance_schema_table_handles_lost 0
|
|
Performance_schema_table_instances_lost 0
|
|
Performance_schema_thread_instances_lost 0
|
|
Performance_schema_users_lost 0
|
|
truncate performance_schema.events_waits_history_long;
|
|
flush status;
|
|
drop table test.t1;
|
|
update performance_schema.setup_consumers set enabled='NO';
|
|
truncate performance_schema.events_waits_history_long;
|
|
drop table test.marker;
|
|
flush status;
|
|
update performance_schema.setup_instruments set enabled='YES';
|
|
update performance_schema.setup_consumers set enabled='YES';
|