On 9 Jun 2009, at 22:43, Daniel Ouellet wrote:
If I may asked, why would you really want to get a 2GB buffer?
The app generates a lot of database traffic, as well as doing some
fairly large transactional queries, hence the need for InnoDB. MySQL
queries keep failing with lack of memory
On Tue, Jun 9, 2009 at 2:50 PM, Ted Unangstted.unan...@gmail.com wrote:
The short answer is that you can't use more than 1GB of memory.
Out of curiosity, what's the long answer?
On Wed, Jun 10, 2009 at 08:00:42AM +0100, Gaby Vanhegan wrote:
On 9 Jun 2009, at 22:43, Daniel Ouellet wrote:
If I may asked, why would you really want to get a 2GB buffer?
The app generates a lot of database traffic, as well as doing some
fairly large transactional queries, hence the
On Wed, Jun 10, 2009 at 12:18:07AM -0700, Johan Beisser wrote:
On Tue, Jun 9, 2009 at 2:50 PM, Ted Unangstted.unan...@gmail.com wrote:
The short answer is that you can't use more than 1GB of memory.
Out of curiosity, what's the long answer?
Virtual memory layout limits this. There needs
I'm having an annoying time trying to make MySQL run with a large
amount of buffer memory. I have 4Gb of RAM and 8Gb of swap and I need
to increase the data size limit for the _mysql login class. Currently
it's set to unlimited but it doesn't seem to be coming through to the
_mysql login
Gaby Vanhegan wrote:
I'm having an annoying time trying to make MySQL run with a large amount
of buffer memory. I have 4Gb of RAM and 8Gb of swap and I need to
increase the data size limit for the _mysql login class. Currently it's
set to unlimited but it doesn't seem to be coming through to
On Tue, Jun 9, 2009 at 4:41 PM, Gaby Vanhegan g...@vanhegan.net wrote:
I'm having an annoying time trying to make MySQL run with a large amount of
buffer memory. I have 4Gb of RAM and 8Gb of swap and I need to increase
the
data size limit for the _mysql login class. Currently it's set to
Thanks for getting back to me so swiftly, I've been banging my head
against this for a couple of days now... :(
On 9 Jun 2009, at 22:06, Daniel Ouellet wrote:
Gaby Vanhegan wrote:
I'm having an annoying time trying to make MySQL run with a large
amount
of buffer memory. I have 4Gb of RAM
If the machine has mare than enough physical RAM and tons of swap, is
there no way to configure MySQL to hold a 2Gb buffer in memory? I
really want to avoid building a custom kernel and it feels like I should
be able to get this working using login.conf, ulimit and sysctl
settings. Or is
On Tue, Jun 9, 2009 at 5:23 PM, Gaby Vanhegan g...@vanhegan.net wrote:
On 9 Jun 2009, at 22:07, Ted Unangst wrote:
There are hard limits that you can't exceed.
If the machine has mare than enough physical RAM and tons of swap, is there
no way to configure MySQL to hold a 2Gb buffer in
10 matches
Mail list logo