ALTER TABLE <tablename> TYPE = InnoDB; Will rebuild the indexes all at the same time.
-----Original Message----- From: Anil Doppalapudi [mailto:[EMAIL PROTECTED] Sent: Friday, December 10, 2004 9:06 AM To: [EMAIL PROTECTED] Subject: How to rebuild indexes in InnoDB Hi, any one give me an idea how to rebuild indexes in InnDB database. database users are complaining that response time is slow. right now what I am doing is dropping indexes on table and recreating them. After that Database is working fine for some days and again it is giving problem. dropping and recreating indexes taking lot of time. any alternative Thanks in advance. Anil DBA -- 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]