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
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
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
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
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
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
> 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]>:
> >
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
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
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 s
Hello,
My server box has 8G memory and 8CPU (DELL Standard Server),when I
configure Mysql server (5.0.45) using large memory,mysqld would say it
run out of memory.
For example,when this line appear in my.cnf,
key_buffer = 4000M
mysqld can't startup.When I change it to,
key_buffer =
Hello,
I use PHP 4.0.6 with mySQL 3.23.40 and I have the error
2008 (client run out of memory) performing this query :
select i2f.item_id, i2f.value, f.id from features as f, item2feature as i2f,
items as i where i.scat_id = '244d713abba5f2ffb8d0ba8c858111ef' and i.id =
i2f.item_i
Hello,
I tried with unbuffered queries and It doesn't solve the problem at all
I have an weird error performing "select id from categories where name =
'Hifi'".
The error is now : '0 : ' (nothing).
There's an error but it is not defined ?!?
Note that only the crashing query is unbuffer
> ini_set("memory_limit", "16M");
>>
>> in your script. Otherwise, it may be a loop that keeps allocating
>> memory until it crahes. It this is the case, you won't get it
>> through allocating more memory.
>>
>> Patrice Garbe schrieb am D
memory_limit", "16M");
>
> in your script. Otherwise, it may be a loop that keeps allocating
> memory until it crahes. It this is the case, you won't get it
> through allocating more memory.
>
> Patrice Garbe schrieb am Donnerstag, 9. August 2001, 12:43:42:
> >
ag, 9. August 2001, 12:43:42:
> Hello,
> I have this error (2008 : MySQL client run out of memory) performing
> a request in a PHP script.
> However that request works perfectly under phpMyAdmin !
> I tried to do a lot of mysql_free_result() in my script (because there are a
>
Hello,
I have this error (2008 : MySQL client run out of memory) performing
a request in a PHP script.
However that request works perfectly under phpMyAdmin !
I tried to do a lot of mysql_free_result() in my script (because there are a
lot of requests) but I doesn't work and I think
Rastislav Rihak writes:
> >Description:
> There is a bug (or undocumented feature?) in libmysqlclient - if
> function "strend()" is defined in client code, client will fail
> to connect to database with "MySQL client run out of memory"
&
>Description:
There is a bug (or undocumented feature?) in libmysqlclient - if
function "strend()" is defined in client code, client will fail
to connect to database with "MySQL client run out of memory"
message.
>How-To-Repeat:
#include
#include
19 matches
Mail list logo
