what is the command to update InnoDB table indexes?

jeff

Brent Baisley wrote:
> 
> You are referring to fragmentation. In this case I'm pretty sure it's
> just  a matter of updating the indexes so that MySQL makes the correct
> assumptions about the distribution of data. MySQL assumes data values
> have an equal distribution in a database, updating the indexes will
> force MySQL to update it's assumptions and thus do a better job of
> optimizing searches.
> 
> On Wednesday, August 6, 2003, at 12:17 PM, Jeff Mathis wrote:
> 
> > I was under the impression that InnoDB tables took care of this for
> > you.
> > You only need to be concerned if you add/delete repeatedly from
> > anywhere
> > but the end rows of the table.
> >
> > I'd like to know if I'm wrong about this.
> >
> >
> > Adam Nelson wrote:
> >>
> >> I just did a major insert of new data and now all my selects have
> >> slowed
> >> down.  The table is innodb.  Is there a way to reindex everything
> >> without having to drop anything.  Otherwise, I suppose I will have to
> >> drop the indexes and remake them.
> >>
> >> --
> >> MySQL General Mailing List
> >> For list archives: http://lists.mysql.com/mysql
> >> To unsubscribe:
> >> http://lists.mysql.com/[EMAIL PROTECTED]
> >
> > --
> > Jeff Mathis, Ph.D.                    505-955-1434
> > The Prediction Company                        [EMAIL PROTECTED]
> > 525 Camino de los Marquez, Ste 6      http://www.predict.com
> > Santa Fe, NM 87505
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:
> > http://lists.mysql.com/[EMAIL PROTECTED]
> >
> >
> --
> Brent Baisley
> Systems Architect
> Landover Associates, Inc.
> Search & Advisory Services for Advanced Technology Environments
> p: 212.759.6400/800.759.0577

-- 
Jeff Mathis, Ph.D.                      505-955-1434
The Prediction Company                  [EMAIL PROTECTED]
525 Camino de los Marquez, Ste 6        http://www.predict.com
Santa Fe, NM 87505

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to