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-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) http://lists.mysql

RE: 2 GB limit reached

2002-01-09 Thread Quentin Bennett
- From: Chris 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.

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 anywa

Re: 2 GB limit reached

2002-01-09 Thread Chris Wilson
.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:03:07P

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 F

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 I

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

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. T

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 filesyst

Re: 2 GB limit reached

2002-01-09 Thread Chris Wilson
#x27;s working :). Regards, Chris > >-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

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 ta

RE: 2 GB limit reached

2002-01-08 Thread Dennis
essage- >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, an

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 ca

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 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) http://lists.mysql.com