> Ed> Is this why MySQL 3.22.21 eats up all my CPU when searching a 50K row
> Ed> indexed table? Almost no deletes, but lots and lots of adds. Is
there
> Ed> something I can do about the CPU utilization?
>
> If you don't have any deletes and updates, the table should not be
> that fragmented.
>
> You can check this by doing 'isamchk -dv table_name'
> (You don't have to take down mysqld for this)
isamchk -dv news gives me:
ISAM file: news
Isam-version: 2
Creation time: 1999-03-16 23:59:29
Data records: 53715 Deleted blocks: 0
Datafile Parts: 54305 Deleted data: 0
Datafile pointer (bytes): 4 Keyfile pointer (bytes): 3
Recordlength: 1032
Record format: Packed
table description:
Key Start Len Index Type Root Blocksize Rec/key
Interesting that it doens't list a key! Maybe that's my problem, huh? Duh!
> Why do you think MySQL is CPU and not disk bound in the above case?
Because the disk light doesn't flash more than once every few seconds, but
top says it's sucking up the CPU time like there's no tomorrow :)
--
"A friend is someone who won't give up until he finds you, and brings you
home". -- Robert Fraser
Ed Carp, N7EKG - erc@stripped - 9403672744@stripped for URGENT
messages only!
Web: http://www.pobox.com/~erc
