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?

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

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