How can I limit table size
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.
Subject
Written By
Posted
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.