MySQL Forums
Forum List  »  General

Advanced Search
New Topic

Re: Why is my entire database getting locked for a slow select query?
Posted by: Shawn Taylor
Date: August 26, 2010 08:31PM

Rick,

What is the performance overhead of using it?

With a 2/1 ratio could you actually see a performance gain if the check and insert/prune mechanics are completely ignored?

Shawn

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
Why is my entire database getting locked for a slow select query?
Derek Krzanowski
August 23, 2010 04:04PM
Re: Why is my entire database getting locked for a slow select query?
Derek Krzanowski
August 24, 2010 02:00PM
Re: Why is my entire database getting locked for a slow select query?
Shawn Taylor
August 24, 2010 02:41PM
Re: Why is my entire database getting locked for a slow select query?
Derek Krzanowski
August 24, 2010 03:04PM
Re: Why is my entire database getting locked for a slow select query?
Shawn Taylor
August 25, 2010 07:39AM
Re: Why is my entire database getting locked for a slow select query?
Derek Krzanowski
August 25, 2010 02:02PM
Re: Why is my entire database getting locked for a slow select query?
Shawn Taylor
August 25, 2010 04:49PM
Re: Why is my entire database getting locked for a slow select query?
Rick James
August 24, 2010 11:30PM
Re: Why is my entire database getting locked for a slow select query?
Derek Krzanowski
August 25, 2010 05:21AM
Re: Why is my entire database getting locked for a slow select query?
Shawn Taylor
August 25, 2010 02:46PM
Re: Why is my entire database getting locked for a slow select query?
Derek Krzanowski
August 25, 2010 04:08PM
Re: Why is my entire database getting locked for a slow select query?
Shawn Taylor
August 25, 2010 04:58PM
Re: Why is my entire database getting locked for a slow select query?
Rick James
August 25, 2010 08:03PM
Re: Why is my entire database getting locked for a slow select query?
Derek Krzanowski
August 26, 2010 10:03AM
Re: Why is my entire database getting locked for a slow select query?
Shawn Taylor
August 26, 2010 10:59AM
Re: Why is my entire database getting locked for a slow select query?
Derek Krzanowski
August 26, 2010 11:30AM
Re: Why is my entire database getting locked for a slow select query?
Shawn Taylor
August 26, 2010 12:47PM
Re: Why is my entire database getting locked for a slow select query?
Rick James
August 26, 2010 08:15PM
Re: Why is my entire database getting locked for a slow select query?
Shawn Taylor
August 26, 2010 08:31PM
Re: Why is my entire database getting locked for a slow select query?
Rick James
August 26, 2010 10:17PM
Re: Why is my entire database getting locked for a slow select query?
DBA Lead
September 07, 2010 01:21PM
Re: Why is my entire database getting locked for a slow select query?
Rick James
September 07, 2010 08:16PM
Re: Why is my entire database getting locked for a slow select query?
DBA Lead
September 07, 2010 08:34PM
Re: Why is my entire database getting locked for a slow select query?
Rick James
September 07, 2010 10:51PM


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.