Get the most out of your Centmin Mod LEMP stack
Become a Member

MariaDB MariaDB 10.1.20 now available

Discussion in 'MariaDB & General MySQL news & discussions' started by eva2000, Dec 16, 2016.

  1. rdan

    rdan Well-Known Member

    5,452
    1,418
    113
    May 25, 2014
    Ratings:
    +2,212
    Local Time:
    11:54 PM
    Mainline
    10.2
    With this version of MariaDB I got a lot of DeadLock :/
    Once or twice daily.

     
  2. eva2000

    eva2000 Administrator Staff Member

    58,926
    12,491
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +19,123
    Local Time:
    1:54 AM
    Nginx 1.31.x
    MariaDB 10.x/11.4+/12.3+
    interesting might want to keep an eye on
     
  3. pamamolf

    pamamolf Well-Known Member

    4,125
    429
    83
    May 31, 2014
    Ratings:
    +841
    Local Time:
    6:54 PM
    Nginx-1.29.x
    MariaDB 10.6.x
    @RoldanLT
    It will be good to report your issues there so they fix them :)
     
  4. Xon

    Xon Active Member

    173
    61
    28
    Nov 16, 2015
    Ratings:
    +229
    Local Time:
    11:54 PM
    1.15.x
    MariaDB 10.3.x
    For XenForo? Try my Deadlock Avoidance add-on. It really helps on my sites

    XenForo has some design issues which cause it to deadlock often under load depending on how the optimizer picks rows/indexes to lock.

    My deadlock avoidance add-on re-orders some things and pulls bulky operations out of transactions which virtually eliminates these errors. It requires php5.5+, which is why XenForo can't implement my solutions since XenForo still supports php 5.3
     
  5. eva2000

    eva2000 Administrator Staff Member

    58,926
    12,491
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +19,123
    Local Time:
    1:54 AM
    Nginx 1.31.x
    MariaDB 10.x/11.4+/12.3+
    * hugs @Xon *

    Useful for when this forum grows in activity and size :D
     
  6. rdan

    rdan Well-Known Member

    5,452
    1,418
    113
    May 25, 2014
    Ratings:
    +2,212
    Local Time:
    11:54 PM
    Mainline
    10.2
    Yes, but didn't happen much anymore since I posted it.
    Thanks! I will try it later.