Marten Lehmann wrote:
that is the sort of thing that I expected and was afraid of. Also, I
think the mysql documentation doesn't really point out that temporary
tables are always kept in memory. Couldn't mysql create them in
/tmp/<proc-id>.<table-name> instead?
Actually I was just reading through the docs about this the other day.
It said temp tables are always created in memory, but can be moved to
disk if they get too large, or will be created on disk initially if the
table contains a certain type of field (maybe text or binary, can't
remember).
-Ryan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]