Re: multiple mysql daemons in process
On Tue, 2002-04-23 at 06:46, Ulf Rompe wrote: > Patrick Hsieh <[EMAIL PROTECTED]> writes: > > > I have 38 mysqld processes running in one single machine, is it normal? > > It depends. on the number of persistent connections, mostly. Otherwise, the child process retires. mysqladmin processlist will tell you what is going on. > > CPU states: 3.2% user, 4.3% system, 0.0% nice, 92.5% idle > > Mem:900464K total, 840808K used,59656K free, 277532K buffers > > Swap: 498004K total, 327808K used, 170196K free, 221132K cached I'd be concerned with the amount of swap in use. Something was looking for a lot of RAM at some time. I'd look for things like a bunch of Apache threads with open connections to a large table and hanging on for longer than I would like. Then adjust the appropriate parameters, probably some in the MySQL config and some in Apache. If not Apache, the mysqladmin command above will tell you what is using all those processes. Gerard -- We just need to figure out which pieces to apply in various combinations to optimally meet the needs of our different user communities. -- Bdale Garbee, New Debian Project Leader http://www.debian.org/vote/2002/platforms/bdale -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
Re: multiple mysql daemons in process
Patrick Hsieh <[EMAIL PROTECTED]> writes: > I have 38 mysqld processes running in one single machine, is it normal? It depends. If there are frequent queries from more than one process this is normal and good - if the daemon weren't able to fork it couldn't handle more than one connect at a time. In your case it looks perfectly normal: > 11:48:43 up 49 days, 15:11, 34 users, load average: 0.02, 0.06, 0.00 > 275 processes: 265 sleeping, 1 running, 9 zombie, 0 stopped > CPU states: 3.2% user, 4.3% system, 0.0% nice, 92.5% idle > Mem:900464K total, 840808K used,59656K free, 277532K buffers > Swap: 498004K total, 327808K used, 170196K free, 221132K cached > > PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME COMMAND > 31277 mysql 9 0 300M 30M 3004 S 0.0 3.5 0:04 mysqld > 31279 mysql 9 0 300M 30M 3004 S 0.0 3.5 0:07 mysqld [...] I'm not shure if Mysql spawns child processes or threads, but since this doesn't make a great difference for the user you can tell that not each process shown in the list takes up 300 MB for it's own. The 300 MB are the memory that is shared by all instances. You can adjust the maximum amount of memory that Mysql may take, but in most cases you shouldn't since Mysql does some usefull things like data caching with it. And if you are worried about the relatively small amount of free physical memory: In any case the system has better uses for the memory than the user. In your case there are about 271 MB buffer memory that will be freed if the rest of the system needs more memory. [x] ulf -- Der Mensch ist immer noch der beste Computer. (John F. Kennedy) -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
multiple mysql daemons in process
Hello list, I have 38 mysqld processes running in one single machine, is it normal? 11:48:43 up 49 days, 15:11, 34 users, load average: 0.02, 0.06, 0.00 275 processes: 265 sleeping, 1 running, 9 zombie, 0 stopped CPU states: 3.2% user, 4.3% system, 0.0% nice, 92.5% idle Mem:900464K total, 840808K used,59656K free, 277532K buffers Swap: 498004K total, 327808K used, 170196K free, 221132K cached PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME COMMAND 31277 mysql 9 0 300M 30M 3004 S 0.0 3.5 0:04 mysqld 31279 mysql 9 0 300M 30M 3004 S 0.0 3.5 0:07 mysqld 31280 mysql 9 0 300M 30M 3004 S 0.0 3.5 0:00 mysqld 31281 mysql 9 0 300M 30M 3004 S 0.0 3.5 0:00 mysqld 31282 mysql 9 0 300M 30M 3004 S 0.0 3.5 0:00 mysqld 31283 mysql 9 0 300M 30M 3004 S 0.0 3.5 0:00 mysqld 31284 mysql 9 0 300M 30M 3004 S 0.0 3.5 0:00 mysqld 31285 mysql 9 0 300M 30M 3004 S 0.0 3.5 0:12 mysqld 31286 mysql 9 0 300M 30M 3004 S 0.0 3.5 0:02 mysqld 31287 mysql 9 0 300M 30M 3004 S 0.0 3.5 0:01 mysqld 31288 mysql 9 0 300M 30M 3004 S 0.0 3.5 0:00 mysqld 31738 mysql 9 0 300M 30M 3004 S 0.0 3.5 4:11 mysqld 7110 mysql 10 0 300M 30M 3004 S 0.5 3.5 6:22 mysqld 12137 mysql 9 0 300M 30M 3004 S 0.0 3.5 0:59 mysqld 16802 mysql 9 0 300M 30M 3004 S 0.0 3.5 0:02 mysqld 16841 mysql 9 0 300M 30M 3004 S 0.0 3.5 0:02 mysqld It seems mysqld has used all of my memory. Any idea? -- Patrick Hsieh <[EMAIL PROTECTED]> GPG public key http://pahud.net/pubkeys/pahudatezplay.gpg -- Patrick Hsieh <[EMAIL PROTECTED]> GPG public key http://pahud.net/pubkeys/pahudatpahud.gpg -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]