Web lists-archives.com

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.

Artem


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.

http://dev.mysql.com/doc/refman/5.6/en/concurrent-inserts.html

--
Shawn Green
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/ for details.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql