MySQL Forums
Forum List  »  MyISAM

Advanced Search
New Topic

Re: "Incorrect key file for table XXXX"
Posted by: Brian Barnes
Date: August 01, 2007 03:11PM

Shane,

A much appreciated side effect of the removal of the key_cache_block_size appears to be vastly more efficient CPU utilization. Previously, I would see roughly 75-90% CPU, but a quarter of it was system time. I never could get rid of it and had no idea where it was coming from. My KDE Sysguard CPU meter would rarely max out at 100% and there was always a significant amount of red system time.

Now, I have a sharp spike from 0 to 100% and a completely saturated blue box indicating 100% user time for the life of my longer queries.

It looks like I have roughly 25% more user time on hard queries. I wonder whether the system time was caused by mallocing and freeing memory.

Any other useful memory tricks?

Thanks 1E6,

BrianP

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
"Incorrect key file for table XXXX"
80313
Christian Neise
March 11, 2005 04:40PM
Re: "Incorrect key file for table XXXX"
38326
Ingo Strüwing
April 27, 2005 03:52AM
Re: "Incorrect key file for table XXXX"
35003
Michael Farace
June 21, 2005 04:28PM
Re: "Incorrect key file for table XXXX"
30776
Ingo Strüwing
June 22, 2005 01:18AM
Re: "Incorrect key file for table XXXX"
24455
Wilfried Wolf
July 14, 2005 05:42AM
Re: "Incorrect key file for table XXXX"
16808
Ingo Strüwing
July 18, 2005 07:42AM
Re: "Incorrect key file for table XXXX"
15679
olli
September 16, 2005 07:32AM
Re: "Incorrect key file for table XXXX"
11583
Ingo Strüwing
September 19, 2005 01:25AM
Re: "Incorrect key file for table XXXX" try to repair it
13108
Sripati Misra
December 04, 2006 01:34AM
Re: "Incorrect key file for table XXXX" try to repair it
11453
Ingo Strüwing
December 18, 2006 10:20AM
Re: "Incorrect key file for table XXXX" try to repair it
9668
Andrew Hanna
December 19, 2006 09:26AM
Re: "Incorrect key file for table XXXX" try to repair it
8526
Ingo Strüwing
December 20, 2006 02:32AM
Re: "Incorrect key file for table XXXX" try to repair it
21625
Martin Bachmann
March 23, 2007 08:30AM
Re: "Incorrect key file for table XXXX" try to repair it
10910
Chris Slominski
March 29, 2007 05:49AM
Re: "Incorrect key file for table XXXX" try to repair it
10329
George Herlin
May 19, 2007 03:13AM
Re: "Incorrect key file for table XXXX" try to repair it
7288
Amol Kulkarni
June 13, 2008 03:12AM
Re: "Incorrect key file for table XXXX"
8451
Chris Slominski
March 29, 2007 06:19AM
Re: "Incorrect key file for table XXXX"
14413
Brian Barnes
July 18, 2007 05:45PM
Re: "Incorrect key file for table XXXX"
6782
Shane Bester
July 19, 2007 03:44PM
Re: "Incorrect key file for table XXXX"
6268
Brian Barnes
August 01, 2007 02:45PM
Re: "Incorrect key file for table XXXX"
5598
Samer Fayssal
January 06, 2008 05:00PM
Re: "Incorrect key file for table XXXX"
5772
Brian Barnes
August 01, 2007 03:11PM
Re: "Incorrect key file for table XXXX"
6025
Shane Bester
August 08, 2007 01:08PM
Re: "Incorrect key file for table XXXX"
7006
M. Bullinger
April 30, 2007 11:06AM
Re: "Incorrect key file for table XXXX"
5709
Shane Bester
July 19, 2007 03:45PM
Re: "Incorrect key file for table XXXX"
6572
Naro SCHWERDTFEGER
September 26, 2007 09:07AM
Re: "Incorrect key file for table XXXX"
5992
Naro SCHWERDTFEGER
October 04, 2007 06:11AM
Re: "Incorrect key file for table XXXX"
9030
Carol Nickel
October 24, 2007 09:29AM
Re: "Incorrect key file for table XXXX"
16733
Carol Nickel
November 01, 2007 01:12PM
Re: "Incorrect key file for table XXXX"
10526
Andries Bruinsma
February 12, 2008 08:45AM
Re: "Incorrect key file for table XXXX"
9985
Bèrto 'd Sèra
September 16, 2008 10:07AM


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.