So one of my servers is continously bogged down by slow queries. It was to the point where there were hundreds (if not thousands) per minute. I had to edit my.cnf to stop the server from being virtually unaccessible. I was able to create a slow_queries log and see the queries and the length, which were bogging down the server. Now my question is, is there a way to see from which script these queries are coming from specifically. I only have one site on the server--so I know the domain and all, but there's hundreds of scripts and I suspect there's an error in only one of them. Anyone have an idea?
