ysql.com
Subject: Re: What is best open-source platform alternative to overcome
innodb 2Gb memory limit on Linux? FreeBSD?
Why not go AMD-64? Dual Opteron, with 8/16/32 gig of RAM? Get a 3ware
SATA drive, and run Gentoo for AMD-64. You can increase your innodb
buffer pool to use almost all that spac
Why not go AMD-64? Dual Opteron, with 8/16/32 gig of RAM? Get a 3ware
SATA drive, and run Gentoo for AMD-64. You can increase your innodb
buffer pool to use almost all that space. You can make your buffer pool
as large as the physical RAM in your machine can support. No 2.5 gig per
process, 4-g
Hi,
I am currently running a large database (around 20Gb) on a 32bit x86
Linux platform. Many of my larger data-crunching queries are disk-bound
due to the limitation described in the innodb configuration documentation:
*Warning:* On 32-bit GNU/Linux x86, you must be careful not to set
memor
On Thu, 10 Feb 2005 10:19:32 +0900, Batara Kesuma
<[EMAIL PROTECTED]> wrote:
> Hi Tobias,
>
> On Wed, 9 Feb 2005 14:48:16 +0100 (CET)
> Tobias Asplund <[EMAIL PROTECTED]> wrote:
>
> > > I try to install MySQL 4.1.9 (official RPM from mysql.com). My machine
> > > is running linux 2.6.9, and it has
Hi Tobias,
On Wed, 9 Feb 2005 14:48:16 +0100 (CET)
Tobias Asplund <[EMAIL PROTECTED]> wrote:
> > I try to install MySQL 4.1.9 (official RPM from mysql.com). My machine
> > is running linux 2.6.9, and it has 4GB of RAM. The problem is MySQL
> > won't start if I set innodb_buffer_pool_size to >= 2G
n't init databases
> 050209 20:41:18 [ERROR] Aborting
>
>
> I have also checked the archive and it looks like other people also
> having similar problem, but I couldn't find the answer. Is there any
> memory limit when it is run on linux? What can I do so MySQL can r
09 20:41:18 [ERROR] Can't init databases
050209 20:41:18 [ERROR] Aborting
I have also checked the archive and it looks like other people also
having similar problem, but I couldn't find the answer. Is there any
memory limit when it is run on linux? What can I do so MySQL can run
with >
On Tue, 13 Jul 2004 23:26:48 +0100, Marvin Wright
<[EMAIL PROTECTED]> wrote:
> Hi,
>
> I'm now running redhat AS 3.0 with kernel version 2.4 and have 8GB of RAM.
>
> If I set my innodb_buffer_pool to 2048M, it just will not start, I get this
> error.
>
> 040713 22:10:24 mysqld started
> 040713
b buffer
pool of > 2GB ??
Regards,
Marvin.
-Original Message-
From: Marc Slemko [mailto:[EMAIL PROTECTED]
Sent: 09 July 2004 20:15
To: Marvin Wright
Cc: [EMAIL PROTECTED]
Subject: Re: Linux 2GB Memory Limit
On Fri, 9 Jul 2004 15:46:37 +0100 , Marvin Wright
<[EMAIL PROTECTED]>
On Fri, 9 Jul 2004 15:46:37 +0100 , Marvin Wright
<[EMAIL PROTECTED]> wrote:
> Hi,
>
> Current Platform
> RH version is 7.3
> IBM Blade Server - 2 x Intel(R) Xeon(TM) CPU 3.20GHz
> 32 GB SCSI
> 4 GB Ram
>
> This is the platform we are moving to in a week or so
> RH Enterprise AS 2.1 or 3.0
>
ssage-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 09 July 2004 15:38
To: Kevin Jackson
Subject: RE: Linux 2GB Memory Limit
He is talking about file size.
--ja
On Fri, 9 Jul 2004, Kevin Jackson wrote:
> What version are you using?
> What platform are you on?
> How old is
I'll be able to have a much bigger InnoDB buffer
pool.
Thats good news.
Cheers.
Marvin.
-Original Message-
From: Kevin Jackson [mailto:[EMAIL PROTECTED]
Sent: 09 July 2004 15:28
To: [EMAIL PROTECTED]
Subject: RE: Linux 2GB Memory Limit
What version are you using?
What platform are y
Enterprise" distributions such as RHEL
(or their F/OSS rebuild equivalents like TAO Linux and White box Linux).
Kev
-Original Message-
From: Marvin Wright [mailto:[EMAIL PROTECTED]
Sent: 09 July 2004 14:07
To: [EMAIL PROTECTED]
Subject: Linux 2GB Memory Limit
Hi,
Is there any work around for
Hi,
Is there any work around for this yet where a process can not allocate more
than 2GB.
Can I upgrade my Redhat OS to any particular version ?
Many Thanks.
Marvin Wright
Flights Developer
Lastminute.com
[EMAIL PROTECTED]
+44 (0) 207 802 4543
__
4.1.x to that as well. We are
using Fedora core 1 and we don't have a memory limit at all.
Linux does have a 2gig memory limit per process or thread. But MySQL can
definitely use more than 1gig of memory.
If it couldn't then I wouldn't be using it.
I think what 1 GB refers to is that
koy [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, March 09, 2004 1:25 PM
> To: 'Donny Simonton'; 'Jigal van Hemert'; [EMAIL PROTECTED]
> Subject: RE: mysql 1gb memory limit?
>
> Hi Donny,
>
> What server hardware do you use to support 24G RAM over 32-bits limit?
&g
[mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 09, 2004 8:00 AM
To: 'Jigal van Hemert'; [EMAIL PROTECTED]
Subject: RE: mysql 1gb memory limit?
I've got a server with 24 gigs in it and it works just fine. About 3 with 8
gigs and a few with 2 gigs. All running 4.1.1. And all of them
. We are
using Fedora core 1 and we don't have a memory limit at all.
Linux does have a 2gig memory limit per process or thread. But MySQL can
definitely use more than 1gig of memory.
If it couldn't then I wouldn't be using it.
Donny
> -Original Message-
> From: Pet
To: "'Peter J Milanese'" <[EMAIL PROTECTED]>
cc: "'Jigal van Hemert'" <[EMAIL PROTECTED]>,
<[EMAIL PROTECTED]>
Subject:RE: mysql 1gb memory limit?
Peter,
I have never heard of such a limit and I have bee
sary.
So --big-tables, has nothing to do with any limit.
Donny
> -Original Message-
> From: Peter J Milanese [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, March 09, 2004 7:32 AM
> To: Donny Simonton
> Cc: 'Jigal van Hemert'; [EMAIL PROTECTED]
> Subject: RE: mysql
lt;[EMAIL PROTECTED]>,
<[EMAIL PROTECTED]>
cc:
Subject:RE: mysql 1gb memory limit?
I've got a server with 24 gigs in it and it works just fine. About 3 with
8
gigs and a few with 2 gigs. All running 4.1.1. And all of them run
without
any problems on Xeon's wi
ROTECTED]
> Sent: Tuesday, March 09, 2004 4:39 AM
> To: [EMAIL PROTECTED]
> Subject: mysql 1gb memory limit?
>
> In order to get the max performance from our servers we're reading every
> bit
> we can lay our hands on about performance tuning.
> In this document:
> http:/
In order to get the max performance from our servers we're reading every bit
we can lay our hands on about performance tuning.
In this document:
http://www.phpconference.de/2003/slides/business_track/kneschke_webserver-performance-tuning.pdf
(it's in German), it says on page 9 that MySQL 4.1.x on 3
I've read a lot about the 32-bit/malloc-induced 2GB memory limit on
MySQL for the innodb_buffer_pool_size. Does this apply to HEAP table
size as well? In other words, if I have enough RAM can I set
max_heap_table_size > 2 GB and have a > 2GB heap table sitting in
memory?
I'
> -Original Message-
> From: Dicky Wahyu Purnomo [mailto:[EMAIL PROTECTED]]
> Subject: Memory Limit
> And what is the calculation for the memory also
The formula you want is (this does not account for InnoDB buffers either):
key_buffer_size + (record_buffer +
ybuffer : 1024M
- sortbuffer : 12M
- recordbuffer : 12M
and with this configuration my server can't handle more than 1200 concurrent threads.
The error message said "Can't create more threads ... error 11 ... memory limit"
And my database condition is :
- average number of reco
On Wed, Feb 06, 2002 at 02:57:51PM +0200, Sinisa Milivojevic wrote:
> Franklin, Kevin writes:
> > We are running an extremely large instance of mysql version 3.23.46 on
> > Solaris 2.8. We are attempting to use a software version compiled 64 bit
> > and have been experiencing memory related serve
hi!
> "Sinisa" == Sinisa Milivojevic <[EMAIL PROTECTED]> writes:
Sinisa> Albert Chin writes:
>>
>> $ grep SIZEOF_LONG config.h
>> #define SIZEOF_LONG 8
>> #define SIZEOF_LONG_LONG 8
>>
>> $ grep SIZEOF_LONG incldue/my_config.h
>> #define SIZEOF_LONG 8
>> #define SIZEOF_LONG_LONG 8
>>
>>
On Wed, Feb 06, 2002 at 07:17:13PM +0200, Sinisa Milivojevic wrote:
> Albert Chin writes:
> >
> > $ grep SIZEOF_LONG config.h
> > #define SIZEOF_LONG 8
> > #define SIZEOF_LONG_LONG 8
> >
> > $ grep SIZEOF_LONG incldue/my_config.h
> > #define SIZEOF_LONG 8
> > #define SIZEOF_LONG_LONG 8
> >
> >
Albert Chin writes:
>
> Ok. Guess we'll wait for a fix. Any idea when a fix for MySQL will be
> available?
>
> --
> albert chin ([EMAIL PROTECTED])
>
Just look into Changelog's of the versions that come out.
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa M
On Wed, Feb 06, 2002 at 06:12:22PM +0200, Sinisa Milivojevic wrote:
> Albert Chin writes:
> >
> > MySQL 3.23.46 was built with the Sun C++ compiler:
> > $ CC -V
> > CC: Sun WorkShop 6 update 2 C++ 5.3 Patch 111685-03 2001/10/19
> >
> > It was built as follows:
> > CC=cc CFLAGS="-mr -Qn -xs
Albert Chin writes:
> On Wed, Feb 06, 2002 at 07:17:13PM +0200, Sinisa Milivojevic wrote:
> Yes, SIZEOF_INT is 4:
> $ grep SIZEOF_INT config.h
> #define SIZEOF_INT 4
> $ grep SIZEOF_INT include/my_config.h
> #define SIZEOF_INT 4
>
> However, according to
>
>http://docs.sun.com/ab2/coll.4
Albert Chin writes:
> On Wed, Feb 06, 2002 at 07:17:13PM +0200, Sinisa Milivojevic wrote:
>
> Yes, SIZEOF_INT is 4:
> $ grep SIZEOF_INT config.h
> #define SIZEOF_INT 4
> $ grep SIZEOF_INT include/my_config.h
> #define SIZEOF_INT 4
>
> --
> albert chin ([EMAIL PROTECTED])
>
We shall ha
Albert Chin writes:
>
> $ grep SIZEOF_LONG config.h
> #define SIZEOF_LONG 8
> #define SIZEOF_LONG_LONG 8
>
> $ grep SIZEOF_LONG incldue/my_config.h
> #define SIZEOF_LONG 8
> #define SIZEOF_LONG_LONG 8
>
> --
> albert chin ([EMAIL PROTECTED])
>
If SIZEOF_INT is 4, then it could be our bug.
P
On Wed, Feb 06, 2002 at 08:04:23PM +0200, Sinisa Milivojevic wrote:
> Albert Chin writes:
> > On Wed, Feb 06, 2002 at 07:17:13PM +0200, Sinisa Milivojevic wrote:
> > Yes, SIZEOF_INT is 4:
> > $ grep SIZEOF_INT config.h
> > #define SIZEOF_INT 4
> > $ grep SIZEOF_INT include/my_config.h
> >
hi!
> "Sinisa" == Sinisa Milivojevic <[EMAIL PROTECTED]> writes:
Sinisa> Albert Chin writes:
>>
>> $ grep SIZEOF_LONG config.h
>> #define SIZEOF_LONG 8
>> #define SIZEOF_LONG_LONG 8
>>
>> $ grep SIZEOF_LONG incldue/my_config.h
>> #define SIZEOF_LONG 8
>> #define SIZEOF_LONG_LONG 8
>>
>>
Albert Chin writes:
>
> Ok. Guess we'll wait for a fix. Any idea when a fix for MySQL will be
> available?
>
> --
> albert chin ([EMAIL PROTECTED])
>
Just look into Changelog's of the versions that come out.
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa M
On Wed, Feb 06, 2002 at 08:04:23PM +0200, Sinisa Milivojevic wrote:
> Albert Chin writes:
> > On Wed, Feb 06, 2002 at 07:17:13PM +0200, Sinisa Milivojevic wrote:
> > Yes, SIZEOF_INT is 4:
> > $ grep SIZEOF_INT config.h
> > #define SIZEOF_INT 4
> > $ grep SIZEOF_INT include/my_config.h
> >
On Wed, Feb 06, 2002 at 07:17:13PM +0200, Sinisa Milivojevic wrote:
> Albert Chin writes:
> >
> > $ grep SIZEOF_LONG config.h
> > #define SIZEOF_LONG 8
> > #define SIZEOF_LONG_LONG 8
> >
> > $ grep SIZEOF_LONG incldue/my_config.h
> > #define SIZEOF_LONG 8
> > #define SIZEOF_LONG_LONG 8
> >
> >
Albert Chin writes:
> On Wed, Feb 06, 2002 at 07:17:13PM +0200, Sinisa Milivojevic wrote:
> Yes, SIZEOF_INT is 4:
> $ grep SIZEOF_INT config.h
> #define SIZEOF_INT 4
> $ grep SIZEOF_INT include/my_config.h
> #define SIZEOF_INT 4
>
> However, according to
>
>http://docs.sun.com/ab2/coll.4
Albert Chin writes:
> On Wed, Feb 06, 2002 at 07:17:13PM +0200, Sinisa Milivojevic wrote:
>
> Yes, SIZEOF_INT is 4:
> $ grep SIZEOF_INT config.h
> #define SIZEOF_INT 4
> $ grep SIZEOF_INT include/my_config.h
> #define SIZEOF_INT 4
>
> --
> albert chin ([EMAIL PROTECTED])
>
We shall ha
Albert Chin writes:
>
> $ grep SIZEOF_LONG config.h
> #define SIZEOF_LONG 8
> #define SIZEOF_LONG_LONG 8
>
> $ grep SIZEOF_LONG incldue/my_config.h
> #define SIZEOF_LONG 8
> #define SIZEOF_LONG_LONG 8
>
> --
> albert chin ([EMAIL PROTECTED])
>
If SIZEOF_INT is 4, then it could be our bug.
P
On Wed, Feb 06, 2002 at 06:12:22PM +0200, Sinisa Milivojevic wrote:
> Albert Chin writes:
> >
> > MySQL 3.23.46 was built with the Sun C++ compiler:
> > $ CC -V
> > CC: Sun WorkShop 6 update 2 C++ 5.3 Patch 111685-03 2001/10/19
> >
> > It was built as follows:
> > CC=cc CFLAGS="-mr -Qn -xs
Albert Chin writes:
>
> MySQL 3.23.46 was built with the Sun C++ compiler:
> $ CC -V
> CC: Sun WorkShop 6 update 2 C++ 5.3 Patch 111685-03 2001/10/19
>
> It was built as follows:
> CC=cc CFLAGS="-mr -Qn -xstrconst -xO2 -xtarget=generic -xarch=v9" \
> CXX=CC CXXFLAGS="-xO2 -xtarget=generi
On Wed, Feb 06, 2002 at 02:57:51PM +0200, Sinisa Milivojevic wrote:
> Franklin, Kevin writes:
> > We are running an extremely large instance of mysql version 3.23.46 on
> > Solaris 2.8. We are attempting to use a software version compiled 64 bit
> > and have been experiencing memory related serve
Franklin, Kevin writes:
> We are running an extremely large instance of mysql version 3.23.46 on
> Solaris 2.8. We are attempting to use a software version compiled 64 bit
> and have been experiencing memory related server crashes.
>
> The behavior suggests that we are still unable to use more
We are running an extremely large instance of mysql version 3.23.46 on
Solaris 2.8. We are attempting to use a software version compiled 64 bit
and have been experiencing memory related server crashes.
The behavior suggests that we are still unable to use more than 4G of
memory.
If the server
hing a total memory usage of around 4
>>GB
>>
>
> I am surprised that it responds at all after it uses up RAM and starts to
> swap. You must have a good disk subsystem.
>
>
>>Here is the output from the error log. Of particular interest to us is
>>the ne
is the output from the error log. Of particular interest to us is
> the negative key_buffer_size quoted. The same value (-4096) appears
> with each crash. Is there some sort of memory limit imposed on the
> server or do you have suggestions for debugging this problem?
I think that you rolled
the
negative key_buffer_size quoted. The same value (-4096) appears with each
crash. Is there some sort of memory limit imposed on the server or do you
have suggestions for debugging this problem?
Thank you,
Kevin Franklin
020117 18:19:58 Out of memory; Check if mysqld or some other process
50 matches
Mail list logo
