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 this answer helpful?

 Print this Article

Also Read

Free script that hides links?

Posted by bambinou, 11-12-2012, 04:29 AMHello, I would like to know if you have ever seen a...

order and login issues

Posted by zomby, 03-21-2007, 11:40 PMHi everyone, I have installed plesk as control panel for...

kernel exploit!

Posted by tkanaco, 06-27-2008, 11:27 PMHow Can i translate An Kernel Exploit to secure my server...

Eaccellerator?

Posted by dragon2611, 01-12-2008, 09:13 PMI believe I understand what it does (cache php scripts...

wordpress jquery

Posted by Seeking Knowledge, 10-16-2012, 08:43 AMHi there, I'm facing a problem with few...