server restarted, now multiple apache processes running

[duckle]

Our server was restarted a few weeks ago. Since then, we have noticed that there are multiple apache processes running and our mysql cpu usage jumps from 9% to 78% to 90% at times. Our website has also slowed down significantly.

We are running apache & mysql, on a freebsd environment.

Can anyone help us figure out why new apache processes are being created and how it can be fixed?

We appreciate any help received. Thank you.

 

[cdlvj]

That is what is supposed to happen. There is a parent process, and multiple children which handle the requests.

 

[duckle]

Thanks. I have to find another reason why our site is running so slow. Someone suggested looking at our db cache. Thanks for your help, cdlvj.

 

[cdlvj]

Could be a select statement problem, key is errant, and entire table is being read when only a part is required.