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