PM
To: [EMAIL PROTECTED]
Subject: RE: 2 GB limit reached
We have a database that seems to have grown too large, and now any
operation fails on it. How can we fix this?
Dennis
--
Chris Wilson [EMAIL PROTECTED]
http://www.wapmx.com
At 11:26 PM 01/08/2002, you wrote:
On Tue, Jan 08, 2002 at 08:03:07PM -0500, Dennis wrote:
At 07:07 PM 01/08/2002, you wrote:
Dennis,
You may want to look into using InnoDB tables. I believe InnoDB tables
are immune to the 2gb limit (which usually comes from the filesystem).
Also,
In the last episode (Jan 08), Dennis said:
We have a database that seems to have grown too large, and now any
operation fails on it. How can we fix this?
If you can SELECT from it, create a new MYISAM table with the RAID
option, or create an INNODB table with multiple 2gb tablespace files.
-
Johnny Withers
[EMAIL PROTECTED]
p. 601.853.0211
c. 601.209.4985
-Original Message-
From: Dennis [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 09, 2002 10:52 AM
To: [EMAIL PROTECTED]
Subject: Re: 2 GB limit reached
At 11:26 PM 01/08/2002, you wrote:
On Tue, Jan 08, 2002 at 08
At 12:09 PM 01/09/2002, Dan Nelson wrote:
In the last episode (Jan 08), Dennis said:
We have a database that seems to have grown too large, and now any
operation fails on it. How can we fix this?
If you can SELECT from it, create a new MYISAM table with the RAID
option, or create an INNODB
On Wed, Jan 09, 2002 at 12:23:27PM -0500, Dennis wrote:
is the 2GB limit only in linux 2.2? (ie does 2.4 not have that
limit?). Running a 2.4 kernel is the easiest option in that case.
Right.
--
Jeremy D. Zawodny, [EMAIL PROTECTED]
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax:
: Wednesday, January 09, 2002 10:52 AM
To: [EMAIL PROTECTED]
Subject: Re: 2 GB limit reached
At 11:26 PM 01/08/2002, you wrote:
On Tue, Jan 08, 2002 at 08:03:07PM -0500, Dennis wrote:
At 07:07 PM 01/08/2002, you wrote:
Dennis,
You may want to look into using InnoDB tables. I
I've had no problems with MySQL RAID, and the performance is excellent
as long as you have your indices set up properly. One caveat I might add
is that MySQL RAID does not apply to index files (.MYI). If your index
files are going to grow 4 GB, you'll need to consider alternate
filesystems
Wilson [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 10 January 2002 7:07 a.m.
To: Johnny Withers
Cc: [EMAIL PROTECTED]
Subject: Re: 2 GB limit reached
As I said in my message (although I've still not had time to look further
into this) this will not solve your problem completely. My 2.4.17 testbox
I just found out that this is Freebsd 4.1 running v3.22.23 of mySQL. Is
there an issue with v3.22 related to this?
Dennis
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
In the last episode (Jan 09), Dennis said:
I just found out that this is Freebsd 4.1 running v3.22.23 of mySQL.
Is there an issue with v3.22 related to this?
http://www.mysql.com/doc/T/a/Table_size.html says that 3.22 was limited
to 2gb or 4gb, depending on the OS. Upgrading to 3.23 will let
We have a database that seems to have grown too large, and now any
operation fails on it. How can we fix this?
Dennis
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
/InnoDB_overview.html for further detail.
Eric Mayers
-Original Message-
From: Dennis [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 08, 2002 3:31 PM
To: [EMAIL PROTECTED]
Subject: RE: 2 GB limit reached
We have a database that seems to have grown too large, and now any
operation fails
If it is on a Linux machine (yes, yes) look into the file size
limitation of the OS! (assuming you are talking about a single
table?)...
On Tue, Jan 08, 2002 at 06:30:59PM -0500, Dennis wrote:
We have a database that seems to have grown too large, and now any
operation fails on it. How can
: Tuesday, January 08, 2002 3:31 PM
To: [EMAIL PROTECTED]
Subject: RE: 2 GB limit reached
We have a database that seems to have grown too large, and now any
operation fails on it. How can we fix this?
Dennis
-
Before posting
On Tue, Jan 08, 2002 at 08:03:07PM -0500, Dennis wrote:
At 07:07 PM 01/08/2002, you wrote:
Dennis,
You may want to look into using InnoDB tables. I believe InnoDB tables
are immune to the 2gb limit (which usually comes from the filesystem).
Also, InnoDB claims that the innodb tables are
16 matches
Mail list logo