mysql-test/suite/innodb/r/monitor_restart.result
raw| 1 | # |
| 2 | # BUG#20080942 - ADAPTIVE_HASH_SEARCHES_BTREE NOT UPDATED |
| 3 | # |
| 4 | CREATE TABLE t1(a INT PRIMARY KEY, b BLOB) STATS_PERSISTENT=0; |
| 5 | SET GLOBAL innodb_fast_shutdown=0; |
| 6 | # restart |
| 7 | SET GLOBAL innodb_purge_stop_now = ON; |
| 8 | SELECT COUNT(*) FROM t1; |
| 9 | COUNT(*) |
| 10 | 0 |
| 11 | INSERT INTO t1 VALUES(1, 'abc'); |
| 12 | INSERT INTO t1 VALUES(2, 'def'); |
| 13 | INSERT INTO t1 VALUES(3, 'ghi'); |
| 14 | SELECT * FROM t1; |
| 15 | a b |
| 16 | 1 abc |
| 17 | 2 def |
| 18 | 3 ghi |
| 19 | DROP TABLE t1; |
| 20 | SET GLOBAL innodb_purge_run_now = ON; |