Re: Optimize multiple writes on the same row
Posted by:
Rick James
Date: March 18, 2012 10:06AM
1000 inserts/sec is over 3 million rows per hour, or 1 billion in two weeks. Please provide some actual numbers so I can tailor a solution to your needs.
Also, please provide SHOW CREATE TABLE for the data table and the table with the averages. SHOW TABLE STATUS will provide the sizes.
And, the query that you run frequently to compute the averages, etc.
Recomputing the average of a million rows every time a row is added is not the best way to do it.
Subject
Views
Written By
Posted
2889
March 14, 2012 02:16PM
1048
March 15, 2012 10:41AM
1144
March 16, 2012 05:31AM
Re: Optimize multiple writes on the same row
944
March 18, 2012 10:06AM
1197
March 19, 2012 08:33AM
1184
March 20, 2012 11:32AM
1088
March 22, 2012 11:49AM
1181
March 23, 2012 11:35AM
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.