Hello:
I am having a strange problem that it appears that no one else is
having. I am running Slackware Linux with a 2.4.18 kernel, and MySQL
3.23.52-log. It is running on a dual CPU system with 860M ram.
The problem is that mysql seems to reserve a lot of ram reguardless
of what mysql is actually doing. Here is a top output
last pid: 26551; load averages: 0.03, 0.05, 0.04 13:16:38
93 processes: 1 running, 91 sleeping, 1 stopped
CPU states: 0.2% user, 0.0% nice, 0.6% system, 99.2% idle
Memory: 858M used, 22M free, 17M buf Swap: 7880K used, 879M free
PID USERNAME PRI NICE SIZE RES STATE TIME WCPU CPU COMMAND
10631 mysql 13 0 270M 260M sleep 7:50 0.40% 0.40% mysqld
10612 mysql 9 0 270M 260M sleep 21:52 0.00% 0.00% mysqld
20693 mysql 9 0 270M 260M sleep 13:42 0.04% 0.00% mysqld
23398 mysql 9 0 270M 260M sleep 9:39 0.00% 0.00% mysqld
10192 mysql 9 0 270M 260M sleep 8:52 0.17% 0.00% mysqld
23272 mysql 9 0 270M 260M sleep 5:58 0.17% 0.00% mysqld
10632 mysql 10 0 270M 260M sleep 2:26 0.05% 0.00% mysqld
10214 mysql 9 0 270M 260M sleep 2:26 0.00% 0.00% mysqld
10252 mysql 9 0 270M 260M sleep 2:10 0.01% 0.00% mysqld
10679 mysql 9 0 270M 260M sleep 1:53 0.00% 0.00% mysqld
10229 mysql 9 0 270M 260M sleep 1:38 0.01% 0.00% mysqld
21152 mysql 9 0 270M 260M sleep 1:11 0.00% 0.00% mysqld
23271 mysql 9 0 270M 260M sleep 0:06 0.00% 0.00% mysqld
10191 mysql 9 0 270M 260M sleep 0:04 0.00% 0.00% mysqld
10189 mysql 9 0 270M 260M sleep 0:03 0.00% 0.00% mysqld
Why is mysql size showing as 270M? There is nothing going on that
looks like it is useing lot's of ram. Is this something to worry
about?
Here is a processlist taken at the same time of the top output.
mysql> show processlist;
+-------+-------------+-----------------------+------------+-------------+--------+---------------------------------------------+------------------+
| Id | User | Host | db | Command | Time |
|State | Info |
+-------+-------------+-----------------------+------------+-------------+--------+---------------------------------------------+------------------+
| 470 | replication | cia.mydomain.com | NULL | Binlog Dump | 405991 | Slave
|connection: waiting for binlog update | NULL |
| 2381 | replication | 63.133.37.2 | NULL | Binlog Dump | 355071 |
|Slave connection: waiting for binlog update | NULL |
| 13205 | radiusd | localhost | radiusd_db | Sleep | 5 |
| | NULL |
| 15236 | radiusd | 63.133.37.2 | radiusd_db | Sleep | 2598 |
| | NULL |
| 15502 | root | localhost | radiusd_db | Query | 0 |
|NULL | show processlist |
| 15522 | radiusd | 226.230.251.22 | radiusd_db | Sleep | 22 |
| | NULL |
| 15524 | radiusd | 63.133.37.2 | radiusd_db | Sleep | 4 |
| | NULL |
+-------+-------------+-----------------------+------------+-------------+--------+---------------------------------------------+------------------+
This is a snip of my /etc/my.cnf
# The following options will be passed to all MySQL clients
[client]
#password = your_password
port = 3306
socket = /tmp/mysql.sock
# Here follows entries for some specific programs
# The MySQL server
[mysqld]
port = 3306
socket = /tmp/mysql.sock
skip-locking
set-variable = net_buffer_length=512K
set-variable = key_buffer=256M
set-variable = max_allowed_packet=1M
set-variable = table_cache=512
set-variable = sort_buffer=2M
set-variable = record_buffer=2M
set-variable = thread_cache=8
set-variable = max_connections=300
set-variable = thread_concurrency=4
set-variable = myisam_sort_buffer_size=64M
log-bin
binlog-do-db=radiusd_db
server-id = 1
These problems are causing me serious pain as whenever a large
process starts my load avg jumps throught the roof. I run radius
off of this database, and when the load jumps users fail to authenticate.
Any help/sugestions with this matter would be great.
Thanks for your time...
-James
---------------------------------------------------------------------
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
