Re: Memory Problems on G5/OSX/MySql4.0.17

[Brent Baisley]

Yes, MySQL is capable of using more than 2GB, but it still must obey 
the limits of the underlying OS. This means file sizes, memory 
allocation and whatever else. Have you heard of anybody allocating more 
the 2GB using OSX? I've heard of quite a bit more using Linux or other 
Unix flavors, but not OSX.

As for optimizing settings, you need to profile you work load. You may 
actually run into I/O, CPU or Network bottleneck before you hit a 
memory bottleneck. You need to run things and find where the bottleneck 
is to optimize performance.

On Jan 26, 2004, at 11:09 AM, Adam Goldstein wrote:

> Others on this list have claimed to be able to set over 3G, and my 
> failure is with even less than 2G (though, I am unsure if there is a 
> combination of other memory settings working together to create an 
> >2GB situation combined)
>
-- 
Brent Baisley
Systems Architect
Landover Associates, Inc.
Search & Advisory Services for Advanced Technology Environments
p: 212.759.6400/800.759.0577