diff options
author | Varun Gupta <varun.gupta@mariadb.com> | 2019-02-18 17:35:17 +0530 |
---|---|---|
committer | Varun Gupta <varun.gupta@mariadb.com> | 2019-02-19 14:27:24 +0530 |
commit | d6db6df9956da295787b863dbe4d849c50956d02 (patch) | |
tree | 8ba44ae28f2a15a95533325eaf750e708bc9f373 /mysql-test/main/explain_json.result | |
parent | f2f0c2004408a38a428d6c6346a8f2d2d69cd599 (diff) | |
download | mariadb-git-d6db6df9956da295787b863dbe4d849c50956d02.tar.gz |
MDEV-17903: New optimizer defaults: change optimize_join_buffer_size to be ON
optimize_join_buffer_size is switched ON.
Diffstat (limited to 'mysql-test/main/explain_json.result')
-rw-r--r-- | mysql-test/main/explain_json.result | 16 |
1 files changed, 8 insertions, 8 deletions
diff --git a/mysql-test/main/explain_json.result b/mysql-test/main/explain_json.result index 2f60a827cc0..b918e7614af 100644 --- a/mysql-test/main/explain_json.result +++ b/mysql-test/main/explain_json.result @@ -373,7 +373,7 @@ EXPLAIN "attached_condition": "tbl2.b < 5" }, "buffer_type": "flat", - "buffer_size": "256Kb", + "buffer_size": "1Kb", "join_type": "BNL", "attached_condition": "tbl2.a = tbl1.a" } @@ -640,7 +640,7 @@ EXPLAIN "filtered": 100 }, "buffer_type": "flat", - "buffer_size": "256Kb", + "buffer_size": "1Kb", "join_type": "BNL" } } @@ -674,7 +674,7 @@ EXPLAIN "first_match": "t2" }, "buffer_type": "flat", - "buffer_size": "256Kb", + "buffer_size": "141", "join_type": "BNL", "attached_condition": "t1.b = t2.b and t1.a = t2.a" } @@ -711,7 +711,7 @@ EXPLAIN "filtered": 100 }, "buffer_type": "flat", - "buffer_size": "256Kb", + "buffer_size": "206", "join_type": "BNL", "attached_condition": "t1.b = t2.b and t1.a = t2.a" } @@ -825,7 +825,7 @@ EXPLAIN "filtered": 100 }, "buffer_type": "flat", - "buffer_size": "256Kb", + "buffer_size": "65", "join_type": "BNL", "attached_condition": "t2.b <> outer_t1.a" } @@ -876,7 +876,7 @@ EXPLAIN "filtered": 100 }, "buffer_type": "flat", - "buffer_size": "256Kb", + "buffer_size": "1Kb", "join_type": "BNL", "attached_condition": "tbl2.b = tbl1.b" } @@ -1492,7 +1492,7 @@ EXPLAIN "index_condition_bka": "t4.b + 1 <= t3.b + 1" }, "buffer_type": "flat", - "buffer_size": "256Kb", + "buffer_size": "400", "join_type": "BKA", "mrr_type": "Rowid-ordered scan" } @@ -1535,7 +1535,7 @@ ANALYZE "index_condition_bka": "t4.b + 1 <= t3.b + 1" }, "buffer_type": "flat", - "buffer_size": "256Kb", + "buffer_size": "400", "join_type": "BKA", "mrr_type": "Rowid-ordered scan", "r_filtered": 100 |