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
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
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 than 6 months old.
]
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
anyone asks...yes, I also run another script
1 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 PROTECTED]
Subject: Re: Space is filling up
gerald_clark 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
70K mysql
101Mib_logfile0
101M
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
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_02
3.0K
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:
Hi All
My
--- 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 from the
.
But 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 drive?
I
11 matches
Mail list logo