Learn about Centmin Mod LEMP Stack today
Register Now

Xenforo Enable Delayed Insert SQL Queries

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

  1. RoldanLT

    RoldanLT Well-Known Member

    3,901
    949
    113
    May 25, 2014
    Phillipines
    Ratings:
    +1,298
    Local Time:
    5:56 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

    30,161
    6,785
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,136
    Local Time:
    7:56 AM
    Nginx 1.13.x
    MariaDB 5.5
    disabled for me :)
     
  3. Sunka

    Sunka Active Member

    917
    240
    43
    Oct 31, 2015
    Rijeka, Croatia
    Ratings:
    +388
    Local Time:
    11:56 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,901
    949
    113
    May 25, 2014
    Phillipines
    Ratings:
    +1,298
    Local Time:
    5:56 AM
    1.11
    10.2
    And why?
    I enabled it, and don't have issues :).
     
  5. eva2000

    eva2000 Administrator Staff Member

    30,161
    6,785
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,136
    Local Time:
    7:56 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

    130
    57
    28
    Nov 16, 2015
    Ratings:
    +171
    Local Time:
    5:56 AM
    1.11.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

    30,161
    6,785
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,136
    Local Time:
    7:56 AM
    Nginx 1.13.x
    MariaDB 5.5
    much better explanation :D
     
    • Like Like x 1