Ananda Kumar schrieb:
> Hi All,
> I am using mysql 5.0.41 on debain.
> I have 8 processor, 8 GB RAM.
> I have atable with 95 Million records, each day there will be about 1.5
> Million records deleted, and around 3.5 Million records added using "LOAD
> FILE" script.
>
> Since there would daily deletes happening, there would be lot of
> fragmention, so i used the
> analyze table <table_name>; command to defragment it, it took close to 12
> hrs. Is there any better and faster way to analyze or optimize the table to
> defragmentation.

having a fixed row length will prevent tale fragmentation

--
Sebastian