Re: InnoDB can't use system's RAM as specified

2003-08-26 Thread Misao
I'd have to say that things look fine in that regard. core file size (blocks) 0 data seg size (kbytes) unlimited file size (blocks) unlimited max locked memory (kbytes) unlimited max memory size (kbytes)unlimited open files 1024 pipe size (512 bytes) 8

Re: InnoDB can't use system's RAM as specified

2003-08-26 Thread Heikki Tuuri
Hi! We have only 2 GB of RAM in our SuSE Linux server, and I can allocate 1400 MB to the buffer pool. Have you checked what ulimit -a says for the user running mysqld? Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Foreign keys, transactions, and row level locking for MySQL Inno