[MDEV-19713] Remove big_tables system variable Created: 2019-06-07 Updated: 2022-03-12 Resolved: 2019-09-28 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Variables |
| Fix Version/s: | 10.5.0 |
| Type: | Task | Priority: | Blocker |
| Reporter: | Geoff Montee (Inactive) | Assignee: | Sergei Golubchik |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Description |
|
The documentation and the source code both mention that the big_tables system variable is no longer needed. Should it be deprecated and/or removed?: https://github.com/MariaDB/server/blob/mariadb-10.4.5/sql/sys_vars.cc#L4126 https://mariadb.com/kb/en/library/server-system-variables/#big_tables |
| Comments |
| Comment by Oleksandr Byelkin [ 2019-09-25 ] |
|
OK to push after adding test for deprecated message. |
| Comment by Sergei Golubchik [ 2019-09-28 ] |
|
Not removed. Marked deprecated for now. big_tables was used to tell the server to use on-disk temp tables to avoid "table is full" error when in-memory temp tables are used. This usage became unnecessary many years ago, the server can switch from in-memory to on-disk temp tables automatically. But big_tables can also be used to make the server to create temp-tables on disk right away, skiping the in-memory step. One can achieve the same effect now by setting tmp_memory_table_size=0. |