We have a property management company we've created a web site for that uses PHP/MySQL. In the last two days the site has gone done twice and gives the "Server Error 500" when you visit the site. Our hosting provider has been able to bring the site back up for us and they provided us with some suggestions.
Our host suggested that the problem is related to the way the site has been developed. The scripts on the site fork too many processes, which exceed the limit of the MySQL and the shell processes on the server. It seems that most of the processes are forked by the following file:
listing_browse.php
They stated that there were over 10 processes running for users, all launched by this file.
They ask us to optimize the scripts on the site, as they seem to fill the entire limit allocated for this user. In such cases, the scripts will usually use any limit, so optimization is the only option.
Since we're very new at this, can someone take a look at the site and perhaps direct us in how to optimize the scripts... or tell us how to find help in optimizing?
http://www.grahamrentalproperties.com
Our company is using the exact same database structure on real estate site that does rentals - the site actually gets more visits/bots than the once serving up errors - but it has never gone done like this. Thanks in advance!