Re: high concurency issue with read-write on mysql table
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.
Subject
Views
Written By
Posted
1023
June 12, 2017 05:56AM
522
June 12, 2017 11:09AM
Re: high concurency issue with read-write on mysql table
513
June 13, 2017 05:22AM
438
June 13, 2017 10:02AM
619
June 14, 2017 06:42AM
424
June 14, 2017 09:20AM
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.