| List: | General Discussion | « Previous MessageNext Message » | |
| From: | Anil Doppalapudi | Date: | December 10 2004 5:06pm |
| Subject: | How to rebuild indexes in InnoDB | ||
| View as plain text | |||
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
| Thread | ||
|---|---|---|
| • MYSQL is getting slow | Patrick Marquetecken | 9 Dec |
| • Re: MYSQL is getting slow | Jeff Smelser | 9 Dec |
| • Re: MYSQL is getting slow | gerald_clark | 9 Dec |
| • Re: MYSQL is getting slow | Darryl Waterhouse | 9 Dec |
| • Re: MYSQL is getting slow | Patrick Marquetecken | 9 Dec |
| • Re: MYSQL is getting slow | Jeff Smelser | 9 Dec |
| • Re: MYSQL is getting slow | Patrick Marquetecken | 10 Dec |
| • Re: MYSQL is getting slow | Ing. Bismarck J. Rojas M. | 9 Dec |
| • Re: MYSQL is getting slow | mos | 10 Dec |
| • Re: MYSQL is getting slow | Patrick | 10 Dec |
| • RE: MYSQL is getting slow | Dathan Pattishall | 9 Dec |
| • Re: MYSQL is getting slow | Patrick Marquetecken | 10 Dec |
| • How to rebuild indexes in InnoDB | Anil Doppalapudi | 10 Dec |
| • RE: MYSQL is getting slow | Donny Simonton | 11 Dec |
| • RE: How to rebuild indexes in InnoDB | Dathan Pattishall | 10 Dec |
