Debian Codegraph @

mysql-test/suite/perfschema/include/binlog_common.inc

raw
1 # Tests for PERFORMANCE_SCHEMA
2
3 RESET MASTER;
4
5 select count(*) > 0 from performance_schema.setup_instruments;
6
7 # Note:
8 # Do not include records that could depend on
9 # compiling options (storage engines, SSL),
10 # to ensure the expected output in the binlog is predictable.
11 update performance_schema.setup_instruments set enabled='NO'
12 where name like "wait/synch/rwlock/sql/%"
13 and name not in ("wait/synch/rwlock/sql/CRYPTO_dynlock_value::lock");
14
15 select count(*) > 0 from performance_schema.events_waits_current;
16
17 --disable_warnings
18 drop table if exists test.t1;
19 drop table if exists test.t2;
20 --enable_warnings
21
22 create table test.t1 (thread_id integer);
23 create table test.t2 (name varchar(128));
24
25 insert into test.t1
26 select thread_id from performance_schema.events_waits_current;
27
28 insert into test.t2
29 select name from performance_schema.setup_instruments
30 where name like "wait/synch/rwlock/sql/%"
31 and name not in ("wait/synch/rwlock/sql/CRYPTO_dynlock_value::lock");
32
33 drop table test.t1;
34 drop table test.t2;
35
36 update performance_schema.setup_instruments set enabled='YES'
37 where name like "wait/synch/rwlock/sql/%"
38 and name not in ("wait/synch/rwlock/sql/CRYPTO_dynlock_value::lock");
39
40 --source include/show_binlog_events.inc
41