List:General Discussion« Previous MessageNext Message »
From:Scott Hess Date:June 29 1999 6:37pm
Subject:Re: to much fragmentation
View as plain text  
Much the reverse.  Part of what led us to suspect fragmentation is that
queries to certain tables were getting slow, but the CPU was _not_ very
busy.  Fragmentation leaves your CPU idle while your disks are seeking all
over the place...

Later,
scott

----- Original Message -----
From: Ed Carp <erc@stripped>
To: <monty@stripped>
Cc: <scott@stripped>; <sasha@stripped>; <mysql@stripped>;
<server@stripped>
Sent: Monday, June 28, 1999 11:14 PM
Subject: Re: to much fragmentation


> > 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
> http://www.pobox.com/~erc
>
> "i have my plans and brave ambitions, knowing no bounds, no
inhibitions..."
> Basia Trzetrzelewska, "Third Time Lucky"

Thread
to much fragmentationDavid Johnson26 Jun
  • Re: to much fragmentationSasha Pachev27 Jun
  • Re: to much fragmentationScott Hess28 Jun
    • Re: to much fragmentationVivek Khera28 Jun
    • Re: to much fragmentationMichael Widenius29 Jun
      • Re: to much fragmentationEd Carp29 Jun
        • Re: to much fragmentationSasha Pachev29 Jun
        • Re: to much fragmentationMichael Widenius29 Jun
          • Authentication methodsRoger Smith29 Jun
            • Authentication methodsJani Tolonen1 Jul
        • Re: to much fragmentationScott Hess29 Jun
      • Re: to much fragmentationEd Carp29 Jun
        • Re: to much fragmentationMichael Widenius30 Jun
      • Re: to much fragmentationT├Ánu Samuel29 Jun
  • Re: to much fragmentationScott Hess28 Jun
Re: to much fragmentationFred Lindberg28 Jun