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]
