Debian Codegraph @

mysql-test/suite/perfschema/t/start_server_no_table_inst.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 no instances
9 show global variables like "performance_schema_max_table_instances";
10
11 # Expect 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 # We lost all the instances
25 --disable_warnings
26 select variable_value > 0 from information_schema.global_status
27 where variable_name like 'PERFORMANCE_SCHEMA_TABLE_INSTANCES_LOST';
28 --enable_warnings
29
30 # Expect no handle lost
31 show global status like "performance_schema_table_handles_lost";
32