Hi.
A quick search for "temporary files" results in
http://www.mysql.com/doc/T/e/Temporary_files.html
The best guess is that it is the result of massive sorting.
Why this happens (or better: is noticible) only on the new server, I
have no idea of.
Bye,
Benjamin.
On Mon, Oct 01, 2001 at 01:45:09PM -0700, [EMAIL PROTECTED] wrote:
>
> Could someone explain to me how/when mysql uses temp files.. running a
> new dedicated db server with twice as much ram as the old one, and the
> new one keeps dumping 400+mb data into a temp file when the database is
> searched, both with LIKE and MATCH/AGAINST statements... i have never
> looked to see how big the tmp files actually get because it crashes our
> coldfusion servers in the process. I am confused as to why this would
> happen on the new server when it doesnt on the old one
>
--
[EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
