MySQL Forums
Forum List  »  Performance

Re: concurrent_insert
Posted by: Ben Zhou
Date: June 04, 2014 08:37AM

Thanks Rick! In our situation, switching to innodb is not possible given the project timeline.

We are using mysql 5.6.12 (community edition), one strange thing is : after setting the global variable 'concurrent_insert=auto', the SELECT query is still not blocking the INSERT statement, eventhough the table has the 'hole' in it.

Do you know why?

Many thanks!!
Ben

Options: ReplyQuote


Subject
Views
Written By
Posted
1456
June 01, 2014 08:15AM
980
June 02, 2014 11:53AM
Re: concurrent_insert
817
June 04, 2014 08:37AM
897
June 05, 2014 07:55PM


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.