cronjob a sql script that runs a delete statement for old jobs daily
> -----Original Message----- > From: Scott H [mailto:[EMAIL PROTECTED] > Sent: Wednesday, November 12, 2003 10:40 AM > To: MySQL Mailing List > Subject: Re: maintaining size of a db > > > --- 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] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
