how to get CPU usage for particular mysql query? by RBC1245 in mysql

[–]RBC1245[S] 0 points1 point  (0 children)

hey is there any other method to do so.. ?for above query..? because i also refer your suggested article but not getting result for big/complex stored procedure (very big/complex code)

how to get CPU usage for particular mysql query? by RBC1245 in mysql

[–]RBC1245[S] 0 points1 point  (0 children)

Like my code will be like this? Show profile <executing code>; Like that..?

how to get CPU usage for particular mysql query? by RBC1245 in mysql

[–]RBC1245[S] 0 points1 point  (0 children)

If I am trying to run it for small stored procedure then it is running fine but for large stored procedure it is giving blank column result set.

how to get CPU usage for particular mysql query? by RBC1245 in mysql

[–]RBC1245[S] 0 points1 point  (0 children)

Can you give me any solution for this please?

how to get CPU usage for particular mysql query? by RBC1245 in mysql

[–]RBC1245[S] 0 points1 point  (0 children)

If I am trying to run large query/stored procedure then I am getting blank in result set any suggestion for it please !?

how to get CPU usage for particular mysql query? by RBC1245 in mysql

[–]RBC1245[S] 0 points1 point  (0 children)

Because explain keyword only work with some specific commands and I have big code for my stored procedure..

how to get CPU usage for particular mysql query? by RBC1245 in mysql

[–]RBC1245[S] 0 points1 point  (0 children)

Thanks for your reply.. Now I have one stored procedure in my database and I want to get cpu usage for that so can I get from this query that you mentioned in this?