# Created\_tmp\_disk\_tables **URL:** \ **Category:** Other MySQL® Questions\ **Created:** [November 17, 2007, 6:14pm UTC](https://forums.percona.com/t/created-tmp-disk-tables/528 "2007-11-17T18:14:07Z")\ **Posts on this page:** 2\ **Page:** 1
**Author:** ![jorje29](https://avatars.discourse-cdn.com/v4/letter/j/ce7236/32.png) [@jorje29](https://forums.percona.com/u/jorje29)\ **Post date:** [November 17, 2007, 6:14pm UTC](https://forums.percona.com/t/created-tmp-disk-tables/528/1 "2007-11-17T18:14:07Z")
I have a performance issue on my server and I guess the problem is that Created\_tmp\_disk\_tables are around 30% of Created\_tmp\_tables. I increased table\_cache to 768, sort\_buffer to 5 and after 8, tmp\_table\_size and max\_heap\_table\_size to 64, with no positive result. There’s always a respectable amount of Created\_tmp\_disk\_tables. I use a lot of temporary tables. I don’t use Blob/text columns. I have 1,5GB of RAM. Do you have any idea how to solve it ? Thank you in advance my.cnf file set-variable = key\_buffer=384Mset-variable = table\_cache=512set-variable = sort\_buffer=4Mset-variable = record\_buffer=4Mset-variable = record\_rnd\_buffer=4Mset-variable = thread\_cache=40set-variable = max\_allowed\_packet=8Mset-variable = wait\_timeout=100set-variable = tmp\_table\_size=32Mset-variable = max\_heap\_table\_size=32M show status output : ±-------------------------±----------+| Variable\_name | Value |±-------------------------±----------+| Aborted\_clients | 109 || Aborted\_connects | 5 || Bytes\_received | 106488635 || Bytes\_sent | 93132416 || Com\_admin\_commands | 2620 || Com\_alter\_table | 0 || Com\_analyze | 0 || Com\_backup\_table | 0 || Com\_begin | 0 || Com\_change\_db | 2890 || Com\_change\_master | 0 || Com\_check | 0 || Com\_commit | 0 || Com\_create\_db | 0 || Com\_create\_function | 0 || Com\_create\_index | 0 || Com\_create\_table | 2438 || Com\_delete | 0 || Com\_drop\_db | 0 || Com\_drop\_function | 0 || Com\_drop\_index | 0 || Com\_drop\_table | 4837 || Com\_flush | 0 || Com\_grant | 0 || Com\_insert | 3018 || Com\_insert\_select | 83639 || Com\_kill | 0 || Com\_load | 0 || Com\_load\_master\_table | 0 || Com\_lock\_tables | 0 || Com\_optimize | 2 || Com\_purge | 0 || Com\_rename\_table | 0 || Com\_repair | 0 || Com\_replace | 0 || Com\_replace\_select | 0 || Com\_reset | 0 || Com\_restore\_table | 0 || Com\_revoke | 0 || Com\_rollback | 0 || Com\_select | 423209 || Com\_set\_option | 0 || Com\_show\_binlogs | 0 || Com\_show\_create | 0 || Com\_show\_databases | 5 || Com\_show\_fields | 6 || Com\_show\_grants | 0 || Com\_show\_keys | 3 || Com\_show\_logs | 0 || Com\_show\_master\_status | 0 || Com\_show\_open\_tables | 0 || Com\_show\_processlist | 0 || Com\_show\_slave\_status | 0 || Com\_show\_status | 11 || Com\_show\_innodb\_status | 0 || Com\_show\_tables | 124 || Com\_show\_variables | 0 || Com\_slave\_start | 0 || Com\_slave\_stop | 0 || Com\_truncate | 0 || Com\_unlock\_tables | 0 || Com\_update | 41264 || Connections | 194 || Created\_tmp\_disk\_tables | 2533 || Created\_tmp\_tables | 8605 || Created\_tmp\_files | 0 || Delayed\_insert\_threads | 0 || Delayed\_writes | 0 || Delayed\_errors | 0 || Flush\_commands | 1 || Handler\_delete | 0 || Handler\_read\_first | 429 || Handler\_read\_key | 400442 || Handler\_read\_next | 4515218 || Handler\_read\_prev | 178397 || Handler\_read\_rnd | 355490 || Handler\_read\_rnd\_next | 16955578 || Handler\_update | 41293 || Handler\_write | 3054908 || Key\_blocks\_used | 17823 || Key\_read\_requests | 3593432 || Key\_reads | 15290 || Key\_write\_requests | 74937 || Key\_writes | 0 || Max\_used\_connections | 40 || Not\_flushed\_key\_blocks | 0 || Not\_flushed\_delayed\_rows | 0 || Open\_tables | 512 || Open\_files | 1021 || Open\_streams | 0 || Opened\_tables | 6216 || Questions | 561566 || Select\_full\_join | 0 || Select\_full\_range\_join | 0 || Select\_range | 2657 || Select\_range\_check | 0 || Select\_scan | 87519 || Slave\_running | OFF || Slave\_open\_temp\_tables | 0 || Slow\_launch\_threads | 0 || Slow\_queries | 0 || Sort\_merge\_passes | 0 || Sort\_range | 39993 || Sort\_rows | 355490 || Sort\_scan | 6480 || Table\_locks\_immediate | 423467 || Table\_locks\_waited | 0 || Threads\_cached | 0 || Threads\_created | 41 || Threads\_connected | 41 || Threads\_running | 1 || Uptime | 7859 |±-------------------------±----------+ ---
**Author:** ![mikec](https://avatars.discourse-cdn.com/v4/letter/m/977dab/32.png) [@mikec](https://forums.percona.com/u/mikec)\ **Post date:** [November 22, 2007, 8:18pm UTC](https://forums.percona.com/t/created-tmp-disk-tables/528/2 "2007-11-22T20:18:23Z")
Also try increasing tmp\_table\_size from its default value.