What is "normal" for mysqld memory and # processes?
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….