MySQL Forums
Forum List  »  InnoDB

Re: High concurrency for master and high reading from slave slowing down insert
Posted by: Peter Brawley
Date: June 27, 2017 01:25PM

> I run a trigger for every minute

Triggers can't be scheduled.

> Then I run another trigger to delete all those which have been copied over

As above.

Well, "benchmark" was way too terse a description. You'll be calculating required throughput, matching that up with disk & MySQL throughput capabilities, scaling staging hardware & software accordingly, then see how to implement it all in app and mysql code.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: High concurrency for master and high reading from slave slowing down insert
541
June 27, 2017 01:25PM


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.