Yes sir, exactly. It's just that's what I'm looking for, and can't figure out. I can set up a cron job, but what exactly would the SQL delete statement be that would allow me to delete old records in such a way that the db maintains an approximately constant size on disk? (Failing that perhaps a delete statement that would just have it maintain a constant # of records? ...maybe this would be much simpler?)
--- Dan Greene wrote: > cronjob a sql script that runs a delete > statement for old jobs daily > > > --- Egor Egorov wrote: > > > Scott H wrote: > > >> Can't seem to find this one in the manual > or > > >> archives - how do I control a db to > maintain > > >> its size to an arbitrary value, say 20 GB? > I > > >> want to just rotate records, deleting > those > > >> that are oldest. > > > > > > You can't restrict size of the database > only > > > with MySQL, use disk quotas. > > > > No! That would just stop mysql right in its > > tracks (so to speak...) when it got too > large. > > But I want old records sloughed off and the > db to > > continue running. (This is for a central > syslog > > box.) . __________________________________ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
