diff options
Diffstat (limited to 'mysql-test/suite/perfschema/t/start_server_no_table_hdl.test')
-rw-r--r-- | mysql-test/suite/perfschema/t/start_server_no_table_hdl.test | 30 |
1 files changed, 30 insertions, 0 deletions
diff --git a/mysql-test/suite/perfschema/t/start_server_no_table_hdl.test b/mysql-test/suite/perfschema/t/start_server_no_table_hdl.test new file mode 100644 index 00000000000..80553f11866 --- /dev/null +++ b/mysql-test/suite/perfschema/t/start_server_no_table_hdl.test @@ -0,0 +1,30 @@ +# Tests for PERFORMANCE_SCHEMA + +--source include/not_embedded.inc +--source include/have_perfschema.inc + +--source ../include/start_server_common.inc + +# Expect instances +show variables like "performance_schema_max_table_instances"; + +# Expect no handles +show variables like "performance_schema_max_table_handles"; + +# Create an instrumented table +--disable_warnings +drop table if exists test.instrument_me; +--enable_warnings + +create table test.instrument_me(a int); +insert into test.instrument_me values (1), (2), (3); +select * from test.instrument_me; +drop table test.instrument_me; + +# Expect no instances lost +show variables like "performance_schema_max_table_instances"; + +# We lost all the handles +select variable_value > 0 from information_schema.global_status + where variable_name like 'PERFORMANCE_SCHEMA_TABLE_HANDLES_LOST'; + |