Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 457
  • Last Modified:

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?
0
AGAFFAR
Asked:
AGAFFAR
1 Solution
 
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
 
Kevin CrossChief 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

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now