We have a situation - we have a lot of webapps on the server and some cron jobs. We are suspecting that perhaps one of the cron jobs is causing growth of number of apache processes.
I know Apache creates processes for new visitors to be able to handle their requests in parallel, but are there any other situations, when Apache creates new processes?
Actually we cannot discover, which of the jobs is it. How to debug it in real-time, or check back in history, which of script of "webapp", or user (of database) has overloaded the server?
Are there any useful tools for that?