~ubuntu-branches/ubuntu/trusty/mysql-5.6/trusty

« back to all changes in this revision

Viewing changes to mysql-test/suite/perfschema/include/hostcache_set_state.inc

  • Committer: Package Import Robot
  • Author(s): James Page
  • Date: 2014-02-12 11:54:27 UTC
  • Revision ID: package-import@ubuntu.com-20140212115427-oq6tfsqxl1wuwehi
Tags: upstream-5.6.15
ImportĀ upstreamĀ versionĀ 5.6.15

Show diffs side-by-side

added added

removed removed

Lines of Context:
 
1
# Helper for hostcache_*.test
 
2
 
 
3
# Set a known initial state for the test
 
4
 
 
5
flush status;
 
6
flush hosts;
 
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