----- Original Message -----
> From: "Joey L" <mjh2000@stripped>
> I know why the files are being created - but is there anything i can
> do on the server to accomodate for large file operations ?
*We* don't, however :-) If you'd care to enlighten us as to the particular job and why
[you believe that] the tempfile creation is unavoidable, we might be able to offer
> max_heap_table_size = 256M
> tmp_table_size = 256M
Maybe. Those would help as long as your intermediate resultset is lower than what you can
allocate to them, but you're talking 22G in the machine and 30G of data. You also need to
realize that those are going to be allocated per-connection (albeit not necessarily at
full size), so that can be a potential disaster.
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel