MySQL Forums
Forum List  »  Newbie

How can I limit table size
Posted by: Rob Rowsome
Date: March 23, 2009 11:45AM

I am using a MyISAM table to store server logs from my website. The problem is, the table grows fast, and quickly becomes unwieldy. I want to limit the total number of rows, while still allowing new data to be inserted, so that the oldest rows are deleted to make room for new rows. Do I need to use a trigger for this? I tried setting the "Max Rows" option, but it doesn't do what I want. Is there an easy way to do this? Thanks.

Options: ReplyQuote

Written By
How can I limit table size
March 23, 2009 11:45AM

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.