From: franco riggi Date: October 18 2012 7:55am Subject: Temporary files List-Archive: http://lists.mysql.com/innodb/67 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=047d7b10cf373309fb04cc50b78d --047d7b10cf373309fb04cc50b78d Content-Type: text/plain; charset=ISO-8859-1 Hello, I had several time an error like Incorrect key file for table '/tmp/#sql_4aa7_1.MYI'; try to repair it and I didn't found any really deep info about how MySQL uses and create the temporary files. In particular I don't have clear 1) why the format is MYI whlle we do not use any MyISAM table (I have only Innodb); 2) how can I monitor how their size ( that is not easy because are hidden files) . I have a tmp folder which is around 5G but probably it is not enough. 3) best suggestion for tmp tuning All the best, Francesco --047d7b10cf373309fb04cc50b78d--