diff options
author | Monty <monty@mariadb.org> | 2020-03-13 15:28:42 +0200 |
---|---|---|
committer | Monty <monty@mariadb.org> | 2020-03-17 02:16:48 +0200 |
commit | 1242eb3d32f2863f847aa96a10e2ab983a1a643b (patch) | |
tree | b7e28488f2f6fa75a6a83e3b18c95ef8b53b4e8c /mysql-test/main/opt_trace.result | |
parent | 96b472c0ae798da43ca9f4735dfafe35b2f38fda (diff) | |
download | mariadb-git-1242eb3d32f2863f847aa96a10e2ab983a1a643b.tar.gz |
Removed double records_in_range calls from multi_range_read_info_const
This was to remove a performance regression between 10.3 and 10.4
In 10.5 we will have a better implementation of records_in_range
that will enable us to get more statistics.
This change was not done in 10.4 because the 10.5 will be part of
a larger change that is not suitable for the GA 10.4 version
Other things:
- Changed default handler block_size to 8192 to fix things statistics
for engines that doesn't set the block size.
- Fixed a bug in spider when using multiple part const ranges
(Patch from Kentoku)
Diffstat (limited to 'mysql-test/main/opt_trace.result')
-rw-r--r-- | mysql-test/main/opt_trace.result | 12 |
1 files changed, 6 insertions, 6 deletions
diff --git a/mysql-test/main/opt_trace.result b/mysql-test/main/opt_trace.result index 72cee2a428f..110ce60edfd 100644 --- a/mysql-test/main/opt_trace.result +++ b/mysql-test/main/opt_trace.result @@ -2044,7 +2044,7 @@ explain select * from t1 where a=1 and b=2 order by c limit 1 { "using_mrr": false, "index_only": false, "rows": 180, - "cost": 231.72, + "cost": 229.72, "chosen": true }, { @@ -2226,7 +2226,7 @@ explain select * from t1 where a=1 and b=2 order by c limit 1 { "using_mrr": false, "index_only": false, "rows": 180, - "cost": 231.72, + "cost": 229.72, "chosen": true } ], @@ -2243,7 +2243,7 @@ explain select * from t1 where a=1 and b=2 order by c limit 1 { "ranges": ["(1) <= (a) <= (1)"] }, "rows_for_plan": 180, - "cost_for_plan": 231.72, + "cost_for_plan": 229.72, "chosen": true } } @@ -7568,7 +7568,7 @@ JSON_DETAILED(JSON_EXTRACT(trace, '$**.analyzing_range_alternatives')) "using_mrr": false, "index_only": true, "rows": 107, - "cost": 10.955, + "cost": 8.9549, "chosen": true } ], @@ -7605,7 +7605,7 @@ JSON_DETAILED(JSON_EXTRACT(trace, '$**.analyzing_range_alternatives')) "using_mrr": false, "index_only": false, "rows": 1000, - "cost": 1282.2, + "cost": 1273.2, "chosen": true } ], @@ -8009,7 +8009,7 @@ JSON_DETAILED(JSON_EXTRACT(trace, '$**.analyzing_range_alternatives')) "using_mrr": false, "index_only": false, "rows": 1000, - "cost": 1282.2, + "cost": 1273.2, "chosen": true } ], |