Re: run out of memory

2007-08-15 Thread B. Keith Murphy
Lei(Tech)" <[EMAIL PROTECTED]>, "Jen mlists" <[EMAIL PROTECTED]>, mysql@lists.mysql.com Sent: Wednesday, August 15, 2007 12:51:19 PM (GMT-0500) America/New_York Subject: Re: run out of memory Baron Schwartz wrote: > Mark Leith wrote: >> And in practice, a 32bit

Re: run out of memory

2007-08-15 Thread Mark Leith
Baron Schwartz wrote: Mark Leith wrote: And in practice, a 32bit binary is actually limited to around ~2.5-2.7G, rather than a full 4G. What are the practical memory limits for 64-bit binaries? I have heard that MySQL's indexing code is only 32-bit safe anyway, and I assume for example the

Re: run out of memory

2007-08-15 Thread B. Keith Murphy
uot;Jen mlists" <[EMAIL PROTECTED]>, mysql@lists.mysql.com Sent: Wednesday, August 15, 2007 12:27:14 PM (GMT-0500) America/New_York Subject: Re: run out of memory Mark Leith wrote: > And in practice, a 32bit binary is actually limited to around ~2.5-2.7G, > rather than a

Re: run out of memory

2007-08-15 Thread Mark Leith
Baron Schwartz wrote: Mark Leith wrote: And in practice, a 32bit binary is actually limited to around ~2.5-2.7G, rather than a full 4G. What are the practical memory limits for 64-bit binaries? I have heard that MySQL's indexing code is only 32-bit safe anyway, and I assume for example the

Re: run out of memory

2007-08-15 Thread Baron Schwartz
Mark Leith wrote: And in practice, a 32bit binary is actually limited to around ~2.5-2.7G, rather than a full 4G. What are the practical memory limits for 64-bit binaries? I have heard that MySQL's indexing code is only 32-bit safe anyway, and I assume for example the MyISAM key buffers can

Re: run out of memory

2007-08-15 Thread Mark Leith
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) <[EMAIL PROTECTED]> wrote

Re: run out of memory

2007-08-15 Thread Michael Dykman
> to see if your OS is 64bit or not. > > Gu Lei > > -原始邮件- > 发件人: Jen mlists [mailto:[EMAIL PROTECTED] > 发送时间: 2007年8月15日 9:46 > 收件人: mysql@lists.mysql.com > 主题: Re: run out of memory > > > 2007/8/15, B. Keith Murphy <[EMAIL PROTECTED]>: > >

re: run out of memory

2007-08-14 Thread Gu Lei(Tech)
try: uname -a to see if your OS is 64bit or not. Gu Lei -原始邮件- 发件人: Jen mlists [mailto:[EMAIL PROTECTED] 发送时间: 2007年8月15日 9:46 收件人: mysql@lists.mysql.com 主题: Re: run out of memory 2007/8/15, B. Keith Murphy <[EMAIL PROTECTED]>: > What operating system are you running and is it

Re: run out of memory

2007-08-14 Thread Jen mlists
2007/8/15, B. Keith Murphy <[EMAIL PROTECTED]>: > What operating system are you running and is it 32 or 64 bit? > Thanks for the reply. Here is my OS info: $ uname -r 2.6.9-42.ELsmp $ cat /etc/redhat-release Red Hat Enterprise Linux AS release 4 (Nahant Update 4) Yes I think it's 64bit OS. The

Re: run out of memory

2007-08-14 Thread B. Keith Murphy
What operating system are you running and is it 32 or 64 bit? Keith - Original Message - From: "Jen mlists" <[EMAIL PROTECTED]> To: mysql@lists.mysql.com Sent: Tuesday, August 14, 2007 2:35:34 AM (GMT-0500) America/New_York Subject: run out of memory Hello, My server box has 8G m