On Tue, Feb 17, 2004 at 01:18:45PM -0800, lee wrote: > We are trying to do some capacity planning, and we need to know how MySQL > allocates the the filespace in the directories set by the tmpdir > configuration parameter. > > The manual simply states: > "...It may be useful if your default /tmp directory resides on a partition > that is too small to hold temporary tables. Starting from MySQL 4.1, this > option accepts several paths that are used in round-robin fashion." > > How is the work spread around amongst the different tmpdir 'segments' ( the > directories enumerated by ':' in the tmpdir config. variable)? The manual > says the directories are used in a "round-robin" fashion.
I believe it's the first. Each new need for a temp file picks from the round-robin list. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 4.0.15-Yahoo-SMP: up 156 days, processed 1,863,165,389 queries (137/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]