running optimize/analyze command

[Ananda Kumar]

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