Join the community today
Register Now

MariaDB - Transaction Isolation

Discussion in 'Feature Requests & Suggestions' started by Revenge, Mar 20, 2016.

  1. Revenge

    Revenge Active Member

    289
    64
    28
    Feb 21, 2016
    Portugal
    Ratings:
    +228
    Local Time:
    3:35 AM
    1.9.x
    10.1.x
    I've noticed that Centminmod uses the default transaction isolation, Repeatable Read.

    Why not use Read Commited, that have more performance in busy sites and is completely safe?

    SET TRANSACTION - MariaDB Knowledge Base

    The founder of Percona, Peter Zaitsev also recommends using Read Commited as default.
    MySQL performance implications of InnoDB isolation modes
     
  2. eva2000

    eva2000 Administrator Staff Member

    30,956
    6,917
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,418
    Local Time:
    1:35 PM
    Nginx 1.13.x
    MariaDB 5.5
    Ultimately, it comes down to your specific web app's mysql usage requirements. As such I wouldn't have any idea what the end user uses, so defaults are most optimal :)

    Also if end user uses mysql replication etc, they may also have a unique set of requirements regarding the best isolation method for the mysql replication configuration.
     
    Last edited: Mar 20, 2016