MySQL Forums :: Newbie :: How to stop a database growing in size on the disk


Advanced Search

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


Subject Written By Posted
How to stop a database growing in size on the disk Darren White 07/30/2013 03:08AM
Re: How to stop a database growing in size on the disk Phillip Ward 07/30/2013 08:13AM
Re: How to stop a database growing in size on the disk Darren White 07/30/2013 08:24AM
Re: How to stop a database growing in size on the disk Rick James 07/30/2013 09:32PM
Re: How to stop a database growing in size on the disk Darren White 07/31/2013 01:55AM
Re: How to stop a database growing in size on the disk Rick James 07/31/2013 06:39PM
Re: How to stop a database growing in size on the disk Darren White 10/09/2013 02:28AM
Re: How to stop a database growing in size on the disk Rick James 10/10/2013 09:46PM


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.