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

Posted on 2010-09-21
Last Modified: 2012-05-10
in mysql database 5.14 even select causes locks, is there any mitigation?
Question by:AGAFFAR
LVL 11

Expert Comment

ID: 33732435
Does it get locked when you try to execute a query is it some third party application database

Author Comment

ID: 33732641
<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

LVL 59

Accepted Solution

Kevin Cross earned 500 total points
ID: 33735207
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:

Featured Post

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This guide whil teach how to setup live replication (database mirroring) on 2 servers for backup or other purposes. In our example situation we have this network schema (see atachment). We need to replicate EVERY executed SQL query on server 1 to…
Popularity Can Be Measured Sometimes we deal with questions of popularity, and we need a way to collect opinions from our clients.  This article shows a simple teaching example of how we might elect a favorite color by letting our clients vote for …
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question