GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

Explain on table increases Created_tmp_disk_tables

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Explain on table increases Created_tmp_disk_tables

    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?


  • #2
    Which MySQL/PS version you were using? There might be some bug for that.

    Comment


    • #3
      Basically this is happening in 5.5 and also 5.6 any subversion.

      Comment

      Working...
      X