Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Mysql Windows Innodb Files Beginning With #sql

forums › forums › SQLyog › Using SQLyog › Mysql Windows Innodb Files Beginning With #sql

  • This topic is empty.
Viewing 2 reply threads
  • Author
    Posts
    • June 10, 2011 at 7:46 am #32338
      peterlaursen
      Participant

      We have no clue really! Actually “OPTIMIZE TABLE” is just a plain and simple SQL statement. Refer http://dev.mysql.com/doc/refman/5.1/en/optimize-table.html . “For InnoDB tables, OPTIMIZE TABLE is mapped to ALTER TABLE, which rebuilds the table to update index statistics and free unused space in the clustered index.”

      That simple statement is all we do here. So same issue would happen with any client doing the same. so this question should rather go to MySQL (their Forums for instance) than to us. Maybe some people at MySQL could reply immediately. It could be a bug with a specific server and it could depend on InnoDB configuration settings etc.

      We will try to see this for ourselves. I cannot gurantee that it will be before the weekend. It will probably require an installation with some rather big tables.

    • June 10, 2011 at 7:51 am #32339
      peterlaursen
      Participant

      BTW: maybe you could share your my.ini file? Also please tell exact server version.

    • June 10, 2011 at 1:34 pm #32340
      Tony
      Member

      Figured these files are temporary files created by mysql as it's doing things like optimize table.

      Rather than deleting these files using windows OS, used SQLyog doing DROP TABLE `#sql-108c_53c`;

      Did this for each of the #sql- files found in the various mysql data folders.

      This does not appear to be related to SQLyog so we can close this thread.

      Thanks.

  • Author
    Posts
Viewing 2 reply threads
  • You must be logged in to reply to this topic.