Hi all, I am very new to Monyog and I don't really know where to start.
I am getting lots of alerts about queries being run starting with "SELECT SQL_NO_CACHE *" on many tables and I suspect its slowing things down.
Can anyone suggest where I view any logs to see what user is doing this?
Thanks in advance
On behalf of our support team:
You can check the same in slow query log if you have enabled the slow query log in "Edit Server -> Advanced settings -> MySQL query log". Also if you have used the sniffing mode Processlist under "Edit server -> Advanced -> Sniffer" then check for monitor long running queries as well. Further, you can go through the below links related to using SQL_NO_CACHE:
https://stackoverflow.com/questions/18777975/when-to-use-sql-no-cache https://dev.mysql.com/doc/refman/5.6/en/query-cache-in-select.html