MariaDB MariaDB - Slow Temporary Tables

Finally, they assigned a dev to take care of this issue.

---

[MDEV-6630] make aria_used_for_temp_tables a modifiable variable - Jira

 

Ya, and 5 years and half since i created the Jira Ticket. I have a feeling it will take a lot of time to be completed.

Since now im using MariaDB 10.5, i made the test again to check if there are any diferences.

Code:

CREATE TEMPORARY TABLE table2 engine=MyISAM AS (SELECT * FROM ibf_forums_posts);
Query OK, 1740372 rows affected (9.532 sec)
Records: 1740372  Duplicates: 0  Warnings: 0

Code:

CREATE TEMPORARY TABLE table3 engine=Aria AS (SELECT * FROM ibf_forums_posts);
Query OK, 1740372 rows affected (11.995 sec)
Records: 1740372  Duplicates: 0  Warnings: 0

The diference is smaller now, but it's still there.