Re: large temp files created by mysql

[Joey L]

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