Debian Codegraph @

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

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