Debian Codegraph @

mysql-test/suite/perfschema/t/start_server_no_table_hdl.test

raw
1 # Tests for PERFORMANCE_SCHEMA
2
3 --source include/not_embedded.inc
4 --source include/have_perfschema.inc
5
6 --source ../include/start_server_common.inc
7
8 # Expect instances
9 show global variables like "performance_schema_max_table_instances";
10
11 # Expect no handles
12 show global variables like "performance_schema_max_table_handles";
13
14 # Create an instrumented table
15 --disable_warnings
16 drop table if exists test.instrument_me;
17 --enable_warnings
18
19 create table test.instrument_me(a int);
20 insert into test.instrument_me values (1), (2), (3);
21 select * from test.instrument_me;
22 drop table test.instrument_me;
23
24 # Expect no instances lost
25 show global variables like "performance_schema_max_table_instances";
26
27 # We lost all the handles
28 --disable_warnings
29 select variable_value > 0 from information_schema.global_status
30 where variable_name like 'PERFORMANCE_SCHEMA_TABLE_HANDLES_LOST';
31 --enable_warnings
32