← Back to branch summary

~sergei.glushchenko/percona-server/55-tp

« back to all changes in this revision

Viewing changes to mysql-test/slow_extended.patch/percona_slow_extended-slave_innodb_stats.result

  • Committer: Oleg Tsarev
  • Date: 2010-12-09 18:30:58 UTC
  • Revision ID: oleg.tsarev@percona.com-20101209183058-1mq1qrgjjkz3qxof
propogate Oleg's patches

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/slow_extended.patch/percona_slow_extended-slave_innodb_stats.result
 
1
stop slave;
 
2
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
 
3
reset master;
 
4
reset slave;
 
5
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
 
6
start slave;
 
7
DROP TABLE IF EXISTS t;
 
8
CREATE TABLE t(id INT,data CHAR(30)) ENGINE=InnoDB;
 
9
INSERT INTO t VALUES
 
10
(1,"aaaaabbbbbcccccdddddeeeeefffff"),
 
11
(2,"aaaaabbbbbcccccdddddeeeeefffff"),
 
12
(3,"aaaaabbbbbcccccdddddeeeeefffff"),
 
13
(4,"aaaaabbbbbcccccdddddeeeeefffff"),
 
14
(5,"aaaaabbbbbcccccdddddeeeeefffff");
 
15
INSERT INTO t SELECT t2.id,t2.data from t as t1, t as t2;
 
16
INSERT INTO t SELECT t2.id,t2.data from t as t1, t as t2;
 
17
STOP SLAVE;
 
18
START SLAVE;
 
19
INSERT INTO t SELECT t.id,t.data from t;
 
20
DROP TABLE IF EXISTS t;
 
21
4