diff options
| author | Thirunarayanan Balathandayuthapani <thiru@mariadb.com> | 2018-03-23 13:27:33 +0530 |
|---|---|---|
| committer | Thirunarayanan Balathandayuthapani <thiru@mariadb.com> | 2018-03-23 13:27:33 +0530 |
| commit | 7003067a09979429ce5b9456aa98283652714657 (patch) | |
| tree | 6737f0dced28727740adb42a249096ad15f80d74 | |
| parent | f249d8467ae7fadafc7c52234c403eec3bb769ca (diff) | |
| download | mariadb-git-7003067a09979429ce5b9456aa98283652714657.tar.gz | |
- Fixing innodb.purge_secondary test case.
| -rw-r--r-- | mysql-test/suite/innodb/r/purge_secondary.result | 11 | ||||
| -rw-r--r-- | mysql-test/suite/innodb/t/purge_secondary.test | 9 |
2 files changed, 9 insertions, 11 deletions
diff --git a/mysql-test/suite/innodb/r/purge_secondary.result b/mysql-test/suite/innodb/r/purge_secondary.result index 67f06194119..a83e2363a20 100644 --- a/mysql-test/suite/innodb/r/purge_secondary.result +++ b/mysql-test/suite/innodb/r/purge_secondary.result @@ -146,12 +146,7 @@ INSERT INTO t1 (a) SELECT NULL FROM t1; INSERT INTO t1 (a) SELECT NULL FROM t1; INSERT INTO t1 (a) SELECT NULL FROM t1; INSERT INTO t1 (a) SELECT NULL FROM t1; -INSERT INTO t1 (a) SELECT NULL FROM t1; -INSERT INTO t1 (a) SELECT NULL FROM t1; -SELECT NAME, SUBSYSTEM FROM INFORMATION_SCHEMA.INNODB_METRICS -WHERE NAME="buffer_LRU_batch_evict_total_pages" AND COUNT > 0; -NAME SUBSYSTEM -buffer_LRU_batch_evict_total_pages buffer +UPDATE t1 SET c=true, l=ST_linefromtext('linestring(0 0,1 1,2 2)'); SELECT NAME, SUBSYSTEM FROM INFORMATION_SCHEMA.INNODB_METRICS WHERE NAME="buffer_LRU_batch_flush_total_pages" AND COUNT > 0; NAME SUBSYSTEM @@ -160,6 +155,10 @@ SELECT (variable_value > 0) FROM information_schema.global_status WHERE LOWER(variable_name) LIKE 'INNODB_BUFFER_POOL_PAGES_FLUSHED'; (variable_value > 0) 1 +SELECT NAME, SUBSYSTEM FROM INFORMATION_SCHEMA.INNODB_METRICS +WHERE NAME="buffer_LRU_batch_evict_total_pages" AND COUNT > 0; +NAME SUBSYSTEM +buffer_LRU_batch_evict_total_pages buffer # Note: The OTHER_INDEX_SIZE does not cover any SPATIAL INDEX. # To test that all indexes were emptied, replace DROP TABLE # with the following, and examine the root pages in t1.ibd: diff --git a/mysql-test/suite/innodb/t/purge_secondary.test b/mysql-test/suite/innodb/t/purge_secondary.test index ce2f48e0d40..973c7800162 100644 --- a/mysql-test/suite/innodb/t/purge_secondary.test +++ b/mysql-test/suite/innodb/t/purge_secondary.test @@ -129,11 +129,7 @@ INSERT INTO t1 (a) SELECT NULL FROM t1; INSERT INTO t1 (a) SELECT NULL FROM t1; INSERT INTO t1 (a) SELECT NULL FROM t1; INSERT INTO t1 (a) SELECT NULL FROM t1; -INSERT INTO t1 (a) SELECT NULL FROM t1; -INSERT INTO t1 (a) SELECT NULL FROM t1; - -SELECT NAME, SUBSYSTEM FROM INFORMATION_SCHEMA.INNODB_METRICS -WHERE NAME="buffer_LRU_batch_evict_total_pages" AND COUNT > 0; +UPDATE t1 SET c=true, l=ST_linefromtext('linestring(0 0,1 1,2 2)'); SELECT NAME, SUBSYSTEM FROM INFORMATION_SCHEMA.INNODB_METRICS WHERE NAME="buffer_LRU_batch_flush_total_pages" AND COUNT > 0; @@ -141,6 +137,9 @@ WHERE NAME="buffer_LRU_batch_flush_total_pages" AND COUNT > 0; SELECT (variable_value > 0) FROM information_schema.global_status WHERE LOWER(variable_name) LIKE 'INNODB_BUFFER_POOL_PAGES_FLUSHED'; +SELECT NAME, SUBSYSTEM FROM INFORMATION_SCHEMA.INNODB_METRICS +WHERE NAME="buffer_LRU_batch_evict_total_pages" AND COUNT > 0; + --echo # Note: The OTHER_INDEX_SIZE does not cover any SPATIAL INDEX. --echo # To test that all indexes were emptied, replace DROP TABLE --echo # with the following, and examine the root pages in t1.ibd: |