diff options
| author | Igor Babaev <igor@askmonty.org> | 2019-02-14 00:15:48 -0800 |
|---|---|---|
| committer | Igor Babaev <igor@askmonty.org> | 2019-02-14 00:17:20 -0800 |
| commit | e1de23b8d51c53b87a9d54352af0e99d4386e0ee (patch) | |
| tree | dc8e1780b373a37f7a362c539cde520f34453662 /mysql-test/main/key_cache.result | |
| parent | 76c34a74a8a93a0acca8521d20d8299f7a36ee0f (diff) | |
| download | mariadb-git-e1de23b8d51c53b87a9d54352af0e99d4386e0ee.tar.gz | |
MDEV-16188 Introduced the notion of adjusted filter gain.
Due to inconsistent usage of different cost models to calculate
the cost of ref accesses we have to make the calculation of the
gain promising by usage a range filter more complex.
Diffstat (limited to 'mysql-test/main/key_cache.result')
| -rw-r--r-- | mysql-test/main/key_cache.result | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/mysql-test/main/key_cache.result b/mysql-test/main/key_cache.result index e1f8892366c..36c75ad4a5d 100644 --- a/mysql-test/main/key_cache.result +++ b/mysql-test/main/key_cache.result @@ -739,13 +739,13 @@ p 1019 explain select i from t2 where a='yyyy' and i=3; id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t2 ref|filter k1,k2 k1|k2 5|11 const 189 (27%) Using where; Using rowid filter +1 SIMPLE t2 ref k1,k2 k1 5 const 189 Using where select i from t2 where a='yyyy' and i=3; i 3 explain select a from t2 where a='yyyy' and i=3; id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t2 ref|filter k1,k2 k1|k2 5|11 const 189 (27%) Using where; Using rowid filter +1 SIMPLE t2 ref k1,k2 k1 5 const 189 Using where select a from t2 where a='yyyy' and i=3 ; a yyyy @@ -753,7 +753,7 @@ select * from information_schema.key_caches where segment_number is null; KEY_CACHE_NAME SEGMENTS SEGMENT_NUMBER FULL_SIZE BLOCK_SIZE USED_BLOCKS UNUSED_BLOCKS DIRTY_BLOCKS READ_REQUESTS READS WRITE_REQUESTS WRITES default 2 NULL 32768 1024 # # 0 3178 24 1552 18 small NULL NULL 1048576 1024 # # 0 0 0 0 0 -keycache1 7 NULL 262143 2048 # # 0 3283 43 1594 30 +keycache1 7 NULL 262143 2048 # # 0 3231 43 1594 30 keycache2 NULL NULL 1048576 1024 # # 0 6 6 3 3 set global keycache1.key_cache_block_size=2*1024; insert into t2 values (7000, 3, 'yyyy'); |