multiple instances of mysqld running and not sure where they are coming from

wsenter

Well-Known Member
Aug 5, 2003
88
0
156
Texas
When running "top" I get the following...

2592 mysql 21 6 61912 53M 1220 S N 0.0 5.3 0:02 3 mysqld
2670 mysql 21 6 61912 53M 1220 S N 0.0 5.3 0:00 1 mysqld
2671 mysql 21 6 61912 53M 1220 S N 0.0 5.3 0:06 0 mysqld
3507 mysql 21 6 61912 53M 1220 S N 0.0 5.3 1:06 0 mysqld
3508 mysql 21 6 61912 53M 1220 S N 0.0 5.3 0:28 0 mysqld
5412 mysql 21 6 61912 53M 1220 S N 0.0 5.3 0:24 0 mysqld
6463 mysql 21 6 61912 53M 1220 S N 0.0 5.3 0:23 1 mysqld
10894 mysql 21 6 61912 53M 1220 S N 0.0 5.3 0:24 0 mysqld
7693 mysql 21 6 61912 53M 1220 S N 0.0 5.3 0:23 0 mysqld
8200 mysql 21 6 61912 53M 1220 S N 0.0 5.3 0:19 1 mysqld
8201 mysql 21 6 61912 53M 1220 S N 0.0 5.3 0:24 2 mysqld
25308 mysql 21 6 61912 53M 1220 S N 0.0 5.3 0:12 3 mysqld
25310 mysql 21 6 61912 53M 1220 S N 0.0 5.3 0:14 2 mysqld

So to determine where those are coming from I try all of the following but it shows me nothing...

[email protected] [~]# cat /proc/2592/environ
CONSOLE=/dev/consoleTERM=linuxINIT_VERSION=sysvinit-2.85PATH=/sbin:/usr/sbin:/bin:/usr/bin://binRUNLEVEL=3runlevel=3PWD=/var/libLANG=en_US.UTF-8PREVLEVEL=Nprevious=NHOME=/SHLVL=3

[email protected] [~]# cat /proc/2592/cmdline
/usr/sbin/mysqld--basedir=/--datadir=/var/lib/mysql--user=mysql--pid-file=/var/lib/mysql/server.hostname.com.pid--skip-locking--socket=/var/lib/mysql/mysql.sock

[email protected] [~]# mysqladmin processlist
+-------+-----------+-----------+-----------+---------+------+-------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+-------+-----------+-----------+-----------+---------+------+-------+------------------+
| 21058 | eximstats | localhost | eximstats | Sleep | 1 | | |
| 22132 | root | localhost | | Query | 0 | | show processlist |
+-------+-----------+-----------+-----------+---------+------+-------+------------------+


Anyone have any ideas as to how I can go about trying to determine exactly what in mysql is using up so much memory?