MySQL Forums
Forum List  »  InnoDB

Advanced Search
New Topic

Re: High concurrency for master and high reading from slave slowing down insert
Posted by: Peter Brawley
Date: June 22, 2017 10:09AM

It's a smallish table but 30k concurrent inserts.min is a lot. Remember, InnoDB will do one at a time, you might be looking at gap locks and deadlocks, see https://www.percona.com/blog/2014/12/17/innodbs-multi-versioning-handling-can-be-achilles-heel/. A possible approach: a staging table, http://mysql.rjweb.org/doc.php/staging_table.

See https://dev.mysql.com/doc/refman/5.7/en/concurrent-inserts.html.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
High concurrency for master and high reading from slave slowing down insert
1245
Frwa Onto
June 20, 2017 09:21AM
Re: High concurrency for master and high reading from slave slowing down insert
609
Peter Brawley
June 20, 2017 10:12AM
Re: High concurrency for master and high reading from slave slowing down insert
703
Frwa Onto
June 20, 2017 11:01AM
Re: High concurrency for master and high reading from slave slowing down insert
576
Peter Brawley
June 20, 2017 12:22PM
Re: High concurrency for master and high reading from slave slowing down insert
675
Frwa Onto
June 20, 2017 01:22PM
Re: High concurrency for master and high reading from slave slowing down insert
635
Peter Brawley
June 20, 2017 03:08PM
Re: High concurrency for master and high reading from slave slowing down insert
633
Frwa Onto
June 20, 2017 10:13PM
Re: High concurrency for master and high reading from slave slowing down insert
622
Frwa Onto
June 22, 2017 09:06AM
Re: High concurrency for master and high reading from slave slowing down insert
612
Peter Brawley
June 22, 2017 10:09AM
Re: High concurrency for master and high reading from slave slowing down insert
659
Frwa Onto
June 22, 2017 11:02AM
Re: High concurrency for master and high reading from slave slowing down insert
585
Peter Brawley
June 22, 2017 12:57PM
Re: High concurrency for master and high reading from slave slowing down insert
582
Frwa Onto
June 22, 2017 10:14PM
Re: High concurrency for master and high reading from slave slowing down insert
570
Frwa Onto
June 26, 2017 11:17PM
Re: High concurrency for master and high reading from slave slowing down insert
576
Peter Brawley
June 27, 2017 01:25PM
Re: High concurrency for master and high reading from slave slowing down insert
661
Frwa Onto
June 28, 2017 03:57AM


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.