SEO

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.


regards
anandkl

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