Creating temp tables on disk... why?

Posted by Jcink, 05-07-2007, 09:50 PM
Hi, In phpMyAdmin I see this: Created_tmp_disk_tables 2,118 The number of temporary tables on disk created automatically by the server while executing statements. If Created_tmp_disk_tables is big, you may want to increase the tmp_table_size value to cause temporary tables to be memory-based instead of disk-based. Created_tmp_files 0 How many temporary files mysqld has created. Created_tmp_tables 5,637 The number of in-memory temporary tables created automatically by the server while executing statements. I have tried upping tmp_table_size but it's no use. My my.cnf file: This server has 1GB of RAM, not a dedicated sql server though. RAM usage is low too, 567MB of RAM is being used right now total... is there something I'm overlooking? Thanks, dan

Hjälpte svaret dig?

 Skriv ut denna artikeln

Läs även

PERM_FAILURE: SMTP Error (state 14)

Posted by Fahd, 03-29-2008, 05:42 PMMy mailserver has stopped accepting mail from all non-local...

aletia reseller

Posted by hostchecker, 09-27-2001, 05:36 PMwhas the URL for aletia reseller plans? Posted by...

When blog works forums stops working and viceversa

Posted by sash_007, 03-10-2010, 08:47 PMHello friends, I am having a weird problem my problem is...

Editting the default web page using SSH

Posted by MrDGOrman, 03-09-2010, 09:44 AMThis might be in the wrong section - if so, ma bad....

Linux: backup hard drive mounted to /backup

Posted by UberTricep, 11-10-2012, 07:49 AMI have a new dedicated server and I ordered a backup...