OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
Re: run out of memory

From: Mark Leith (mleithmysql.com)
Date: Wed Aug 15 2007 - 11:20:39 CDT


Michael Dykman wrote:
> As most 64 bit libraries declare their 64-bitness clearly int heir
> names, I think that there is a very high chance that you have built
> yourself a 32-bit database in which case 4G is the limit of the known
> universe.
>
> On 8/14/07, Gu Lei(Tech) <leigusohu-inc.com> wrote:
>
>> try:
>> uname -a
>> to see if your OS is 64bit or not.
>>

Regardless of whether it is a 64bit or 32bit OS, if the binary is built
as 32bit, it will still be limited. 'file mysqld' will tell you whether
it is 32bit or 64bit.

And in practice, a 32bit binary is actually limited to around ~2.5-2.7G,
rather than a full 4G.

Cheers,

Mark

--
Mark Leith, Senior Support Engineer
MySQL AB, Worcester, England, www.mysql.com
Are you MySQL certified? www.mysql.com/certification

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql