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 > > > > > > > > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
