Re: InnoDB CPU Spikes
Thanks Aftab.
I am currently doing batch inserts. The reason why I mentioned that it slows down is because the application ultimately crashes because of longer duration of inserts and the input queue explodes :-(
If I have correctly understood then adding an index is not going to help because of the use of date function. Could I live without the index?
The table is archived, records older than 7 days are purged (18M records each day inserts).
PS: I really do not care the time that would be taken to build the summary table it could even take 1 hr but there should not be any spikes (if that is possible)
Thanks again!
Subject
Views
Written By
Posted
7852
March 18, 2009 02:43AM
2878
March 18, 2009 03:08AM
2739
March 18, 2009 08:29PM
2695
March 19, 2009 04:48AM
2856
March 19, 2009 10:46AM
2606
March 19, 2009 03:47AM
2750
March 19, 2009 03:55AM
2629
March 19, 2009 04:49AM
2596
March 19, 2009 10:20AM
2292
March 30, 2009 01:25AM
2350
March 30, 2009 07:13PM
2425
March 31, 2009 02:31AM
2654
March 31, 2009 08:12AM
2271
April 01, 2009 03:27AM
2402
April 01, 2009 10:01AM
Re: InnoDB CPU Spikes
2458
April 01, 2009 10:22AM
2300
April 01, 2009 03:45AM
2611
April 01, 2009 11:57PM
2522
April 06, 2009 01:23AM
2479
April 06, 2009 08:01PM
2271
April 07, 2009 12:14AM
2403
April 08, 2009 04:36PM
2395
April 16, 2009 07:02AM
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.