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

Esta resposta lhe foi útil?

 Imprimir este Artigo

Veja também

VMWare IIS and SSL mystry

Posted by WebGuru72, 07-18-2007, 12:58 AMHello All, I have a very weird problem, I have a...

/bin Directory

Posted by swurvin, 05-06-2007, 09:12 PMHello. I wonder if anyone has any ideas on how I go about...

let ppl play an mp3 but not let them access the file

Posted by bambinou, 11-10-2012, 09:32 AMHi, I have a folder with many mp3s, I do not want...

Delete files created on a specific date

Posted by Acroplex, 06-28-2008, 08:16 PMIs there a quick shell command to find (inside a...

This guy is running botnet on me....

Posted by Shazz, 08-28-2008, 01:56 AMI have tried everything, hosts that say there secure and can...