summaryrefslogtreecommitdiff
path: root/mysql-test/suite/perfschema/include/hostcache_set_state.inc
blob: 25dd56a4e0d7f30bea995b41b46bbba045767086 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
# Helper for hostcache_*.test

# Set a known initial state for the test

flush status;
flush hosts;
flush user_resources;
flush privileges;

# Print critical setup

select @@global.debug;
select @@global.max_connect_errors;
select @@global.max_user_connections;
select @@global.max_connections;

# Make sure there are no remaining records that can change the test outcome

select `User`, `Host` from mysql.`user` where `host` like '%\\%%';
select `User`, `Host` from mysql.`user` where `user` like '192.%';
select `User`, `Host` from mysql.`user` where `user` like '2001:%';
select `User`, `Host` from mysql.`user` where `user` like 'santa.claus.%';