Re: Running out of memory - memory leakage?

[Csongor Fagyal]

Jeremy Zawodny wrote:

On Fri, Jan 10, 2003 at 01:59:07PM +0100, Csongor Fagyal wrote:

Hi,

I have a RedHat 8 box /w MySQL 3.23.54, /w 640M RAM.

It looks like there are some sort of a "memory leakage" somewhere in the system, because slowly (in a day or two) I run out of memory. Even SWAP space gets used up at the end (slowly but steadily, fluctuating). If I restart MySQL, nothing happens. If I restart the services using MySQL (e.g. Apache), nothing happens. But if restart BOTH of them (MySQL AND Apache) suddenly my memory is back again and the SWAP is reclaimed also.

How can I find out where my memory goes? Any ideas?

Without seeing your my.cnf file, it is dificult to speculate on the
cause.

Jeremy

Hi,

I have two MySQL daemons running, one on port 3306 (mysql), one on port 3307 (mysql-user). Here are the configs:
my.cnf:

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
skip-innodb
set-variable = table_cache=256
set-variable = key_buffer=32M

set-variable = max_allowed_packet=1M
set-variable = table_cache=256
set-variable = sort_buffer=1M
set-variable = record_buffer=1M
set-variable = myisam_sort_buffer_size=16M
set-variable = thread_cache=4
log=/var/log/mysqld-query.log
log-slow-queries=/var/log/mysqld-slow.log

[mysql.server]
user=mysql
basedir=/var/lib

[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

--------------------------------
my-user.cnf:

[client]
port=3307
socket=/var/lib/mysql-user/mysql-user.sock

[mysqld]
datadir=/var/lib/mysql-user
socket=/var/lib/mysql-user/mysql-user.sock
pid-file=/var/run/mysqld-user/mysqld-user.pid
port=3307
skip-innodb
#max_connections=300
set-variable = table_cache=256
set-variable = key_buffer=32M
set-variable = max_allowed_packet=1M
set-variable = table_cache=256
set-variable = sort_buffer=1M
set-variable = record_buffer=1M
set-variable = myisam_sort_buffer_size=16M
set-variable = thread_cache=4
log=/var/log/mysqld_user-query.log
log-slow-queries=/var/log/mysqld_user-slow.log

[mysql.server]
user=mysql-user
basedir=/var/lib

[safe_mysqld]
user=mysql-user
err-log=/var/log/mysqld-user.log
pid-file=/var/run/mysqld-user/mysqld-user.pid
port=3307
socket=/var/lib/mysql-user/mysql-user.sock

[mysql_install_db]
err-log=/var/log/mysqld-user.log
pid-file=/var/run/mysqld-user/mysqld-user.pid
port=3307
socket=/var/lib/mysql-user/mysql-user.sock


- Cs.


---------------------------------------------------------------------
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