Hi!
On Feb 17, Jeremy Zawodny wrote:
> 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.
Yes, it's how it works.
Regards,
Sergei
--
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
