| 1 |
# |
| 2 |
# Prepare the server for redo log archiving. |
| 3 |
# |
| 4 |
SET @@global.innodb_redo_log_archive_dirs = '1:IRLA_DIRECTORY_1;2:IRLA_DIRECTORY_2'; |
| 5 |
|
| 6 |
# |
| 7 |
# Start redo log archiving |
| 8 |
# |
| 9 |
DO innodb_redo_log_archive_start('1'); |
| 10 |
|
| 11 |
# |
| 12 |
# Create a lot of InnoDB redo log. |
| 13 |
# |
| 14 |
DROP DATABASE IF EXISTS db1; |
| 15 |
CREATE DATABASE db1; |
| 16 |
CREATE TABLE db1.t1(id int, b longblob) ENGINE=InnoDB; |
| 17 |
INSERT INTO db1.t1 VALUES(1, repeat(1, 22*1024*1024)); |
| 18 |
DELETE FROM db1.t1; |
| 19 |
INSERT INTO db1.t1 VALUES(1, repeat(1, 22*1024*1024)); |
| 20 |
DELETE FROM db1.t1; |
| 21 |
INSERT INTO db1.t1 VALUES(1, repeat(1, 22*1024*1024)); |
| 22 |
DELETE FROM db1.t1; |
| 23 |
INSERT INTO db1.t1 VALUES(1, repeat(1, 22*1024*1024)); |
| 24 |
DELETE FROM db1.t1; |
| 25 |
INSERT INTO db1.t1 VALUES(1, repeat(1, 22*1024*1024)); |
| 26 |
DELETE FROM db1.t1; |
| 27 |
DROP TABLE db1.t1; |
| 28 |
DROP DATABASE db1; |
| 29 |
|
| 30 |
# |
| 31 |
# Start redo log archiving after failure fails |
| 32 |
# |
| 33 |
DO innodb_redo_log_archive_start('2'); |
| 34 |
ERROR HY000: Redo log archiving has been started on 'IRLA_PATHNAME_1' - Call innodb_redo_log_archive_stop() first |
| 35 |
|
| 36 |
# |
| 37 |
# Stop redo log archiving |
| 38 |
# |
| 39 |
DO innodb_redo_log_archive_stop(); |
| 40 |
ERROR HY000: Redo log archiving failed: Cannot write to file 'IRLA_PATHNAME_1' at offset ### (OS errno: 28 - No space left on device) - stopped redo log archiving and deleted the file. |
| 41 |
|
| 42 |
# |
| 43 |
# Redo log archive file does not exist any more. |
| 44 |
# |
| 45 |
|
| 46 |
# |
| 47 |
# Cleanup |
| 48 |
# |
| 49 |
SET @@global.innodb_redo_log_archive_dirs = ''; |