| List: | General Discussion | « Previous MessageNext Message » | |
| From: | Ananda Kumar | Date: | September 15 2008 11:44am |
| Subject: | optimize table | ||
| View as plain text | |||
I have a table which adds on a daily basis around 3 million records. We have a automated stored proc, which deletes 1 million reocrds. Now the optimize table command takes loot of time for me to defragment the table. Is there a any way i can improve the speed of optimize table command. My mysql version is 5.0.41 and have 16GB RM and 8 CPU's regards anandkl
| Thread | ||
|---|---|---|
| • optimize table | Ananda Kumar | 15 Sep |
| • RE: optimize table | Theodore Petkantchin | 17 Sep |
| • Re: optimize table | Ananda Kumar | 16 Sep |
| • Re: optimize table | chandru | 16 Sep |
