MySQL Forums
Forum List  »  Performance

Re: InnoDB CPU Spikes
Posted by: Sabari girish Viswanathan
Date: April 07, 2009 12:14AM

This would mean we need to duplicate the user in a table per date.

The current subscriber count for my customer is 5 million. So having another table on worst case is 5 mil if everyone logs into the system.

This also would mean a full table scan having my old problem of spikes :-(

Options: ReplyQuote


Subject
Views
Written By
Posted
8201
March 18, 2009 02:43AM
3004
March 18, 2009 03:08AM
2843
March 18, 2009 08:29PM
2794
March 19, 2009 04:48AM
2955
March 19, 2009 10:46AM
2744
March 19, 2009 03:47AM
2865
March 19, 2009 03:55AM
2738
March 19, 2009 04:49AM
2708
March 19, 2009 10:20AM
2388
March 30, 2009 01:25AM
2470
March 30, 2009 07:13PM
2538
March 31, 2009 02:31AM
2768
March 31, 2009 08:12AM
2369
April 01, 2009 03:27AM
2525
April 01, 2009 10:01AM
2571
April 01, 2009 10:22AM
2394
April 01, 2009 03:45AM
2730
April 01, 2009 11:57PM
2639
April 06, 2009 01:23AM
2597
April 06, 2009 08:01PM
Re: InnoDB CPU Spikes
2374
April 07, 2009 12:14AM
2517
April 08, 2009 04:36PM
2505
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.