1include/master-slave.inc 2[connection master] 3connection master; 4select variable_value into @master_rows_read from information_schema.global_status where variable_name = 'innodb_rows_read'; 5select variable_value into @master_rows_updated from information_schema.global_status where variable_name = 'innodb_rows_updated'; 6select variable_value into @master_rows_deleted from information_schema.global_status where variable_name = 'innodb_rows_deleted'; 7select variable_value into @master_rows_inserted from information_schema.global_status where variable_name = 'innodb_rows_inserted'; 8select variable_value into @master_system_rows_read from information_schema.global_status where variable_name = 'innodb_system_rows_read'; 9select variable_value into @master_system_rows_updated from information_schema.global_status where variable_name = 'innodb_system_rows_updated'; 10select variable_value into @master_system_rows_deleted from information_schema.global_status where variable_name = 'innodb_system_rows_deleted'; 11select variable_value into @master_system_rows_inserted from information_schema.global_status where variable_name = 'innodb_system_rows_inserted'; 12connection slave; 13select variable_value into @slave_rows_read from information_schema.global_status where variable_name = 'innodb_rows_read'; 14select variable_value into @slave_rows_updated from information_schema.global_status where variable_name = 'innodb_rows_updated'; 15select variable_value into @slave_rows_deleted from information_schema.global_status where variable_name = 'innodb_rows_deleted'; 16select variable_value into @slave_rows_inserted from information_schema.global_status where variable_name = 'innodb_rows_inserted'; 17select variable_value into @slave_system_rows_read from information_schema.global_status where variable_name = 'innodb_system_rows_read'; 18select variable_value into @slave_system_rows_updated from information_schema.global_status where variable_name = 'innodb_system_rows_updated'; 19select variable_value into @slave_system_rows_deleted from information_schema.global_status where variable_name = 'innodb_system_rows_deleted'; 20select variable_value into @slave_system_rows_inserted from information_schema.global_status where variable_name = 'innodb_system_rows_inserted'; 21connection master; 22CREATE DATABASE testdb; 23USE testdb; 24CREATE TABLE testdb.t1 (i int NOT NULL PRIMARY KEY) ENGINE=InnoDB; 25INSERT INTO testdb.t1 VALUES (1); 26connection master; 27select variable_value into @rows_read from information_schema.global_status where variable_name = 'innodb_rows_read'; 28select @rows_read - @master_rows_read; 29@rows_read - @master_rows_read 300 31select variable_value into @rows_updated from information_schema.global_status where variable_name = 'innodb_rows_updated'; 32select @rows_updated - @master_rows_updated; 33@rows_updated - @master_rows_updated 340 35select variable_value into @rows_deleted from information_schema.global_status where variable_name = 'innodb_rows_deleted'; 36select @rows_deleted - @master_rows_deleted; 37@rows_deleted - @master_rows_deleted 380 39select variable_value into @rows_inserted from information_schema.global_status where variable_name = 'innodb_rows_inserted'; 40select @rows_inserted - @master_rows_inserted; 41@rows_inserted - @master_rows_inserted 421 43select variable_value into @system_rows_read from information_schema.global_status where variable_name = 'innodb_system_rows_read'; 44select @system_rows_read - @master_system_rows_read; 45@system_rows_read - @master_system_rows_read 460 47select variable_value into @system_rows_updated from information_schema.global_status where variable_name = 'innodb_system_rows_updated'; 48select @system_rows_updated - @master_system_rows_updated; 49@system_rows_updated - @master_system_rows_updated 500 51select variable_value into @system_rows_deleted from information_schema.global_status where variable_name = 'innodb_system_rows_deleted'; 52select @system_rows_deleted - @master_system_rows_deleted; 53@system_rows_deleted - @master_system_rows_deleted 540 55select variable_value into @system_rows_inserted from information_schema.global_status where variable_name = 'innodb_system_rows_inserted'; 56select @system_rows_inserted - @master_system_rows_inserted; 57@system_rows_inserted - @master_system_rows_inserted 580 59connection slave; 60select variable_value into @rows_read from information_schema.global_status where variable_name = 'innodb_rows_read'; 61select @rows_read - @slave_rows_read; 62@rows_read - @slave_rows_read 630 64select variable_value into @rows_updated from information_schema.global_status where variable_name = 'innodb_rows_updated'; 65select @rows_updated - @slave_rows_updated; 66@rows_updated - @slave_rows_updated 670 68select variable_value into @rows_deleted from information_schema.global_status where variable_name = 'innodb_rows_deleted'; 69select @rows_deleted - @slave_rows_deleted; 70@rows_deleted - @slave_rows_deleted 710 72select variable_value into @rows_inserted from information_schema.global_status where variable_name = 'innodb_rows_inserted'; 73select @rows_inserted - @slave_rows_inserted; 74@rows_inserted - @slave_rows_inserted 751 76select variable_value into @system_rows_read from information_schema.global_status where variable_name = 'innodb_system_rows_read'; 77select @system_rows_read - @slave_system_rows_read; 78@system_rows_read - @slave_system_rows_read 790 80select variable_value into @system_rows_updated from information_schema.global_status where variable_name = 'innodb_system_rows_updated'; 81select @system_rows_updated - @slave_system_rows_updated; 82@system_rows_updated - @slave_system_rows_updated 830 84select variable_value into @system_rows_deleted from information_schema.global_status where variable_name = 'innodb_system_rows_deleted'; 85select @system_rows_deleted - @slave_system_rows_deleted; 86@system_rows_deleted - @slave_system_rows_deleted 870 88select variable_value into @system_rows_inserted from information_schema.global_status where variable_name = 'innodb_system_rows_inserted'; 89select @system_rows_inserted - @slave_system_rows_inserted; 90@system_rows_inserted - @slave_system_rows_inserted 910 92connection master; 93UPDATE t1 SET i=2 WHERE i=1; 94connection slave; 95connection master; 96select variable_value into @rows_read from information_schema.global_status where variable_name = 'innodb_rows_read'; 97select @rows_read - @master_rows_read; 98@rows_read - @master_rows_read 991 100select variable_value into @rows_updated from information_schema.global_status where variable_name = 'innodb_rows_updated'; 101select @rows_updated - @master_rows_updated; 102@rows_updated - @master_rows_updated 1031 104select variable_value into @rows_deleted from information_schema.global_status where variable_name = 'innodb_rows_deleted'; 105select @rows_deleted - @master_rows_deleted; 106@rows_deleted - @master_rows_deleted 1070 108select variable_value into @rows_inserted from information_schema.global_status where variable_name = 'innodb_rows_inserted'; 109select @rows_inserted - @master_rows_inserted; 110@rows_inserted - @master_rows_inserted 1111 112select variable_value into @system_rows_read from information_schema.global_status where variable_name = 'innodb_system_rows_read'; 113select @system_rows_read - @master_system_rows_read; 114@system_rows_read - @master_system_rows_read 1150 116select variable_value into @system_rows_updated from information_schema.global_status where variable_name = 'innodb_system_rows_updated'; 117select @system_rows_updated - @master_system_rows_updated; 118@system_rows_updated - @master_system_rows_updated 1190 120select variable_value into @system_rows_deleted from information_schema.global_status where variable_name = 'innodb_system_rows_deleted'; 121select @system_rows_deleted - @master_system_rows_deleted; 122@system_rows_deleted - @master_system_rows_deleted 1230 124select variable_value into @system_rows_inserted from information_schema.global_status where variable_name = 'innodb_system_rows_inserted'; 125select @system_rows_inserted - @master_system_rows_inserted; 126@system_rows_inserted - @master_system_rows_inserted 1270 128connection slave; 129select variable_value into @rows_read from information_schema.global_status where variable_name = 'innodb_rows_read'; 130select @rows_read - @slave_rows_read; 131@rows_read - @slave_rows_read 1321 133select variable_value into @rows_updated from information_schema.global_status where variable_name = 'innodb_rows_updated'; 134select @rows_updated - @slave_rows_updated; 135@rows_updated - @slave_rows_updated 1361 137select variable_value into @rows_deleted from information_schema.global_status where variable_name = 'innodb_rows_deleted'; 138select @rows_deleted - @slave_rows_deleted; 139@rows_deleted - @slave_rows_deleted 1400 141select variable_value into @rows_inserted from information_schema.global_status where variable_name = 'innodb_rows_inserted'; 142select @rows_inserted - @slave_rows_inserted; 143@rows_inserted - @slave_rows_inserted 1441 145select variable_value into @system_rows_read from information_schema.global_status where variable_name = 'innodb_system_rows_read'; 146select @system_rows_read - @slave_system_rows_read; 147@system_rows_read - @slave_system_rows_read 1480 149select variable_value into @system_rows_updated from information_schema.global_status where variable_name = 'innodb_system_rows_updated'; 150select @system_rows_updated - @slave_system_rows_updated; 151@system_rows_updated - @slave_system_rows_updated 1520 153select variable_value into @system_rows_deleted from information_schema.global_status where variable_name = 'innodb_system_rows_deleted'; 154select @system_rows_deleted - @slave_system_rows_deleted; 155@system_rows_deleted - @slave_system_rows_deleted 1560 157select variable_value into @system_rows_inserted from information_schema.global_status where variable_name = 'innodb_system_rows_inserted'; 158select @system_rows_inserted - @slave_system_rows_inserted; 159@system_rows_inserted - @slave_system_rows_inserted 1600 161connection master; 162DELETE FROM t1 WHERE i=2; 163connection master; 164select variable_value into @rows_read from information_schema.global_status where variable_name = 'innodb_rows_read'; 165select @rows_read - @master_rows_read; 166@rows_read - @master_rows_read 1672 168select variable_value into @rows_updated from information_schema.global_status where variable_name = 'innodb_rows_updated'; 169select @rows_updated - @master_rows_updated; 170@rows_updated - @master_rows_updated 1711 172select variable_value into @rows_deleted from information_schema.global_status where variable_name = 'innodb_rows_deleted'; 173select @rows_deleted - @master_rows_deleted; 174@rows_deleted - @master_rows_deleted 1751 176select variable_value into @rows_inserted from information_schema.global_status where variable_name = 'innodb_rows_inserted'; 177select @rows_inserted - @master_rows_inserted; 178@rows_inserted - @master_rows_inserted 1791 180select variable_value into @system_rows_read from information_schema.global_status where variable_name = 'innodb_system_rows_read'; 181select @system_rows_read - @master_system_rows_read; 182@system_rows_read - @master_system_rows_read 1830 184select variable_value into @system_rows_updated from information_schema.global_status where variable_name = 'innodb_system_rows_updated'; 185select @system_rows_updated - @master_system_rows_updated; 186@system_rows_updated - @master_system_rows_updated 1870 188select variable_value into @system_rows_deleted from information_schema.global_status where variable_name = 'innodb_system_rows_deleted'; 189select @system_rows_deleted - @master_system_rows_deleted; 190@system_rows_deleted - @master_system_rows_deleted 1910 192select variable_value into @system_rows_inserted from information_schema.global_status where variable_name = 'innodb_system_rows_inserted'; 193select @system_rows_inserted - @master_system_rows_inserted; 194@system_rows_inserted - @master_system_rows_inserted 1950 196connection slave; 197select variable_value into @rows_read from information_schema.global_status where variable_name = 'innodb_rows_read'; 198select @rows_read - @slave_rows_read; 199@rows_read - @slave_rows_read 2002 201select variable_value into @rows_updated from information_schema.global_status where variable_name = 'innodb_rows_updated'; 202select @rows_updated - @slave_rows_updated; 203@rows_updated - @slave_rows_updated 2041 205select variable_value into @rows_deleted from information_schema.global_status where variable_name = 'innodb_rows_deleted'; 206select @rows_deleted - @slave_rows_deleted; 207@rows_deleted - @slave_rows_deleted 2081 209select variable_value into @rows_inserted from information_schema.global_status where variable_name = 'innodb_rows_inserted'; 210select @rows_inserted - @slave_rows_inserted; 211@rows_inserted - @slave_rows_inserted 2121 213select variable_value into @system_rows_read from information_schema.global_status where variable_name = 'innodb_system_rows_read'; 214select @system_rows_read - @slave_system_rows_read; 215@system_rows_read - @slave_system_rows_read 2160 217select variable_value into @system_rows_updated from information_schema.global_status where variable_name = 'innodb_system_rows_updated'; 218select @system_rows_updated - @slave_system_rows_updated; 219@system_rows_updated - @slave_system_rows_updated 2200 221select variable_value into @system_rows_deleted from information_schema.global_status where variable_name = 'innodb_system_rows_deleted'; 222select @system_rows_deleted - @slave_system_rows_deleted; 223@system_rows_deleted - @slave_system_rows_deleted 2240 225select variable_value into @system_rows_inserted from information_schema.global_status where variable_name = 'innodb_system_rows_inserted'; 226select @system_rows_inserted - @slave_system_rows_inserted; 227@system_rows_inserted - @slave_system_rows_inserted 2280 229connection master; 230DROP TABLE t1; 231DROP DATABASE testdb; 232connection slave; 233include/rpl_end.inc 234