On Mon, Sep 10, 2001 at 02:28:05PM +0300, Heikki Tuuri wrote:
> 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?
Here's my.cnf:
[mysqld]
innodb_data_file_path = data/data1:2000M;data/data2:2000M
innodb_data_home_dir = /servers/mysql/
set-variable = innodb_mirrored_log_groups=1
innodb_log_group_home_dir = /servers/mysql/data/logs/
set-variable = innodb_log_files_in_group=3
set-variable = innodb_log_file_size=50M
set-variable = innodb_log_buffer_size=20M
innodb_flush_log_at_trx_commit=0
innodb_log_arch_dir = /servers/mysql/data/logs/
innodb_log_archive=0
set-variable = innodb_buffer_pool_size=50M
set-variable = innodb_additional_mem_pool_size=20M
set-variable = innodb_file_io_threads=4
set-variable = innodb_lock_wait_timeout=50
innodb_flush_method=O_DSYNC
This problem arose before the installation of PostGres. Even then I could not reserve
more than 50M for innodb_buffer_pool_size.
The only thing that is also running on the machine is a HTTP server that uses at most
60M of mem.
>
> 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 sharedbuffers cached
> >Mem: 20967202094180 2540 01073620 786400
> >-/+ buffers/cache: 2341601862560
> >Swap: 1052248 32921048956
> >
> >
> >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
> &