Re: optimize table failure

2003-02-05 Thread Zak Greant
On Tue, Feb 04, 2003 at 01:27:13PM +0200, Okan CIMEN wrote: > Hi all, > > First of all , the version of mysql is 3.23.52. I am using When I do a > truncate table on a MyIsam table, the show table command shows thatt there > are no records but the table size is about 100 MBs. > > Afterwards, I run

optimize table failure

2003-02-04 Thread Okan CIMEN
Hi all, First of all , the version of mysql is 3.23.52. I am using When I do a truncate table on a MyIsam table, the show table command shows thatt there are no records but the table size is about 100 MBs. Afterwards, I run an optimize table command and the table size decreases to 2KB's. Everythi

optimize table failure

2003-02-04 Thread Okan CIMEN
Hi all, First of all , the version of mysql is 3.23.52. I am using When I do a truncate table on a MyIsam table, the show table command shows thatt there are no records but the table size is about 100 MBs. Afterwards, I run an optimize table command and the table size decreases to 2KB's. Everythi