I'm just spitballing, if you know of an administrative tool that would meet my needs better, I'd be super appreciative to hear of it. I've been struggling with a low-resource server having issues serving pages due to bot traffic. When I look at the graphs at the front of the ispc panel, it shows that the cpu is maxed out, constantly(while the apache server is up) and when I look at monit, it shows that mysql is using most of the CPU resource. I'd like to know more about what's causing the issue specifically, perhaps some of my code causing inefficient mysql queries. Is there a way for me to see on the server a list of the URLs that are being visited? On a related note, is there a way to view a log of the actual mysql queries being run? That would actually probably be more useful than the page loads. Thanks for your time!
First, check which websites cause the most load, you can e.g. do this with the top command. If the load are caused by PHP processes, then you can identify the website by its web user, e.g. web5 is the website with ID 5 in ISPConfig. if you know the website, then you can go to the websit log folder. e.g.: cd /var/www/somedomain.tld/log and there you can view the log in realtime with tail command: tail -f access.log to stop tail command, press ctrl + c keys.
You can check visited URL in realtime enabling apache server status For mysql, you can enable mysql logging, it saves every db query to a file, so be careful because it can grow very fast
