Re: MySQL memory problem on AIX 4.3.2

Try putting the following before the mysqld call but before your ulimit calls - export LDR_CNTRL='MAXDATA=0x8000' Also try setting ulimit -m unlimited and ulimit -s unlimited. Hopefully this helps. Scott Pippin [EMAIL PROTECTED]

MySQL memory problem on AIX 4.3.2

Hi all, Now I'm facing a big problem and see if anyone know how to solve it. I'm using RS6000 AIX 4.3.2 CPU*2 1G RAM with HA. And DB is MySQL 4.0.12-max. Here is the content of my.cnf. [client] #password = your_password port= 3306 socket = /tmp/mysql.sock # Here

MySQL memory problem

Hi all, I am facing a big problem and see if anyone know how to solve it. I am using freebsd 4.4 with mysql-4.0.12. The database server has 2G RAM in it. Here is the content of my.cnf. [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock port=3306 set-variable = thread_cache_size=550

Re: MySQL memory problem

On Tue, Jun 10, 2003 at 07:37:19PM +0800, Kaming wrote: Then after the checking, the table seems being fixed and then I start the MySQL again. I can run query in that table after that. Then suddenly I saw this error message keeps coming in the mysqld.log Error Message: Out of memory;

Re: MySQL memory problem

Hi Jeremy, here is the value when I typed 'ulimit -a'. core file size (blocks) unlimited data seg size (kbytes) 524288 file size (blocks) unlimited max locked memory (kbytes) unlimited max memory size (kbytes)unlimited open files 32768 pipe size (512

Re: MySQL memory problem

On Wed, Jun 11, 2003 at 12:22:58PM +0800, Kaming wrote: Jeremy Zawodny wrote: On Tue, Jun 10, 2003 at 07:37:19PM +0800, Kaming wrote: Then after the checking, the table seems being fixed and then I start the MySQL again. I can run query in that table after that. Then suddenly I

Mysql memory problem

Hi guys, I have a quad Xeon 550 server, 4gb RAM, with a RH Linux 6.2 + patches, kernel 2.4.8 and mysql Ver 11.17 Distrib 3.23.49a. After the start, mysql starts to grow memory usage. It grows until it consumes all machine memory. After a restart it uses only 17Mb of memory, 18

Mysql memory problem

Hi guys, I have a quad Xeon 550 server, 4gb RAM, with a RH Linux 6.2 + patches, kernel 2.4.8 and mysql Ver 11.17 Distrib 3.23.49a. After the start, mysql starts to grow memory usage. It grows until it consumes all machine memory. After a restart it uses only 17Mb of memory, 18

Mysql memory problem

Dear all, i used mysql on linux 7.1. And i discovered mysql not free the memory . pls advise !1 1:24am up 1 day, 10:11, 2 users, load average: 1.13, 1.26, 1.31 65 processes: 63 sleeping, 2 running, 0 zombie, 0 stopped CPU0 states: 4.2% user, 1.3% system, 0.0% nice, 93.3% idle CPU1

Re: Mysql memory problem

Hi. Have a look at your my.cnf (and the according manual entries). There you can specify how much memory MySQL is allowed to use. MySQL doesn't release memory it's allowed to use for caching. Bye, Benjamin. PS: There is nothing such as linux 7.1. Linux (the kernel) exists in