Not the answer you need?
Register and ask your own question!

Explain on table increases Created_tmp_disk_tables

infdude666infdude666 ContributorCurrent User Role Beginner
Hi Team,

One of My server was stormed by nearly 95% of Created_tmp_disk_tables. Today thanks to upgrade to 5.6 and performance_schema i quickly found that "EXPLAIN tablename" was fired continuously which was creating all the disk temporary table.

Is this normal or a bug?


  • niljoshiniljoshi MySQL Sage Inactive User Role Beginner
    Which MySQL/PS version you were using? There might be some bug for that.
  • infdude666infdude666 Contributor Current User Role Beginner
    Basically this is happening in 5.5 and also 5.6 any subversion.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.