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]