Ed Carp wrote:
> > Yes. MySQL 3.22 will fragment rows if you mix a lot of deletes/inserts into
> > the same table.
> > The new ISAM in MySQL 3.23 will automaticly join adjacent deleted
> > blocks and can extend blocks much better than the old ISAM.
> Is this why MySQL 3.22.21 eats up all my CPU when searching a 50K row
> indexed table? Almost no deletes, but lots and lots of adds. Is there
> something I can do about the CPU utilization?
> By the way, I've been attending to police duties the last couple of
> months, and haven't been active on the list, but will be more active in
> the future :)
> Ed Carp, N7EKG erc@stripped 940/367-2744 cell phone
> Owner: WeatherAlert/Digital Weatherman - NWS alerts via email/pager/Internet
> DSOUTH-L backup, Terrorism, Shamanism, Hurricane mailing lists