← Back to branch summary

~percona-dev/percona-server/release-5.1.52-11-fix-oleg-bug-for-11.6

« back to all changes in this revision

Viewing changes to mysql-test/percona_slave_innodb_stats.test

  • Committer: Oleg Tsarev
  • Date: 2010-11-18 13:06:12 UTC
  • Revision ID: oleg.tsarev@percona.com-20101118130612-barde92d4c3qd433
update patches, remove deprecated tests

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/percona_slave_innodb_stats.test
1
 
source include/have_innodb.inc;
2
 
source include/master-slave.inc;
3
 
 
4
 
connection master;
5
 
DROP TABLE IF EXISTS t;
6
 
CREATE TABLE t(id INT,data CHAR(30)) ENGINE=InnoDB;
7
 
INSERT INTO t VALUES
8
 
(1,"aaaaabbbbbcccccdddddeeeeefffff"),
9
 
(2,"aaaaabbbbbcccccdddddeeeeefffff"),
10
 
(3,"aaaaabbbbbcccccdddddeeeeefffff"),
11
 
(4,"aaaaabbbbbcccccdddddeeeeefffff"),
12
 
(5,"aaaaabbbbbcccccdddddeeeeefffff");
13
 
INSERT INTO t SELECT t2.id,t2.data from t as t1, t as t2;
14
 
INSERT INTO t SELECT t2.id,t2.data from t as t1, t as t2;
15
 
sync_slave_with_master;
16
 
 
17
 
connection slave;
18
 
STOP SLAVE;
19
 
--write_file $MYSQLTEST_VARDIR/tmp/mysqld.2.expect
20
 
wait
21
 
EOF
22
 
--shutdown_server 10
23
 
--source include/wait_until_disconnected.inc
24
 
--append_file $MYSQLTEST_VARDIR/tmp/mysqld.2.expect
25
 
restart
26
 
EOF
27
 
--enable_reconnect
28
 
--source include/wait_until_connected_again.inc
29
 
START SLAVE;
30
 
 
31
 
connection master;
32
 
INSERT INTO t SELECT t.id,t.data from t;
33
 
sync_slave_with_master;
34
 
 
35
 
connection master;
36
 
DROP TABLE IF EXISTS t;
37
 
sync_slave_with_master;
38
 
 
39
 
exec cat var/mysqld.2/mysqld-slow.log | grep InnoDB_IO_r_ops | wc -l;