Michael Dykman wrote on Fri, Sep 21, 2007 at 01:37:57PM -0400: > 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
yes, several times. both max_heap_table_size and tmp_table_size have remained at the defaults. even still, these temp tables are not that big and _should_not_ be bumping into that limit. and they never have hit that limit in the four to five years this code has been in production. at the moment i have everything running and stable with all slaves replicating cleanly. -- +----------------+-------------------------------+---------------------------+ | 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 | +----------------------------------------------------------------------------+ Lunatic Asylum, n.: The place where optimism most flourishes.
pgpbbyOEiGP5U.pgp
Description: PGP signature