one mysqld process instead many?
I have dedicated server only for mysql and there is only one mysqld process
last pid: 19052; load averages: 0.43, 0.53, 0.51 up 616+11:10:30 22:38:20
19 processes: 2 running, 17 sleeping
CPU states: 8.6% user, 0.0% nice, 9.5% system, 0.4% interrupt, 81.5% idle
Mem: 225M Active, 526M Inact, 202M Wired, 42M Cache, 111M Buf, 2636K Free
Swap: 1443M Total, 88K Used, 1443M Free
PID USERNAME PRI NICE SIZE RES STATE C TIME WCPU CPU COMMAND
36128 mysql 100 0 224M 201M RUN 1 201.5H 45.46% 45.46% mysqld
289 root 96 0 1308K 724K select 0 2:49 0.00% 0.00% syslogd
461 root 8 0 1336K 836K nanslp 0 2:16 0.00% 0.00% cron
443 root 96 0 3488K 1676K select 0 0:41 0.00%
however at most servers I have seen many mysqld processes
what's difference between one mysql process and many processes? what is better to have on dedicated mysql server PIV 2,8GHZ HT 1GB RAM one or several mysqld? load is always less than 1.00
and how to easy change to several mysqld?
