diff options
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 + |