MySQL Forums
Forum List  »  Performance

Temp tables on Disk issue
Posted by: Devrishi Shandilya
Date: February 15, 2015 11:17PM

Hi Friends,

We are facing an issue with temp tables on disk. 80% of temp tables are created on disk, which can be a performance issue. We have done followings things:

Have already increased tmp_table_size and max_heap_table_size upto 32M but it made no difference on stats, earlier it was 16M.

One thing I wanna inform that we are using longtext field in many of tables.

How can i start troubleshooting, as increasing the value of variables tmp_table_size and max_heap_table_size has not shown any benefit and stats are remail same.

Is there any way to resolution without converting longtext to varchar?


Options: ReplyQuote

Written By
Temp tables on Disk issue
February 15, 2015 11:17PM
February 16, 2015 12:19AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.