MySQL Forums
Forum List  »  InnoDB

Re: High concurrency for master and high reading from slave slowing down insert
Posted by: Frwa Onto
Date: June 22, 2017 11:02AM

Dear Peter,
I am thinking of staging table idea such first the insert into goes to say my gDataTemp I have status field yes or no. So then I set status no. There after I run a trigger for every minute to check all those data in the staging table copy over to the actual table gdata and set the status as yes. Then I run another trigger to delete all those which have been copied over? Will these be a good solution? So at any time the gdatatemp will have just few thousand data whereas the actual gdata will be in million.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: High concurrency for master and high reading from slave slowing down insert
96
June 22, 2017 11:02AM


Sorry, only registered users may post in this forum.

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.