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]

Reply via email to