>
> 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

Reply via email to