ballhogjoni Posted October 6, 2011 Share Posted October 6, 2011 where mysql slow queries is finding the queries? Basically I need to find the offending code that produced/ran the query. Quote Link to comment Share on other sites More sharing options...
requinix Posted October 6, 2011 Share Posted October 6, 2011 That's basically impossible, considering the many ways in which a query can be constructed. A simple grep can help if you search on a fixed portion of the query (like an "UPDATE table" or an "INSERT INTO table (fields)"). Look at the query. Decide what it's doing. Decide what files would be doing that kind of thing. Look through the files until you find the one(s) with the problem. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.