On a website that receives very little visitors, logging into the admin panel, In the visitors list i noticed hundreds of index.php by same ip address. This caused the mySQL server to crash and the host started complaining to fix this problem. When i checked the ip address, it belong to a search engine bot.
After a little search on this forum, i came to the conclusion that its an open db connection that was not closed and resulted in too many open mySQL connections. What could be the reason of this?
Anyway i tried a crude fix.... in the home.html template, i included
$site_db->close();and after few minutes removed it..... this somehow seemed to fix all the problem.... all the extra index.php went away and the mysql server came back to normal.
Can any one please explain why there are multiple index.php listing from the same ip and why this causes the mysql server to become unavailable or slow and why the above code seems to fix it
Thanks
Edit: Is there a way to limit the number of parallel connections from same ip, will this solve this issue?
Edit2: If i set "mysql.allow_persistent" to "off" will it solve this problem? Will it have any negative effect on the script?