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
> > > >
> > > >
> > > >
> >
> >
>
>
>
