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
Erlend,
Wednesday, October 09, 2002, 2:21:40 PM, you wrote:
EHS> First time I downloaded the source code and compiled it, I just deleted the
EHS> old indexes and created new ones. But now I have a lot of tables with
EHS> fulltext indexes. So I'm looking for an easy way to do it.
EHS> Searched thr
It says in the manual ".. recompile MySQL, and rebuild your FULLTEXT indexes
...".
First time I downloaded the source code and compiled it, I just deleted the
old indexes and created new ones. But now I have a lot of tables with
fulltext indexes. So I'm looking for an easy way to do it.
Searched
