diff options
| author | Marko Mäkelä <marko.makela@mariadb.com> | 2021-03-11 20:09:34 +0200 |
|---|---|---|
| committer | Marko Mäkelä <marko.makela@mariadb.com> | 2021-03-11 20:09:34 +0200 |
| commit | a4b7232b2cfd504057c26f9b40a2dacf064dca73 (patch) | |
| tree | 9a33e1d13f7b7b716da89fe41f3ffdd3bf6221ba /mysql-test/main/opt_trace.test | |
| parent | a8650b64ede7330e83e84226cccd77ba8e05fa29 (diff) | |
| parent | 1ea6ac3c953f847da033254d5df67f57987a1884 (diff) | |
| download | mariadb-git-a4b7232b2cfd504057c26f9b40a2dacf064dca73.tar.gz | |
Merge 10.4 into 10.5
Diffstat (limited to 'mysql-test/main/opt_trace.test')
| -rw-r--r-- | mysql-test/main/opt_trace.test | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/mysql-test/main/opt_trace.test b/mysql-test/main/opt_trace.test index 314e5825c08..ecb6658e338 100644 --- a/mysql-test/main/opt_trace.test +++ b/mysql-test/main/opt_trace.test @@ -622,7 +622,23 @@ UPDATE t1 SET b=10 WHERE a=1; SELECT JSON_DETAILED(JSON_EXTRACT(trace, '$**.range_scan_alternatives')) from INFORMATION_SCHEMA.OPTIMIZER_TRACE; DROP TABLE t1; +set optimizer_trace='enabled=off'; + +--echo # +--echo # MDEV-24975 Server consumes extra 4G memory upon querying INFORMATION_SCHEMA.OPTIIMIZER_TRACE +--echo # +set max_session_mem_used=1024*1024*1024; +--disable_result_log +select count(*) from information_schema.optimizer_trace; +select * from information_schema.optimizer_trace; +--enable_result_log +set max_session_mem_used=default; + +--echo # --echo # End of 10.4 tests +--echo # + +set optimizer_trace='enabled=on'; --echo # --echo # Test many rows to see output of big cost numbers |