MySQL Forums
Forum List  »  MyISAM

Re: slow query / table lock
Posted by: Thomas Manninger
Date: June 06, 2016 02:06AM

Hi,

i found the sql command:
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

when i converting the table to innodb und use the READ UNCOMMITTED Transaction, it should solve the problem?

Options: ReplyQuote


Subject
Views
Written By
Posted
18730
June 06, 2016 01:55AM
Re: slow query / table lock
1500
June 06, 2016 02:06AM
1770
June 13, 2016 01:55AM
1399
June 13, 2016 01:57AM


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.