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

Kas see vastus oli kasulik?

 Prindi artikkel

Loe veel

Warning: shell_exec() has been disabled for security reasons

Posted by ashish1987, 09-15-2007, 12:39 AMHey I installed status2k on my server and i am...

Mail the reach the mailbox

Posted by igalst, 05-08-2007, 08:41 AMHello, I have a VPS running Windows 2003 with Plesk 8.1...

yum broken

Posted by chielsen, 12-18-2007, 02:20 PMI have waisted all not trying to get subversion working...

max_allowed_packet error

Posted by vnsg, 09-15-2007, 12:39 AMOne of my client use VBB 3.6.7 and have error when try to...

Include and run a script within a program

Posted by Sammyboy99, 02-18-2011, 06:53 PMSo I've made a program that executes a script the only...