How can i know the page from where slow query was hitting in MySQL in error log

Question

How can i know the page from where slow query was hitting in MySQL, like

"SELECT * FROM Users WHERE id=123"

Lets say this query was written on page user.php and on many other pages and this query caught in slow log

Now i need to know the exact page on which this was run from error log

There is no easy way or magic that can find it for you – Mark Baker Jun 22 '15 at 09:12 — Mark Baker, Jun 22 '15 at 09:12

score 0 · Answer 1 · edited Mar 30 '16 at 13:19

0

Grep your source code for SELECT * FROM Users WHERE id=.

Change the PHP code to include a comment (/*...*/) in each SELECT to say where it came from. (If the slowlog strips comments, then add on AND 'page5'='page5' as a harmless, but useful, bit of info.)

edited Mar 30 '16 at 13:19

tstenner

10,080
10
57
92

answered Jun 22 '15 at 21:33

Rick James

135,179
13
127
222

Hi Rick, Thanks for the solution, it works for me and i successfully traced out page and again remove the code as you mention its little bit harmless.I would like to ask a question how its harmful? – Vikas Paliwal Jun 23 '15 at 07:03
The optimizer will have to parse the extra clause and throw it away. The impact on performance will probably be less than 1%. – Rick James Jun 23 '15 at 15:12
Thanks Rick for support. – Vikas Paliwal Jun 24 '15 at 04:33

How can i know the page from where slow query was hitting in MySQL in error log

1 Answers1