Re: running optimize/analyze command

2008-04-28 Thread Sebastian Mendel
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

running optimize/analyze command

2008-04-28 Thread 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