MySQL server is running for 95days but the mysqld pid is changed few times. Why mysqld changes its pid, any ideas ? How can I know that the mysqld pid has changed and what is the cause behind the change of the pid ?
Regards
Supratik
Tell me more
×
Server Fault is a question and answer site for
professional system and network administrators. It's 100% free, no registration required.
|
My guess is that the server restarts itself every now and then to avoid resource leaks (memory, connections). Many big sites ran into trouble because of that in the past (server would run out of connections and not being able to answer any requests anymore), so that probably made it into the install scripts. If you want to find out exactly, I suggest to check the crontab of root or the user the MySQL is running under. |
||||
|
|
|
Check if the mysql log is being rotated. The server may have been restart during log file rotate. |
|||||||
|
|
If you want to find out what the current MySQL pid is you can find it in the file /var/run/mysqld/mysqld.pid (Thats in Ubuntu could be differnt in other distros). |
|||
|
|
