Nuno,
I noticed a similar unexplained restriction
on our Linux 2.4. We have 512 MB physical memory,
no swap partition, and for some reason I cannot
malloc more than 256 MB. The Unix errno just says
'Cannot allocate memory'.
On our other machine with 900 MB RAM and 512 MB swap
I can malloc 900 MB.
What is your my.cnf like? Is it possible that you
have allocated so much memory to PostgreSQL, MyISAM,
and other programs that the 2 GB or 3 GB you have is
almost totally used?
Regards,
Heikki
At 10:55 AM 9/10/01 +0100, you wrote:
>On Fri, Sep 07, 2001 at 08:47:16PM +0300, Heikki Tuuri wrote:
>> Nuno,
>>
>> what does
>>
>> ulimit -a
>>
>> say (assuming you are running on Unix)?
>> ulimit tells the limits set for the user.
>> I think there are also hard limits decided
>> at kernel compile time.
>
>core file size (blocks) 0
>data seg size (kbytes) unlimited
>file size (blocks) unlimited
>max memory size (kbytes) unlimited
>stack size (kbytes) 8192
>cpu time (seconds) unlimited
>max user processes 256
>pipe size (512 bytes) 8
>open files 1024
>virtual memory (kbytes) 2105343
>
>I'm running Linux.
>
>>
>> What does
>>
>> free
>>
>> say?
>>
>
> total used free shared buffers cached
>Mem: 2096720 2094180 2540 0 1073620 786400
>-/+ buffers/cache: 234160 1862560
>Swap: 1052248 3292 1048956
>
>
>But I'm running two SQL servers (MySQL and PostGres) and I'm running some
scripts. Apart from that, the machine is totally dedicated to SQL stuff.
>When installing InnoDB I should have most of the memory available.
>
>
>> Regards,
>>
>> Heikki
>> http://www.innodb.com
>>
>> >Nuno Dias wrote:
>> >
>> >> I installed mysql with innodb support on a machine with 2G of RAM.>
>> >> The manual recommends that one should set innodb_buffer_pool_size in
>> my.cnf to
>> >up to 80% of the physical memory available.
>> >
>> >> However, if I set a value above 50M!!! I get this error:
>> >
>> >> Innobase: Fatal error: cannot allocate memory!
>> >> Innobase: Cannot continue operation!
>> >> Innobase: Check if you can increase the swap file of your
>> >> Innobase: operating system.
>> > 010906 15:31:27 mysqld ended
>> >
>> >> Anyone as any clue about this?
>> > > --> Nuno Dias <[EMAIL PROTECTED]>
>> >> Novis - Dir. Rede - ISP <http://www.novis.pt/>
>> >> Ed. Atrium Saldanha - Pça. Dq. de Saldanha, 1, 7o / 1050 - 094 Lisboa
>> >> tel: +351 21 0104437 - fax: +351 21 0104301>
>> >> I may not be able to walk, but I drive from a sitting position.
>>
>>
>>
>> ---------------------------------------------------------------------
>> Before posting, please check:
>> http://www.mysql.com/manual.php (the manual)
>> http://lists.mysql.com/ (the list archive)
>>
>> To request this thread, e-mail <[EMAIL PROTECTED]>
>> To unsubscribe, e-mail <[EMAIL PROTECTED]>
>> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>>
>
>--
>Nuno Dias <[EMAIL PROTECTED]>
>Novis - Dir. Rede - ISP <http://www.novis.pt/>
>Ed. Atrium Saldanha - Pça. Dq. de Saldanha, 1, 7o / 1050 - 094 Lisboa
>tel: +351 21 0104437 - fax: +351 21 0104301
>
>
>Brandy Davis, an outfielder and teammate of mine with the Pittsburgh Pirates,
>is my choice for team captain. Cincinnatti was beating us 3-1, and I led
>off the bottom of the eighth with a walk. The next hitter banged a hard
>single to right field. Feeling the wind at my back, I rounded second and
>kept going, sliding safely into third base.
> With runners at first and third, and home-run hitter Ralph Kiner at
>bat, our manager put in the fast Brandy Davis to run for the player at first.
>Even with Kiner hitting and a change to win the game with a home run, Brandy
>took off for second and made it. Now we had runners at second and third.
> I'm standing at third, knowing I'm not going anywhere, and see Brandy
>start to take a lead. All of a sudden, here he comes. He makes a great slide
>into third, and I scream, "Brandy, where are you going?" He looks up, and
>shouts, "Back to second if I can make it."
> -- Joe Garagiola, "It's Anybody's Ball Game"
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php