4images Forum & Community

4images Issues / Ausgaben => Discussion & Troubleshooting => Topic started by: Eagle Eye on December 19, 2012, 12:29:36 PM

Title: Too many open index.php in admin panel visitors list!!!
Post by: Eagle Eye on December 19, 2012, 12:29:36 PM
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  :roll:

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?
Title: Re: Too many open index.php in admin panel visitors list!!!
Post by: Rembrandt on December 20, 2012, 07:37:41 AM
Hi!
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. ....

Do not get Deceive, in the ACP you see all IP addresses for the current session time.
This does not mean that the IP address is still connected.
Set the "General/Settngs/Session timeout in minutes" to one minutes and you can see what address is actually connected.

read this Article (http://www.besthostratings.com/articles/block-bad-bots.html)

what for "search engine bot" is it?

mfg Andi
Title: Re: Too many open index.php in admin panel visitors list!!!
Post by: Eagle Eye on December 20, 2012, 01:45:33 PM
Thanks, this seems to have fixed the problem!