Re: Global read lock on delete
- Date: Wed, 09 Dec 2015 13:07:13 -0500
- From: "shawn l.green" <shawn.l.green@xxxxxxxxxx>
- Subject: Re: Global read lock on delete
On 12/9/2015 12:06 PM, Artem Kuchin wrote:
09.12.2015 19:35, shawn l.green пишет:
INSERT operations are special as you can enable a mode to allow
INSERTs to happen only at the end of the file and not be blocked while
one of the other two operations are in progress.
Cannot find anything about that. Can you be a little more specific? It
is unrelated the my question, but would be great to have too.
It's been a long while since I had to think about the variable
--concurrent-insert so I blurred the lines just a little. I apologize.
Changing the mode cannot allow concurrent UPDATE or DELETE with an
INSERT. The UPDATE or DELETE will always ask for a full table lock. It
only allows for concurrent SELECT and INSERT commands to happen at the
same time to the same MyISAM table.
MySQL Senior Principal Technical Support Engineer
Oracle USA, Inc. - Integrated Cloud Applications & Platform Services
Office: Blountville, TN
Become certified in MySQL! Visit https://www.mysql.com/certification/
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql