Hello, > If a person forgets to drop temp tables and stays within a connection
for hours or even days, memory resources can be overloaded a lot of temp tables. Furthermore, loading temp tables with a GB of data is bad practice but is possible under such circumstances.
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?
Regards Marten -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]