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]
