| 1 |
SET GLOBAL innodb_encrypt_tables=ON,innodb_encryption_threads=1; |
| 2 |
SET GLOBAL innodb_saved_page_number_debug=4,innodb_fil_make_page_dirty_debug=0; |
| 3 |
CREATE TABLE t1(f1 text, index idx(f1(20))) ENGINE INNODB; |
| 4 |
set global innodb_fast_shutdown=0; |
| 5 |
# restart: --debug_dbug=+d,ib_log_checkpoint_avoid_hard --innodb_flush_sync=0 |
| 6 |
set global debug_dbug="+d,ib_log_checkpoint_avoid_hard"; |
| 7 |
INSERT INTO t1 SELECT repeat('a', 8000) FROM seq_1_to_1280; |
| 8 |
DELETE FROM t1; |
| 9 |
SET GLOBAL innodb_max_purge_lag_wait=0; |
| 10 |
INSERT INTO t1 VALUES('a'); |
| 11 |
# XTRABACKUP PREPARE |
| 12 |
# restart |
| 13 |
SELECT COUNT(*) FROM t1; |
| 14 |
COUNT(*) |
| 15 |
1 |
| 16 |
ALTER TABLE t1 FORCE; |
| 17 |
DROP TABLE t1; |