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]
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]
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]
MYSQL SOS
Hi Could someone tell me where MYSQL keeps its databases in Debian. Thanks Craig :) -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
Re: MYSQL SOS
> Hi > > Could someone tell me where MYSQL keeps its databases > in Debian. /var/lib/mysql rysiu -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
Re: MYSQL SOS
By default; /var/lib/mysql/ This is configurable, look for datadir = /var/lib/mysql in /etc/mysql/my.cnf On Tuesday 23 April 2002 14:56, Craig wrote: > Hi > > Could someone tell me where MYSQL keeps its databases > in Debian. > > Thanks > Craig :) -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
msyslog
Has anyone gotten this to work with logging to mysql? I'm trying to set up a central logging host with an sql backend, but for some reason, the mysql connection doesn't work. Running ldd on the binary, I don't even see the mysql libs! This may require a bug report... :( Tim -- >< >> Tim Sailer (at home) >< Coastal Internet,Inc. << >> Network and Systems Operations >< PO Box 671 << >> http://www.buoy.com >< Ridge, NY 11961 << >> [EMAIL PROTECTED][EMAIL PROTECTED] >< (631)924-3728 (888) 924-3728 << >< -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
subscribe
-- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
Boot/root disks
Hi, This is slightly off topic but I haven't had much luck with this so I thought I'd ask here. I have installed and configured Debian with many packages and a custom kernel, which I have then imaged using the partimage package. I want to then use this to replicate this image onto multiple machines of the same hardware. These machines have a floppy drive and network card but no CD-ROM drive. I have tried to boot off both the debian install and partimage/slackware boot and root disks but neither of these will let me run the TFTP client, which I want to use for downloading the images from my TFTP server and restoring them on the local disk. The network setup is fine (pings are fine, routes are fine, the tools in these images provide for little else in the way of troubleshooting), but when the tftp client is run it exits with this message: tftp: tftp/udp: unknown service when using tftp version 0.1.0 or tftp: tftp/udp: unknown service, faking it... when using tftp version 0.2.9. I've tried copying over /etc/services to the /etc directory after booting up with either of the root images but get the same result. I can't use FTP or telnet because of missing libraries in the root images, but TFTP is fine for what I want to do. Has anyone seen this before? Is there something I am doing wrong? Is there a good alternative root image somewhere which I can use instead of the debian/slackware/partimage ones which can run the TFTP client without problems? Is there a better way of doing this short of using NFS , the crappy partimage network client or directly imaging from one hard drive to another (my last resort, the cases are rather small and hard to work with). Thanks, Brendan -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
