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
1285
June 12, 2017 05:56AM
617
June 12, 2017 11:09AM
Re: high concurency issue with read-write on mysql table
635
June 13, 2017 05:22AM
596
June 13, 2017 10:02AM
750
June 14, 2017 06:42AM
586
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.