I have a Jenkins server, which periodically rebuilds a PHP/mySQL application. Every time new PHP code is pushed, this job drops all the tables in the corresponding database and then recreates them with the structure specified in the PHP installer. This is working fine for the most part, though occasionally it hangs.
The thing I'm not sure how mysqld/php processes get instantiated/destroyed. I notice I often have php processes that run for over an hour, and I constantly have at least one mysqld process that runs for hours/days. Take a look at my top
output:
Aren't you supposed to get a new process each time a page is requested? And isn't that process supposed to be destroyed after the page is delivered? I thought PHP works that way, I'm not sure about mysqld. I do have a line in php.ini that says max_execution_time = 30
, so I'm pretty confused how this php process could be going for over an hour.
ps -ef f
?