Hi,
Running htop - output below on my linode (2GB RAM). It shows 24 mysqld processes running at 11.2% memory each.
Is this normal? Any suggestions for what should be changed? I am not really having any problems, but thinking this is not right.
I have APC running, no other caching (e.g. no memcached).
Also below is output of free -m.
Thanks for any advice.
Rick

~$ free -m
total used free shared buffers cached
Mem: 1994 1770 224 0 29 910
-/+ buffers/cache: 831 1163
Swap: 255 16 239


PID USER PRI NI VIRT RES SHR S CPU% MEM% TIME+ Command
22227 mysql 20 0 381M 223M 6708 S 0.0 11.2 0:00.00 /usr/sbin/mysqld
22228 mysql 20 0 381M 223M 6708 S 0.0 11.2 0:02.35 /usr/sbin/mysqld
22229 mysql 20 0 381M 223M 6708 S 0.0 11.2 0:00.97 /usr/sbin/mysqld
22230 mysql 20 0 381M 223M 6708 S 0.0 11.2 0:01.05 /usr/sbin/mysqld
22231 mysql 20 0 381M 223M 6708 S 0.0 11.2 0:01.13 /usr/sbin/mysqld
22232 mysql 20 0 381M 223M 6708 S 0.0 11.2 0:01.05 /usr/sbin/mysqld
22233 mysql 20 0 381M 223M 6708 S 0.0 11.2 0:11.70 /usr/sbin/mysqld
22234 mysql 20 0 381M 223M 6708 S 0.0 11.2 0:08.51 /usr/sbin/mysqld
22235 mysql 20 0 381M 223M 6708 S 0.0 11.2 0:09.30 /usr/sbin/mysqld
22236 mysql 20 0 381M 223M 6708 S 0.0 11.2 0:08.08 /usr/sbin/mysqld
22246 mysql 20 0 381M 223M 6708 S 0.0 11.2 0:41.57 /usr/sbin/mysqld
22247 mysql 20 0 381M 223M 6708 S 0.0 11.2 1:11.85 /usr/sbin/mysqld
22248 mysql 20 0 381M 223M 6708 S 0.0 11.2 0:05.75 /usr/sbin/mysqld
22249 mysql 20 0 381M 223M 6708 S 0.0 11.2 1:50.10 /usr/sbin/mysqld
22258 mysql 20 0 381M 223M 6708 S 0.0 11.2 0:00.00 /usr/sbin/mysqld
6945 mysql 20 0 381M 223M 6708 S 0.0 11.2 2:57.15 /usr/sbin/mysqld
11975 mysql 20 0 381M 223M 6708 S 0.0 11.2 2:18.50 /usr/sbin/mysqld
12021 mysql 20 0 381M 223M 6708 S 0.0 11.2 2:40.12 /usr/sbin/mysqld
12022 mysql 20 0 381M 223M 6708 S 0.0 11.2 2:19.75 /usr/sbin/mysqld
12031 mysql 20 0 381M 223M 6708 S 0.0 11.2 2:04.62 /usr/sbin/mysqld
12042 mysql 20 0 381M 223M 6708 S 0.0 11.2 2:39.09 /usr/sbin/mysqld
16119 mysql 20 0 381M 223M 6708 S 0.0 11.2 2:08.15 /usr/sbin/mysqld
16120 mysql 20 0 381M 223M 6708 S 0.0 11.2 1:59.93 /usr/sbin/mysqld
22215 mysql 20 0 381M 223M 6708 S 0.0 11.2 46:03.76 /usr/sbin/mysqld
24869 www-data 20 0 314M 199M 59148 S 0.0 10.0 0:37.10 /usr/sbin/apache2 -k start
25500 www-data 20 0 312M 193M 53648 S 0.0 9.7 0:24.28 /usr/sbin/apache2 -k start
25078 www-data 20 0 201M 103M 65432 S 0.0 5.2 0:54.78 /usr/sbin/apache2 -k start
24798 www-data 20 0 196M 90472 55152 S 0.0 4.4 0:26.12 /usr/sbin/apache2 -k start
24871 www-data 20 0 180M 87400 68580 S 0.0 4.3 1:06.53 /usr/sbin/apache2 -k start
24877 www-data 20 0 182M 84356 63144 S 0.0 4.1 0:59.64 /usr/sbin/apache2 -k start
25499 www-data 20 0 183M 75040 53408 S 0.0 3.7 0:15.54 /usr/sbin/apache2 -k start
25059 www-data 20 0 177M 74352 58064 S 0.0 3.6 0:19.35 /usr/sbin/apache2 -k start
25129 www-data 20 0 177M 73772 57976 S 0.0 3.6 0:13.98 /usr/sbin/apache2 -k start
24870 www-data 20 0 176M 73080 58140 S 0.0 3.6 0:28.51 /usr/sbin/apache2 -k start
25128 www-data 20 0 175M 72744 58540 S 0.0 3.6 0:15.16 /usr/sbin/apache2 -k start
25135 www-data 20 0 175M 69520 55716 S 0.0 3.4 0:12.00 /usr/sbin/apache2 -k start
2235 root 20 0 166M 16212 12280 S 0.0 0.8 0:54.12 /usr/sbin/apache2 -k start
etc....

That's 11.2% total, those 'processes' are actually threads, they share memory but have separate pids and cpu time. It's normal If you're not having problems leave it alone, "if it ain't broke, don't fix it"

_________________
Paid support
How to ask for help
1. Give details of your problem
2. Post any errors
3. Post relevant logs.
4. Don't hide details i.e. your domain, it just makes things harder
5. Be polite or you'll be eaten by a grue