CREATE TABLE t1 (a INT NOT NULL PRIMARY KEY AUTO_INCREMENT, b VARCHAR(256)) ENGINE=INNODB;

# Populate table.
INSERT INTO t1 VALUES (0, REPEAT('a',256));
INSERT INTO t1 SELECT 0, b FROM t1;
INSERT INTO t1 SELECT 0, b FROM t1;
INSERT INTO t1 SELECT 0, b FROM t1;
INSERT INTO t1 SELECT 0, b FROM t1;
INSERT INTO t1 SELECT 0, b FROM t1;
INSERT INTO t1 SELECT 0, b FROM t1;
INSERT INTO t1 SELECT 0, b FROM t1;
INSERT INTO t1 SELECT 0, b FROM t1;

# Delete records such as that only 5 records are left per page.
DELETE FROM t1 WHERE a >= 369;
DELETE FROM t1 WHERE a BETWEEN 315 AND 363;
DELETE FROM t1 WHERE a BETWEEN 261 AND 309;
DELETE FROM t1 WHERE a BETWEEN 144 AND 255;

CREATE TABLE t11 (a INT NOT NULL PRIMARY KEY AUTO_INCREMENT, b VARCHAR(256)) ENGINE=INNODB;

# Populate table.
INSERT INTO t11 VALUES (0, REPEAT('a',256));
INSERT INTO t11 SELECT 0, b FROM t1;
INSERT INTO t11 SELECT 0, b FROM t1;
INSERT INTO t11 SELECT 0, b FROM t1;
INSERT INTO t11 SELECT 0, b FROM t1;
INSERT INTO t11 SELECT 0, b FROM t1;
INSERT INTO t11 SELECT 0, b FROM t1;
INSERT INTO t11 SELECT 0, b FROM t1;
INSERT INTO t11 SELECT 0, b FROM t1;

# Delete records such as that only 5 records are left per page.
DELETE FROM t11 WHERE a <= 144;
DELETE FROM t11 WHERE a BETWEEN 144 AND 255;
DELETE FROM t11 WHERE a BETWEEN 261 AND 309;
DELETE FROM t11 WHERE a BETWEEN 315 AND 363;


sleep 10;
SELECT TABLE_NAME, PAGE_NUMBER, NUMBER_RECORDS, DATA_SIZE FROM
INFORMATION_SCHEMA.INNODB_BUFFER_PAGE WHERE TABLE_NAME
LIKE '%t1%' ORDER BY TABLE_NAME, PAGE_NUMBER;