> > You should do EXPLAINs on your slow-running queries to find out which ones > are likely... If it is generating a 30gig file, I'd expect it must be a very > slow query. >
I know why the files are being created - but is there anything i can do on the server to accomodate for large file operations ? in my.cnf ? possibly? I have 22gig of ram -- should i bump these up ??? anything else ? table_cache = 256M max_heap_table_size = 256M tmp_table_size = 256M thanks mjh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org