0
Under review

How to see mysql query

jbeauviche 3 years ago updated by Vyacheslav.Terentiev (Here to help) 3 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.


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


https://dev.mysql.com/doc/refman/5.7/en/server-status-variables.html#statvar_Select_full_join


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