Search-Replace-DB | migrating PHP and MySQL based websites | Web Framework library

Nevermind this is not the case. I had a redirection plugin which was forcing https which was causing the issue.

Thanks

Was a bit long to put it in a comment, so replying as an answer.

Are you logging any php errors? From what you presented so far, my theory would be that:

1. You used that script to do a search & replace of db but it executed poorly causing malformed or corrupted data.
2. That caused your php scripts that rely on mysql to go haywire due to malformed or corrupted data.
3. Because your php on fcgi isn't responding, your apache waits for it and holds onto the resources.
4. All the requests are hanging and now you run out of resources and start seg-faulting.
5. And then stupid apache, seeing that you're out of child count asks you to raise it not realizing you're already exhausted on physical resource beyond reason. Typical apache...
6. Because apache is now out of free children, it can't take anymore requests and it appears as if all of apache is broken even though it's merely clogged up by bad fcgi processes.

If my theory is correct, you should.

1. Check that none of the mysql data is corrupted

2. Check that the data that was replaced in mysql was as what you expected

3. Check for PHP error logs as they should be logging something if they can.

4. You should isolate the PHP processes that are actually the cause of clogging up and remove it if cleaning up data alone wasn't enough. Ideally, no matter how bad the data, the php program should've died cleanly.

Good luck hunting.