Re: Space is filling up

2004-07-12 Thread gerald_clark
Harald Fuchs wrote: In article <[EMAIL PROTECTED]>, gerald_clark <[EMAIL PROTECTED]> writes: Asif Iqbal wrote: Jack Coxen wrote: If you database contains time-based data you could age out old records. I only need to keep data for 6 months so I run a nightly script to delete any

Re: Space is filling up

2004-07-09 Thread Harald Fuchs
In article <[EMAIL PROTECTED]>, gerald_clark <[EMAIL PROTECTED]> writes: > Asif Iqbal wrote: >> Jack Coxen wrote: >> >>> If you database contains time-based data you could age out old records. I >>> only need to keep data for 6 months so I run a nightly script to delete any >>> records more tha

Re: Space is filling up

2004-07-09 Thread gerald_clark
Asif Iqbal wrote: Jack Coxen wrote: If you database contains time-based data you could age out old records. I only need to keep data for 6 months so I run a nightly script to delete any records more than 6 months old. And before anyone asks...yes, I also run another script to ANALYZE/OPTIMIZE

Re: Space is filling up

2004-07-08 Thread Asif Iqbal
ebrt.err -rw-rw1 mysqlmysql 3 Nov 21 2003 webrt.pid Thanks for all the help > Jack > > > -Original Message- > From: Asif Iqbal [mailto:[EMAIL PROTECTED] > Sent: Wednesday, July 07, 2004 2:07 PM > To: gerald_clark > Cc: [EMAIL PROTEC

RE: Space is filling up

2004-07-08 Thread Jack Coxen
x27; Cc: [EMAIL PROTECTED] Subject: Re: Space is filling up Jack Coxen wrote: > If you database contains time-based data you could age out old > records. I only need to keep data for 6 months so I run a nightly > script to delete any records more than 6 months old. And before >

Re: Space is filling up

2004-07-07 Thread gerald_clark
does he even have enough disk space to optimize tables? Jack -Original Message- From: Asif Iqbal [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 07, 2004 2:07 PM To: gerald_clark Cc: [EMAIL PROTECTED] Subject: Re: Space is filling up gerald_clark wrote: > What about getting a bigger dr

Re: Space is filling up

2004-07-07 Thread Justin Swanhart
--- Asif Iqbal <[EMAIL PROTECTED]> wrote: > gerald_clark wrote: > > What about getting a bigger drive? > > I guess that would be my only option eh? > If any of your data can be considered "history" data that is never modified, you could create compressed myISAM tables for that data, removing it

RE: Space is filling up

2004-07-07 Thread Jack Coxen
Message- From: Asif Iqbal [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 07, 2004 2:07 PM To: gerald_clark Cc: [EMAIL PROTECTED] Subject: Re: Space is filling up gerald_clark wrote: > What about getting a bigger drive? I guess that would be my only option eh? > > Asif Iqbal wrote: >

Re: Space is filling up

2004-07-07 Thread Asif Iqbal
gerald_clark wrote: > What about getting a bigger drive? I guess that would be my only option eh? > > Asif Iqbal wrote: > > >Hi All > > > >My mysql data dir is filled up to 95% and only 345M left. > > > >Here is the dir looks like > > > >1.9Gibdata1 > >3.1Gibdata2 > >3.0Kib_arch_log

Re: Space is filling up

2004-07-07 Thread gerald_clark
What about getting a bigger drive? Asif Iqbal wrote: Hi All My mysql data dir is filled up to 95% and only 345M left. Here is the dir looks like 1.9Gibdata1 3.1Gibdata2 3.0Kib_arch_log_02 3.0Kib_arch_log_04 25K ib_arch_log_00 65M rt3 67K webrt.err