On Wed, Jun 10, 2009 at 12:18:07AM -0700, Johan Beisser wrote:
> On Tue, Jun 9, 2009 at 2:50 PM, Ted Unangst 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 to be space for W
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 t
On Tue, Jun 9, 2009 at 2:50 PM, Ted Unangst wrote:
> The short answer is that you can't use more than 1GB of memory.
Out of curiosity, what's the long answer?
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 er
On Tue, Jun 9, 2009 at 5:23 PM, Gaby Vanhegan 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 memory? I really
> 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 i
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
On Tue, Jun 9, 2009 at 4:41 PM, 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
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
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
10 matches
Mail list logo
