Join the community today
Become a Member

Xenforo Enable Delayed Insert SQL Queries

Discussion in 'Forum software usage' started by RoldanLT, Dec 28, 2015.

  1. RoldanLT

    RoldanLT Well-Known Member

    3,982
    966
    113
    May 25, 2014
    Phillipines
    Ratings:
    +1,331
    Local Time:
    6:28 AM
    1.11
    10.2
    Do you guys have this option enabled?
    What are your XF database engine?
    Mine are all Innodb and few memory.

    With previous MariaDB/XF version, I have to disable this because I can't post when that option is enabled and all my tables are on innodb, Now it works fine even if it's enabled.
     
  2. eva2000

    eva2000 Administrator Staff Member

    31,027
    6,928
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,434
    Local Time:
    8:28 AM
    Nginx 1.13.x
    MariaDB 5.5
    disabled for me :)
     
  3. Sunka

    Sunka Active Member

    932
    243
    43
    Oct 31, 2015
    Rijeka, Croatia
    Ratings:
    +394
    Local Time:
    11:28 PM
    Nginx 1.13.3
    MariaDB 10.1.24
    Disabled
    Innodb all but few that have to be mysql
     
  4. RoldanLT

    RoldanLT Well-Known Member

    3,982
    966
    113
    May 25, 2014
    Phillipines
    Ratings:
    +1,331
    Local Time:
    6:28 AM
    1.11
    10.2
    And why?
    I enabled it, and don't have issues :).
     
  5. eva2000

    eva2000 Administrator Staff Member

    31,027
    6,928
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,434
    Local Time:
    8:28 AM
    Nginx 1.13.x
    MariaDB 5.5
    not needed with the improvements in MySQL performance especially in MariaDB 10+ and Xenforo's current usage patterns if you have InnoDB tables in use

    see INSERT DELAYED - MariaDB Knowledge Base and MySQL :: MySQL 5.6 Reference Manual :: 13.2.5.2 INSERT DELAYED Syntax

     
    • Like Like x 2
    • Informative Informative x 2
  6. Xon

    Xon Active Member

    134
    57
    28
    Nov 16, 2015
    Ratings:
    +177
    Local Time:
    6:28 AM
    1.13.x
    MariaDB 10.1.x
    INSERT DELAYED is a hack to workaround the limitations of MyISAM which does full-table locks rather than row-level locking.
     
    • Like Like x 2
    • Agree Agree x 2
  7. eva2000

    eva2000 Administrator Staff Member

    31,027
    6,928
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,434
    Local Time:
    8:28 AM
    Nginx 1.13.x
    MariaDB 5.5
    much better explanation :D
     
    • Like Like x 1