Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

OPTIMIZE TABLE drop all data of the table

Status
Not open for further replies.

viciousd

MIS
Jan 23, 2004
1
FR
Hi,

I've a table who just growing days after days ( data is keeped for 45 days and row deleted after that). So some time I use OPTIMIZE TABLE command to recover some disk spaces. But it's the second time after I do a Optimize table, the table going empty. MySql report OK after the completion of the OPTIMIZE TABLE, no any errors anywhere/

Any Idea??

PS. Is a 1 500 000 rows tables(average, +/- 1.5gigs) running on a "
Ver 11.15 Distrib 3.23.47, for sun-solaris2.8 (sparc)"

Thanks
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top