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 32 or 64 bit?
Thanks
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:
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
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
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
@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 binary is actually limited to around ~2.5-2.7G,
rather than a full 4G.
What are the practical memory limits
: 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 full 4G.
What are the practical memory limits for 64-bit binaries? I have heard
that MySQL'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 = 2560M
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
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 CPU
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 32 or 64
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_id and f.id
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
:
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
. 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:
Hello,
I have this error (2008 : MySQL client run out of memory) performing
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:
Hello,
I have this error (2008 : MySQL client run out of memory) performing
a request in a PHP script.
However that request works
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
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 mysql/mysql.h
#include s
18 matches
Mail list logo