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

Was dit antwoord nuttig?

 Print dit artikel

Lees ook

Resolve domains to ip

Posted by alphix, 09-21-2008, 12:33 AMHi, I'm trying to write a script that resolves a...

URL Rewrite

Posted by beachcompcom, 03-08-2010, 04:34 PMHi folks, I'm new to IIS7/Url rewrites. Im trying...

How do I control the number of user downloading and the download speed?

Posted by celular, 09-20-2008, 11:04 PMhello, I am planning to rent a dedicated server with...

WHM/Cpanel Exim issue - how to better secure a partially open relay

Posted by MnMNmN, 02-14-2008, 10:04 PMHi all, I have a WHM/CPanel server. I have done some...

constantly blocked on pop3

Posted by Calibaba, 09-14-2007, 05:50 PMI just setup a new pop account in Outlook 2007 and...