Debian Codegraph @

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

raw
1 # Helper for hostcache_*.test
2
3 # Set a known initial state for the test
4
5 flush status;
6 TRUNCATE TABLE performance_schema.host_cache;
7 flush user_resources;
8 flush privileges;
9
10 # Print critical setup
11
12 select @@global.debug;
13 select @@global.max_connect_errors;
14 select @@global.max_user_connections;
15 select @@global.max_connections;
16
17 # Make sure there are no remaining records that can change the test outcome
18
19 select `User`, `Host` from mysql.`user` where `host` like '%\\%%';
20 select `User`, `Host` from mysql.`user` where `user` like '192.%';
21 select `User`, `Host` from mysql.`user` where `user` like '2001:%';
22 select `User`, `Host` from mysql.`user` where `user` like 'santa.claus.%';
23