I noticed that when I try to login with tt-rss android client, on the tt-rss server, mysql starts writing huge temp files to /tmp named like
Code: Select all
-rw-rw---- 1 mysql mysql 810078468 Nov 27 11:51 #sql_2119_0.MYD
-rw-rw---- 1 mysql mysql 2048 Nov 27 11:51 #sql_2119_0.MYI
-rw-rw---- 1 mysql mysql 7881996 Nov 27 11:51 #sql_2119_1.MYD
-rw-rw---- 1 mysql mysql 2048 Nov 27 11:51 #sql_2119_1.MYI
These files quickly fill up all available disk space, and I have to stop apache2 and mysql to clean them up.
It seems that there is some query that is not optimized, as indicated here: temp tables - Why does MySQL produce so many temporary MYD files? - Database Administrators Stack Exchange