MySQL Forums
Forum List  »  Newbie

How to stop a database growing in size on the disk
Posted by: Darren White
Date: July 30, 2013 03:08AM

Any tips for stopping a database from growing.

Also a more specific question. Say I have some log table partitioned by month. The idea being I can keep pruning so that I only ever have two months of log data in the table. Say a month (one row per second) is 3 million rows. If I remove a partition with 3 million rows will that actually reduced the size the database takes up on the disk?

Options: ReplyQuote

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.