Join the community today
Become a Member

MariaDB MariaDB - Slow Temporary Tables

Discussion in 'MariaDB & General MySQL news & discussions' started by Revenge, Dec 19, 2017.

  1. Revenge

    Revenge Active Member

    458
    93
    28
    Feb 21, 2016
    Portugal
    Ratings:
    +350
    Local Time:
    12:35 AM
    1.9.x
    10.1.x
  2. eva2000

    eva2000 Administrator Staff Member

    45,406
    10,302
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +15,980
    Local Time:
    9:35 AM
    Nginx 1.19.x
    MariaDB 5.5/10.x
  3. Revenge

    Revenge Active Member

    458
    93
    28
    Feb 21, 2016
    Portugal
    Ratings:
    +350
    Local Time:
    12:35 AM
    1.9.x
    10.1.x
    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.
     
  4. eva2000

    eva2000 Administrator Staff Member

    45,406
    10,302
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +15,980
    Local Time:
    9:35 AM
    Nginx 1.19.x
    MariaDB 5.5/10.x
    Nice read too Benchmarking Aria