0
Under review
How to see mysql query
Hello,
Is it possible to see queries?
I have heavy joins but how can I see which queries are concerned?
Thank you.
Customer support service by UserEcho
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