Re: InnoDB CPU Spikes
Posted by:
Rick James
Date: March 30, 2009 07:13PM
Your SELECT
* Hits 1.8M rows
* Takes 4 seconds
* Apparently did not need to hit the disk
This is quite normal. The CPU (one core, that is) can be expected to be running solid for the 4 seconds. Nothing is broken. Except maybe the alarm, itself.
If you want that query to run faster, you need to build summary tables. But that is another story.
Subject
Views
Written By
Posted
7839
March 18, 2009 02:43AM
2875
March 18, 2009 03:08AM
2735
March 18, 2009 08:29PM
2690
March 19, 2009 04:48AM
2853
March 19, 2009 10:46AM
2604
March 19, 2009 03:47AM
2746
March 19, 2009 03:55AM
2624
March 19, 2009 04:49AM
2593
March 19, 2009 10:20AM
2284
March 30, 2009 01:25AM
Re: InnoDB CPU Spikes
2346
March 30, 2009 07:13PM
2421
March 31, 2009 02:31AM
2647
March 31, 2009 08:12AM
2269
April 01, 2009 03:27AM
2399
April 01, 2009 10:01AM
2455
April 01, 2009 10:22AM
2295
April 01, 2009 03:45AM
2607
April 01, 2009 11:57PM
2517
April 06, 2009 01:23AM
2472
April 06, 2009 08:01PM
2263
April 07, 2009 12:14AM
2400
April 08, 2009 04:36PM
2393
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.