NO lock in mysql

Question

I am building a desktop application with back-end in MySQL. Does Mysql Support No Lock or some thing equivalent to this as in sql?

Select * from Tablename (NoLock);

Suppose I am fetching data from multiple tables using join, Then do i Need to implement this code while selecting rows from each and every table?

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED ;
SELECT * FROM 'Table1' 
 iNNERjOIN TABLE2 ON TABLE2.FK=TABLE1.PK ;
COMMIT ;

score 12 · Accepted Answer · answered Jun 03 '13 at 05:22

12

try this

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED ;
SELECT * FROM Tablename ;
COMMIT ;

answered Jun 03 '13 at 05:22

PSR

is it single statement works on multiple tables if i use joins – Shashank Jun 03 '13 at 05:49
in my knowledge it will work.But i am not sure on that – PSR Jun 03 '13 at 05:49
It will work for many tables and joins. Actually it will ignore all locks until you revert it using: `SET TRANSACTION ISOLATION LEVEL READ COMMITTED;` – Gerardo Grignoli Sep 10 '14 at 17:57

score 1 · Answer 2 · answered Jun 03 '13 at 05:51

1

You can set the isolation level in the mysql config file to avoid having to call SET TRANSACTION for every query:

[mysqld] transaction-isolation = READ-UNCOMMITTED

answered Jun 03 '13 at 05:51

mixmasteralan

2 Answers2