mysqld PID problems, I think...

[John Seth]

Agreed... you may see multiple 'mysqld' processes when doing a 'ps aux',
but there should only be one pid file written, usually to /var/run/mysql/
or /var/lib/mysql/. Depending on the kernel you have, sometimes all
threads are shown, and in other kernels you may see [mysqld] and no other
processes in the list.  That should be nothing to worry about.

-- 
To each their own...

> there should only be one pid, this would be for the master/primary
> process. mysql is threaded so there may be multiple mysqld processes
> running at one time.
>
>
> DANIEL MAGNUSZEWSKI wrote:
>> All,
>>
>> On a RedHat 9.0 server, I am having problem with an application that
>> uses MySQL. While trouble shooting, I noticed that mysqld had only one
>> pid. I did a restart of mysql by the following command:
>>
>> /etc/init.d/mysqld restart
>>
>> When I do a mysqld status, it is only showing one pid. On my RedHat 8.0
>> servers the same mysqld status command shows 4 pids. Is this normal for
>> my RH 9 server to only have one mysqld pid, or should there be more like
>> my RH 8 servers?
>>
>> Thanks!
>>
>> -Dan
>>
>>
>