| 1 |
# Kill the server |
| 2 |
ib_logfile0 |
| 3 |
ib_logfile1 |
| 4 |
# restart: --datadir=MYSQLD_DATADIR1 --log-error=MYSQLD_DATADIR1/mysqld.err --log-error-verbosity=3 --lower-case-table-names=1 |
| 5 |
SELECT * FROM test.t; |
| 6 |
id |
| 7 |
42 |
| 8 |
SET GLOBAL innodb_monitor_enable = module_log; |
| 9 |
SELECT 0x0125822f <= `COUNT` FROM INFORMATION_SCHEMA.INNODB_METRICS WHERE NAME = 'log_lsn_last_checkpoint'; |
| 10 |
0x0125822f <= `COUNT` |
| 11 |
1 |
| 12 |
SELECT 0x0125822f <= `COUNT` FROM INFORMATION_SCHEMA.INNODB_METRICS WHERE NAME = 'log_lsn_current'; |
| 13 |
0x0125822f <= `COUNT` |
| 14 |
1 |
| 15 |
SELECT * FROM performance_schema.global_status WHERE variable_name = 'Innodb_redo_log_enabled'; |
| 16 |
VARIABLE_NAME VARIABLE_VALUE |
| 17 |
Innodb_redo_log_enabled ON |
| 18 |
# Kill the server |
| 19 |
# Expect found |
| 20 |
Pattern "MY-013888\b.*\bLSN=19235375" found |
| 21 |
# restart: |