ALTER TABLE 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
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 an
