MySQL Forums
Forum List  »  Newbie

Re: concurrency control
Posted by: Benoit St-Jean
Date: March 11, 2017 01:28PM

To check the transaction isolation level, just use :

SHOW VARIABLES LIKE '%isolation%';

As for what they mean, they are standard across all databases so for more details and/or specifics to MySQL, check this:

https://dev.mysql.com/doc/refman/5.7/en/innodb-transaction-isolation-levels.html

For a description on what each isolation level means, the wikipedia article is pretty informative :

https://en.wikipedia.org/wiki/Isolation_(database_systems)#

Finally, to change the isolation level, the command syntax and details are here:

https://dev.mysql.com/doc/refman/5.7/en/set-transaction.html

Options: ReplyQuote


Subject
Written By
Posted
March 01, 2017 09:26AM
Re: concurrency control
March 11, 2017 01:28PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.