in mysql database 5.14 even select causes locks, is there any mitigation?

in mysql database 5.14 even select causes locks, is there any mitigation?
LVL 1
AGAFFARAsked:
Who is Participating?
 
Kevin CrossConnect With a Mentor Chief Technology OfficerCommented:
Yes, it most systems, there will be a lock of some sort on read.  For SQL server you can get around this using WITH(NOLOCK) or setting transaction isolation level.  For MySQL, you don't have WITH(NOLOCK), so you just use the isolation level READ UNCOMMITTED.

Here is a good writeup on the topic:
http://articles.itecsoftware.com/mysql/with-nolock-table-hint-equivalent-for-mysql
0
 
mattibuttCommented:
Does it get locked when you try to execute a query is it some third party application database
0
 
AGAFFARAuthor Commented:
<Does it get locked when you try to execute a query >
yes, if it is complex query

< is it some third party application database >
no, it is main database

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.