Well, it wouldn't exactly limit the size of your tables, but you may want to look into creating a partitioned table to store your data. You could define your partition ranges to store a single day's worth of data or whatever granularity works best for you. Then, when you need to remove older data, it will be very easy to simply drop the partition(s) you no longer need.
-Travis -----Original Message----- From: Guillaume Blanc [mailto:guillaume.b.bl...@gmail.com] Sent: Friday, August 20, 2010 8:55 AM To: mysql@lists.mysql.com Subject: Limit the size of a database. Rotate the log after this size Hello everyone, I've actually a database (MySAM) which is growing very quickly (1,3Go/hour). I would like to limit the size of the database but with a log rotation after the size is reached. Do you know a way to do it ? I thought of maybe a script who would delete the oldest entry when it reach a certain size. But i don't know how to write it. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
