1######################################################################## 2# Basic dump innodb buffer test 3######################################################################## 4 5. inc/common.sh 6 7require_server_version_higher_than 5.6.0 8MYSQLD_EXTRA_MY_CNF_OPTS=" 9innodb_buffer_pool_filename=ib_buffer_pool 10" 11if [[ -f $mysql_datadir/ib_buffer_pool ]]; then 12 rm -f $mysql_datadir/ib_buffer_pool 13fi 14start_server 15 16load_sakila 17 18mkdir $topdir/backup 19 20xtrabackup --backup --dump-innodb-buffer-pool --target-dir=$topdir/backup 21 22if [[ ! -f $mysql_datadir/ib_buffer_pool ]]; then 23 die "dump file doesnt exist" 24fi 25 26$MYSQL $MYSQL_ARGS -e \ 27 "SHOW GLOBAL STATUS LIKE 'Innodb_buffer_pool_dump_status';" > $topdir/message 28 29grep -q "dump completed at" $topdir/message \ 30|| die "Could not find \"dump completed at\" message" 31 32cat $mysql_datadir/ib_buffer_pool | wc -l > $topdir/status1 33cat $topdir/backup/ib_buffer_pool | wc -l > $topdir/status2 34 35diff -q $topdir/status1 $topdir/status2 \ 36|| die "Not all pages were dumped" 37