MySQL Forums
Forum List  »  Performance

Re: InnoDB CPU Spikes
Posted by: Aftab Khan
Date: March 19, 2009 04:49AM

EXPLAIN SELECT is missing?
Your table structure shows that you haven't defined any keys ( except primary key, you need to add index on fldCreatedDate). that's the reason your MIS reports are slow...Like we said you need to archive older data and create summary tables. Or think about table partitioning...

You have 8G RAM

increase innodb_buffer_pool_size # can be set upto 4G

>| innodb_log_file_size | 5242880 | # 5M
it should be 25% of innodb_buffer_pool



Edited 1 time(s). Last edit at 03/19/2009 04:53AM by Aftab Khan.

Options: ReplyQuote


Subject
Views
Written By
Posted
7444
March 18, 2009 02:43AM
2762
March 18, 2009 03:08AM
2635
March 18, 2009 08:29PM
2586
March 19, 2009 04:48AM
2744
March 19, 2009 10:46AM
2510
March 19, 2009 03:47AM
2666
March 19, 2009 03:55AM
Re: InnoDB CPU Spikes
2526
March 19, 2009 04:49AM
2500
March 19, 2009 10:20AM
2202
March 30, 2009 01:25AM
2273
March 30, 2009 07:13PM
2301
March 31, 2009 02:31AM
2536
March 31, 2009 08:12AM
2198
April 01, 2009 03:27AM
2256
April 01, 2009 10:01AM
2360
April 01, 2009 10:22AM
2228
April 01, 2009 03:45AM
2519
April 01, 2009 11:57PM
2413
April 06, 2009 01:23AM
2379
April 06, 2009 08:01PM
2154
April 07, 2009 12:14AM
2308
April 08, 2009 04:36PM
2321
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.