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

Hjalp dette svar dig?

 Print denne artikel

Læs også

SQL DB backup error !

Posted by htw_Mehdi, 09-14-2007, 09:28 PMhello, when i try to backup mysql database on the...

htaccess redirect dynamic URL to dynamic URL

Posted by Badie, 12-29-2007, 07:51 AMHi I have a page that show articles in my site , the url...

Cronjob issue

Posted by CymraegWalesHosting, 11-16-2012, 11:25 PMHi all, Hopefully this is a simple fix....

Changing File ext. to File

Posted by haleyhosting_com, 03-24-2007, 01:31 PMi have a site upithere.com . its a pretty popular...

Object Oriented Programming in PHP

Posted by That Guy, 03-19-2007, 11:03 PMWhy? I want to make a login script, but I'm not sure if I...