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/analyze_format_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/analyze_format_json.result')
-rw-r--r-- | mysql-test/main/analyze_format_json.result | 10 |
1 files changed, 5 insertions, 5 deletions
diff --git a/mysql-test/main/analyze_format_json.result b/mysql-test/main/analyze_format_json.result index b98500d4c34..c306c2fc1b3 100644 --- a/mysql-test/main/analyze_format_json.result +++ b/mysql-test/main/analyze_format_json.result @@ -143,7 +143,7 @@ ANALYZE "attached_condition": "tbl2.b < 60" }, "buffer_type": "flat", - "buffer_size": "256Kb", + "buffer_size": "1Kb", "join_type": "BNL", "r_filtered": 100 } @@ -181,7 +181,7 @@ ANALYZE "attached_condition": "tbl2.b < 60" }, "buffer_type": "flat", - "buffer_size": "256Kb", + "buffer_size": "1Kb", "join_type": "BNL", "attached_condition": "tbl1.c > tbl2.c", "r_filtered": 15.833 @@ -625,7 +625,7 @@ ANALYZE "attached_condition": "<in_optimizer>(t2.b,t2.b in (subquery#2))" }, "buffer_type": "flat", - "buffer_size": "256Kb", + "buffer_size": "65", "join_type": "BNL", "attached_condition": "<in_optimizer>(t2.b,t2.b in (subquery#2))", "r_filtered": null @@ -711,7 +711,7 @@ ANALYZE "attached_condition": "t3.f3 in (1,2)" }, "buffer_type": "flat", - "buffer_size": "256Kb", + "buffer_size": "1", "join_type": "BNL", "r_filtered": null }, @@ -742,7 +742,7 @@ ANALYZE "r_filtered": null }, "buffer_type": "flat", - "buffer_size": "256Kb", + "buffer_size": "65", "join_type": "BNL", "attached_condition": "t2.f2 = t3.f3", "r_filtered": null |