----- Original Message ----- > From: "Joey L" <mjh2...@gmail.com> > > 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 something more. > 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
