when i reimport i usually drop all the indexes first anyway as it takes forever i have found that a repair table quick usually helps after reindexing too
-----Original Message----- From: Adam Nelson [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 06, 2003 8:09 AM To: 'MySQL' Subject: reindexing 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]