I would like to share this story based on a true event about the temporary files behavior in MySQL.
MONyog reports this error to my already full mailbox several times a day :
1 – Catch the query (if you can) !
I don’t have access to the client logs but I would like to know which query is involved in this error.
Let me explain how I can retrieve informations about this query with MONyog and a very simple shell loop :
- Enable the query sniffer in MONyog (based on processlist) : Edit server -> Advanced settings -> Sniffer settings