# Explain on table increases Created\_tmp\_disk\_tables

**URL:** <https://forums.percona.com/t/explain-on-table-increases-created-tmp-disk-tables/3703>\
**Category:** Other MySQL® Questions\
**Created:** [August 27, 2014, 10:31am UTC](https://forums.percona.com/t/explain-on-table-increases-created-tmp-disk-tables/3703 "2014-08-27T10:31:02Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![infdude666](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/infdude666/32/11425_2.png) [@infdude666](https://forums.percona.com/u/infdude666)\
**Post date:** [August 27, 2014, 10:31am UTC](https://forums.percona.com/t/explain-on-table-increases-created-tmp-disk-tables/3703/1 "2014-08-27T10:31:02Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![niljoshi](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/niljoshi/32/16889_2.png) [@niljoshi](https://forums.percona.com/u/niljoshi)\
**Post date:** [August 28, 2014, 3:22am UTC](https://forums.percona.com/t/explain-on-table-increases-created-tmp-disk-tables/3703/2 "2014-08-28T03:22:01Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![infdude666](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/infdude666/32/11425_2.png) [@infdude666](https://forums.percona.com/u/infdude666)\
**Post date:** [September 5, 2014, 8:41am UTC](https://forums.percona.com/t/explain-on-table-increases-created-tmp-disk-tables/3703/3 "2014-09-05T08:41:22Z")

</div>

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