MySQL Forums
Forum List  »  InnoDB

Re: high concurency issue with read-write on mysql table
Posted by: soufiane wahi
Date: June 13, 2017 05:22AM

I know that InnoDB didn't lock all the tables, but when I done the delete query it took enough time to prevent insert on this table.

innodb_buffer_pool_size is about 75% of my RAM, about 36 GB.

The link of big delete won't be a solution for me, because the partition part is not ok for my case because records change a lot, so the partition have to be done each time. Also the delete chunks is a bit slow relatively to my case.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: high concurency issue with read-write on mysql table
112
June 13, 2017 05:22AM


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.