diff options
author | Daniel Baumann <daniel.baumann@progress-linux.org> | 2024-05-04 18:00:34 +0000 |
---|---|---|
committer | Daniel Baumann <daniel.baumann@progress-linux.org> | 2024-05-04 18:00:34 +0000 |
commit | 3f619478f796eddbba6e39502fe941b285dd97b1 (patch) | |
tree | e2c7b5777f728320e5b5542b6213fd3591ba51e2 /mysql-test/suite/perfschema/t/part_table_io.test | |
parent | Initial commit. (diff) | |
download | mariadb-upstream.tar.xz mariadb-upstream.zip |
Adding upstream version 1:10.11.6.upstream/1%10.11.6upstream
Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>
Diffstat (limited to 'mysql-test/suite/perfschema/t/part_table_io.test')
-rw-r--r-- | mysql-test/suite/perfschema/t/part_table_io.test | 30 |
1 files changed, 30 insertions, 0 deletions
diff --git a/mysql-test/suite/perfschema/t/part_table_io.test b/mysql-test/suite/perfschema/t/part_table_io.test new file mode 100644 index 00000000..0b94d7ca --- /dev/null +++ b/mysql-test/suite/perfschema/t/part_table_io.test @@ -0,0 +1,30 @@ +# Tests for PERFORMANCE_SCHEMA table io + +--source include/have_partition.inc +--source include/not_embedded.inc +--source include/have_perfschema.inc +--source ../include/table_io_setup_helper.inc + +let $engine_type= MyISAM; +let $table_item= test.no_index_tab; +--disable_warnings +eval drop table if exists $table_item; +--enable_warnings + +# Start recording events +update performance_schema.setup_consumers set enabled='YES'; +insert into marker set a = 1; +eval create table $table_item +( a varchar(255) not null, b int not null) engine = $engine_type +PARTITION BY KEY (b) PARTITIONS 2; +insert into marker set a = 1; +eval show create table $table_item; +--source ../include/table_io_basic_dml.inc +eval drop table $table_item; + +# Stop recording events + pull result +--source ../include/table_io_result_helper.inc + +# Cleanup +--source ../include/table_io_cleanup_helper.inc + |