Show profiles, query query_id is always changing, then use the show profile for query query_id, ensure the display is what you want to query?????
Such as I use show profiles showed as a result, and then found the query, I want it query_id is 34, and then I use show profile for query 34, query out but nothing,
I've been performing show profiles, found that every time a different id,
So how do you want to query to locate the SQL???????????????????????????????????????????????????

CodePudding user response:

Same q q

CodePudding user response:

They are not the same thing, suggest you look at the show profile is what east east

CodePudding user response:

refer to the second floor ZJCXC response:

both are not the same thing, I suggest you look at the show profile is what east east say

I read on and blog are say so, but I practice when there is a problem, I think it is my understanding there is a problem, but do not know where there is a problem,

CodePudding user response:

My fault, I as show the processlist
Will change, because there have been new query, this has a limit on the number of query cache, the default profiling_history_size=15

Usually we only used at the session level

CodePudding user response:

The

reference 4 floor ZJCXC reply:

my fault, I'm as show the processlist
Will change, because there have been new query, this has a limit on the number of query cache, the default profiling_history_size=15

Generally we only at the session level using the

can you say something in detail, or give a reference, you have said is too general, I don't understand (ps: I'm not ops,)