Limit the size of a database. Rotate the log after this size

2010-08-20 Thread Guillaume Blanc
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

RE: Limit the size of a database. Rotate the log after this size

2010-08-20 Thread Travis Ard
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