Under review

How to see mysql query

8 years ago • updated by 8 years ago • 4

Hello,

Is it possible to see queries?

I have heavy joins but how can I see which queries are concerned?

Thank you.

Vote

Under review

Hi,

You can always see the queries using this command :

(dstat_Select_full_join+dstat_Select_range_check+dstat_Select_scan)/dstat_Com_select*100

please, let me know if i have answered your question.

Thanks for your answer.

I'm new on Anturis and I don't know how can I put this command.

Can you help me, please?

Thank you

Hello.

I am sorry I haven't provided any additional details.

Anturis itself can't show the queries, so this command is to be executed in the mysql itself.

For additional information, please, refer to

Only need remove dtstat from var name: Example, dstat_Select_full_join became Select_full_join in those article

Our system doesn't return each value of variable. Only the result of caclulation