Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-4563

aria_used_for_temp_tables should be tmp not temp

        Details

        • Type: Task
        • Status: Open
        • Priority: Trivial
        • Resolution: Unresolved
        • Fix Version/s: None
        • Component/s: None
        • Labels:
          None

          Description

          It seems that aria_used_for_temp_tables is not consistent with other system variables. It should be aria_used_for_tmp_tables. (tmp not temp)

          MariaDB [ek]> show variables like '%temp%';
+---------------------------+-------+
| Variable_name             | Value |
+---------------------------+-------+
| aria_used_for_temp_tables | ON    |
+---------------------------+-------+
1 row in set (0.00 sec)

MariaDB [ek]> show variables like '%tmp%';
+-------------------+----------+
| Variable_name     | Value    |
+-------------------+----------+
| max_tmp_tables    | 32       |
| slave_load_tmpdir | /tmp     |
| tmp_table_size    | 33554432 |
| tmpdir            | /tmp     |
+-------------------+----------+
4 rows in set (0.00 sec)

          It should also be noted that in MySQL 5.6, they've just made: default_tmp_storage_engine as a system variable (set to InnoDB as a default). http://dev.mysql.com/doc/refman/5.6/en/server-system-variables.html#sysvar_default_tmp_storage_engine

            Gliffy Diagrams

              Attachments

                Activity

                Hide
                Permalink
                serg Sergei Golubchik added a comment - - edited

                I'd suggest not to rename aria_used_for_temp_tables, but to deprecate it. And add a compatibility variable internal_tmp_disk_storage_engine as a replacement.

                Show
                serg Sergei Golubchik added a comment - - edited I'd suggest not to rename aria_used_for_temp_tables , but to deprecate it. And add a compatibility variable internal_tmp_disk_storage_engine as a replacement.

                  People

                  • Assignee:
                    Unassigned
                    Reporter:
                    colin Colin Charles
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    3 Start watching this issue

                    Dates

                    • Created:
                      Updated: