Merci Geoffroy, starting from the command prompt shows:
# /usr/sbin/mysqld --console --verbose --basedir=/usr --datadir=/var/lib/mysql --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/run/mysqld/mysqld.sock 070530 18:01:28 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.0.38-log' socket: '/var/run/mysqld/mysqld.sock' port: 3306 Gentoo Linux mysql-5.0.38 However running a ps already shows multiple mysqld processes. Something i had not noticed so far: # ps -ef | grep mysqld mysql 25752 27831 0 18:01 pts/2 00:00:00 /usr/sbin/mysqld --console --verbose --basedir=/usr --datadir=/var/lib/mysql --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/run/mysqld/mysqld.sock root 16560 25752 0 18:01 pts/2 00:00:00 /usr/sbin/mysqld --console --verbose --basedir=/usr --datadir=/var/lib/mysql --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/run/mysqld/mysqld.sock root 16560 25752 0 18:01 pts/2 00:00:00 /usr/sbin/mysqld --console --verbose --basedir=/usr --datadir=/var/lib/mysql --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/run/mysqld/mysqld.sock root 23390 16560 0 18:01 pts/2 00:00:00 /usr/sbin/mysqld --console --verbose --basedir=/usr --datadir=/var/lib/mysql --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/run/mysqld/mysqld.sock(etc.) the first process created is the only one with "mysql" owner. All the subsequent processes are own by root, and have as parent one of the previously created processes (not always the first one). Not sure if that helps in understanding this though. Thanks anyway for your help. On 5/30/07, Geoffroy Cogniaux <[EMAIL PROTECTED]> wrote:
Try to start it with mysql_safe instead or try to start mysqld manually within a command prompt, without fork, to see what happen. ./mysqld --console --verbose --your_options Can you at least connect to mysql with a remote client on this server or not? Have a look on this page about starting issues: http://dev.mysql.com/doc/refman/5.0/en/unix-post-installation.html#starting- server Geoffroy -----Message d'origine----- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] De la part de Quentin Gouedard Envoyé: mercredi 30 mai 2007 09:02 À: Scott Tanner Cc: mysql@lists.mysql.com Objet: Re: mysql creating lots of processes (not threads, linux processes) Nope, I'm using 5.0.38 on Gentoo, built via emerge in the exact same manner. Thanks for your answers guys. On 5/30/07, Scott Tanner <[EMAIL PROTECTED]> wrote: > > Sounds like your not using threaded libraries. Was mysql built > differently, or are you using a different RPM on this server? > > > Scott > > > > On Tue, 2007-05-29 at 22:49 +0200, Quentin Gouedard wrote: > > No, I have just collectd+mrtg, but i don't even use them to monitor > mysql. > > I launch mysql via /etc/init.d/mysql start , and the script is the exact > > same as on the other servers. Even just after startup there's already > 15-20 > > processes created. > > > > On 5/29/07, Geoffroy Cogniaux <[EMAIL PROTECTED]> wrote: > > > > > > Hi, > > > > > > It looks like automatic start-up called by a monitoring process > (Nagios, > > > ...). Have you such tools on your servers ? > > > > > > Geoffroy > > > > > > -----Message d'origine----- > > > De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] De la part de > Quentin > > > Gouedard > > > Envoyé: mardi 29 mai 2007 16:41 > > > À: mysql@lists.mysql.com > > > Objet: mysql creating lots of processes (not threads, linux processes) > > > > > > Hi, > > > So I use mysql as the DB for a large site (up to 10000 concurrent > users at > > > peaks). > > > I have a front server as a reverse proxy and multiple (7) backend > machines > > > serving the site. > > > Each machine has data strictly similar in nature and quantity. > > > > > > On 6 of these machines, I have 1 single mysqld process (process in > linux > > > terms): > > > # ps -ef | grep mysqld | wc -l > > > 2 > > > > > > There are generally 5-8 threads (processes as mysql means it) running > when > > > i > > > do a show processlist; > > > > > > > > > Now, on one of those machines there are huge number of processes for > > > mysql. > > > # ps -ef | grep mysqld | wc -l > > > 34 > > > Running just ps shows for each of these processes: > > > mysql 25952 10073 0 16:25 ? 00:00:02 /usr/sbin/mysqld > > > --defaults-file=/etc/mysql/my.cnf --basedir=/usr > --datadir=/var/lib/mysql > > > --pid-file=/var/run/mysqld/mysqld.pid > --socket=/var/run/mysqld/mysqld.sock > > > > > > This machine has no particular data, is doing nothing different than > the > > > others. > > > The show processlist command also returns 5-8 processes. > > > > > > So where are these myqsld processes from ? There's like 20 at startup > > > (instantly after launching mysql), but it keeps increasing, until i > > > restart > > > mysql or the server runs out of memory. I have compared the mysql > > > configuration of this machine and the 6 other, variable by variable, > and > > > they are strictly identical. > > > How come this server behaves differently ? What can I do to have the > > > single-process behaviour on that machine too ? > > > > > > Thanks, > > > Quentin > > > > > > > > > > >
