Re: Running out of memory - memory leakage?
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
Running out of memory - memory leakage?
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? - Csongor - 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
Re: Running out of memory - memory leakage?
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 -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 26 days, processed 892,214,953 queries (387/sec. avg) - 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