There is a setting in your my.cnf which specifies the threshold at which temporary tables will be put to disk instead of being held in RAM. This has to be a dynamic decision as the system has to consider available RAM and the size of any given temporary table.. under normal circumstances, the my.cnf setting will be respected, but it is NOT a guarantee.
Have you read this? http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html#option_mysqld_tmp_table_size - michael dykman On 9/21/07, Chris Scheller <[EMAIL PROTECTED]> wrote: > Michael Dykman wrote on Fri, Sep 21, 2007 at 12:19:23PM -0400: > > Your issue might be related to the host OS, namely a per-process limit > > on file handles. What OS are you using? > > that is definitely part of the problem. since so many temporary tables > are being created, mysqld just shits itself after awhile. my main > problem, as i see it is that these temp tables are being written to > disk in the first place. prior to my server switch this wasn't the > case. in any case, the box is slackware-11.0 and this is > mysql-4.0.17(yes i know it is old, and i did try to migrate to 5 with > not fun results. updating this code base to support mysql-5.0.x, just > isn't an option right now.) > > > -- > +----------------+-------------------------------+---------------------------+ > | Chris Scheller | http://www.pobox.com/~schelcj | JID: [EMAIL PROTECTED] | > +----------------+-------------------------------+---------------------------+ > | "Ubuntu" -- an African word, meaning "Slackware is too hard for me" | > | "Mandriva" -- a French word, meaning "Slackware is too hard for me" | > | "Fedora" -- an American word, meaning "Slackware is too hard for me" | > | -- seen on alt.os.linux.slackware | > +----------------------------------------------------------------------------+ > "I was playing poker the other night ... with Tarot cards. I got a full > house and four people died." > -- Steven Wright > > -- - michael dykman - [EMAIL PROTECTED] - All models are wrong. Some models are useful. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
