Re: optimize mysql table's physical storage

2008-04-18 Thread Dan Nelson
In the last episode (Apr 18), tech user said: > My mysql table has been created for long time, it increases day by > day, and become huge. Right now a full scan to the table for the > first time is very slow. So I was thinking to optimize it. This table > is stored in many non-sequential disk fragm

optimize mysql table's physical storage

2008-04-17 Thread tech user
Hello, My mysql table has been created for long time, it increases day by day, and become huge. Right now a full scan to the table for the first time is very slow. So I was thinking to optimize it. This table is stored in many non-sequential disk fragments I think. I want to make this table to be