Re: reindexing

[Brent Baisley]

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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]