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
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