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

Hasznosnak találta ezt a választ?

 Kinyomtatja ezt a cikket

Olvassa el is

forums don't send to free mails like hotmail !

Posted by MrAdmin, 07-17-2007, 06:33 PMHi, Email on server working fine, I can send mails from...

Reseller account with H-Sphere?

Posted by dontknownutn, 09-04-2002, 10:02 PMWhere can I get a private label reseller package with...

weird disk usage shown in server

Posted by prashant1979, 09-18-2008, 08:28 AMHello, I am seeing a weird disk usage in one of my...

How to automaticaly download all files in a folder via FTP?

Posted by viettechorg, 05-07-2007, 03:41 AMHello there, I am having trouble with moving my files...

Hosting With support for MS SBS 4.5?

Posted by SimonC, 09-29-2001, 09:26 AMDoes anyone know of a reseller package with support for...