Re: 2 GB limit reached

2002-01-09 Thread Chris Wilson
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

Re: 2 GB limit reached

2002-01-09 Thread Dennis
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,

Re: 2 GB limit reached

2002-01-09 Thread Dan Nelson
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.

RE: 2 GB limit reached

2002-01-09 Thread Johnny Withers
- 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

Re: 2 GB limit reached

2002-01-09 Thread Dennis
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

Re: 2 GB limit reached

2002-01-09 Thread Jeremy Zawodny
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:

Re: 2 GB limit reached

2002-01-09 Thread Chris Wilson
: 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

Re: 2 GB limit reached

2002-01-09 Thread Chris Cooper
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

RE: 2 GB limit reached

2002-01-09 Thread Quentin Bennett
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

RE: 2 GB limit reached

2002-01-09 Thread Dennis
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)

Re: 2 GB limit reached

2002-01-09 Thread Dan Nelson
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

RE: 2 GB limit reached

2002-01-08 Thread Dennis
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)

RE: 2 GB limit reached

2002-01-08 Thread Eric Mayers
/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

Re: 2 GB limit reached

2002-01-08 Thread Randy Katz
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

RE: 2 GB limit reached

2002-01-08 Thread Dennis
: 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

Re: 2 GB limit reached

2002-01-08 Thread Jeremy Zawodny
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