Peter, There is no 1 gig limit that I am aware of. I have been using MySQL 4.1 since the day it was released. And when 4.1.1 came out I switched about half of our machines to using it, and when 4.1.2 comes out in the next week or so, I will switch our stuff that is using 4.1.x to that as well. We are using Fedora core 1 and we don't have a memory limit at all.
Linux does have a 2gig memory limit per process or thread. But MySQL can definitely use more than 1gig of memory. If it couldn't then I wouldn't be using it. Donny > -----Original Message----- > From: Peter J Milanese [mailto:[EMAIL PROTECTED] > Sent: Tuesday, March 09, 2004 9:06 AM > To: Donny Simonton > Cc: 'Jigal van Hemert'; [EMAIL PROTECTED] > Subject: RE: mysql 1gb memory limit? > > Donny- > > While I appreciate your bluntness, I did have this issue a time back with > 4.1.x. > > In your email, the reference to big-tables stated that it prevents table > fulls. This would dictate > that it does affect limits, or working around them , likely a limit set > forth by temporary tables (in memory). > > The other thing that I did was increase block sizes on the filesystem > storing the data. I set it to allow 2TB > filesizes (16TB Filesystem), as my largest table pushes about 1/4 of that. > Linux kernel (32-bit 2.4.x) defaults at 2TB max, but that's > the other limit you'd have to deal with (with LVM) > > Back to the point, the 1gig limit stated in the initial email can be > overcome. Things you have to keep in mind > are which OS to choose, which architecture, and the underlying filesystem. > > P > > > > > > "Donny Simonton" <[EMAIL PROTECTED]> > 03/09/2004 09:09 AM > > To: "'Peter J Milanese'" <[EMAIL PROTECTED]> > cc: "'Jigal van Hemert'" <[EMAIL PROTECTED]>, > <[EMAIL PROTECTED]> > Subject: RE: mysql 1gb memory limit? > > > Peter, > I have never heard of such a limit and I have been using it for a while. > > And --big-tables, which BTW, you can't easily search for on mysql.com, > because of the minimum 4 characters in full text indexing, says this: > > --big-tables > Allow large result sets by saving all temporary sets on file. This option > prevents most ``table full'' errors, but also slows down queries for which > in-memory tables would suffice. Since Version 3.23.2, MySQL is able to > handle large result sets automatically by using memory for small temporary > tables and switching to disk tables where necessary. > > So --big-tables, has nothing to do with any limit. > > Donny > > > -----Original Message----- > > From: Peter J Milanese [mailto:[EMAIL PROTECTED] > > Sent: Tuesday, March 09, 2004 7:32 AM > > To: Donny Simonton > > Cc: 'Jigal van Hemert'; [EMAIL PROTECTED] > > Subject: RE: mysql 1gb memory limit? > > > > Yes. There's a limit. > > > > Start mysql with --big-tables. I think there's a finer way of doing it, > > just don't remember what it was ;) > > > > P > > > > > > > > > > > > "Donny Simonton" <[EMAIL PROTECTED]> > > 03/09/2004 08:00 AM > > > > To: "'Jigal van Hemert'" <[EMAIL PROTECTED]>, > > <[EMAIL PROTECTED]> > > cc: > > Subject: RE: mysql 1gb memory limit? > > > > > > I've got a server with 24 gigs in it and it works just fine. About 3 > with > > 8 > > gigs and a few with 2 gigs. All running 4.1.1. And all of them run > > without > > any problems on Xeon's with Hyperthreading. > > > > Donny > > > > > -----Original Message----- > > > From: Jigal van Hemert [mailto:[EMAIL PROTECTED] > > > Sent: Tuesday, March 09, 2004 4:39 AM > > > To: [EMAIL PROTECTED] > > > Subject: mysql 1gb memory limit? > > > > > > In order to get the max performance from our servers we're reading > every > > > bit > > > we can lay our hands on about performance tuning. > > > In this document: > > > > > > http://www.phpconference.de/2003/slides/business_track/kneschke_webserver- > > > performance-tuning.pdf > > > (it's in German), it says on page 9 that MySQL 4.1.x on 32-bit Intel > > Linux > > > can only use 1GB!?!? > > > > > > Is this true? Anyway to overcome this limit? > > > > > > Regards, Jigal. > > > > > > > > > > > > -- > > > MySQL General Mailing List > > > For list archives: http://lists.mysql.com/mysql > > > To unsubscribe: > > > http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > > > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: > > http://lists.mysql.com/[EMAIL PROTECTED] > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
