← Back to branch summary

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

« back to all changes in this revision

Viewing changes to mysql-test/suite/sys_vars/t/innodb_buffer_pool_load_now_basic.test

  • 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:
mysql-test/suite/sys_vars/t/innodb_buffer_pool_load_now_basic.test
 
1
#
 
2
# Basic test for innodb_buffer_pool_load_now
 
3
#
 
4
 
 
5
-- source include/have_innodb.inc
 
6
 
 
7
# Check the default value
 
8
SET @orig = @@global.innodb_buffer_pool_load_now;
 
9
SELECT @orig;
 
10
 
 
11
# Do the dump
 
12
SET GLOBAL innodb_buffer_pool_dump_now = ON;
 
13
 
 
14
# Wait for the dump to complete
 
15
let $wait_condition =
 
16
  SELECT SUBSTR(variable_value, 1, 33) = 'Buffer pool(s) dump completed at '
 
17
  FROM information_schema.global_status
 
18
  WHERE LOWER(variable_name) = 'innodb_buffer_pool_dump_status';
 
19
-- source include/wait_condition.inc
 
20
 
 
21
# Confirm the file is really created
 
22
-- let $file = `SELECT CONCAT(@@datadir, @@global.innodb_buffer_pool_filename)`
 
23
-- file_exists $file
 
24
 
 
25
# Load the dump
 
26
SET GLOBAL innodb_buffer_pool_load_now = ON;
 
27
 
 
28
# Wait for the load to complete
 
29
let $wait_condition =
 
30
  SELECT SUBSTR(variable_value, 1, 33) = 'Buffer pool(s) load completed at '
 
31
  FROM information_schema.global_status
 
32
  WHERE LOWER(variable_name) = 'innodb_buffer_pool_load_status';
 
33
-- source include/wait_condition.inc
 
34
 
 
35
# Show the status, interesting if the above timed out
 
36
-- replace_regex /[0-9]{6}[[:space:]]+[0-9]{1,2}:[0-9]{2}:[0-9]{2}/TIMESTAMP_NOW/
 
37
SELECT variable_value
 
38
FROM information_schema.global_status
 
39
WHERE LOWER(variable_name) = 'innodb_buffer_pool_load_status';