MySQL Forums
Forum List  »  Database Administration & Monitoring

Advanced Search
New Topic

RHow To Reclaim Space After Huge Delete
Posted by: Shobhit Srivastava
Date: September 10, 2014 04:10AM

Hello,

I am using MySQL 5.5.24 on Windows server

I have deleted data older than one year from 48 tables and want to reclaim the space which might have released after this bulk deletion.

I have just observed that innodb_file_per_table is OFF

Please suggest how can I reclaim the space now?
Since this is production, I don’t want to stop application.

Thanks!

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
RHow To Reclaim Space After Huge Delete
Shobhit Srivastava
September 10, 2014 04:10AM
Re: RHow To Reclaim Space After Huge Delete
Peter Brawley
September 10, 2014 10:40AM
Re: RHow To Reclaim Space After Huge Delete
Rick James
September 11, 2014 06:01PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.