Hi!
>>>>> "Sasha" == Sasha Pachev <[EMAIL PROTECTED]> writes: Sasha> On Monday 04 March 2002 02:41 pm, Vladimir V. Kolpakov wrote: >> ------ >> P.S. so far, it's helpful bug: I use it as catch >> for poor queries!:) Sasha> This actually gives me an idea for a feature. --disable-disk-temp-tables - Sasha> fail all queries that need a disk temp table, and --restrict-disk-temp-tables Sasha> - allow creation of a temporary disk table only if the user has set Sasha> SQL_BIG_RESULT. Sasha> I think our users would love it, especially the ISP's with lots of users Sasha> running all kinds of problem queries that they do not have much control over. Sasha> Monty - what do you think? The problem with this is that a lot of queries requires disk based temporary tables. By disabling these a lot of queries, especially GROUP BY and DISTINCT queries, will unexpectedly stop working. The rules when MySQL uses a disk based instead of a memory based table is also quite hard to formalize, so this could easily cause more confusion that it's worth. Instead of disabling disk based temp tables, we could instead restrict the size of them which should be equally good. (By setting the disk size to 0 you would be able to disable them, but we should not recommend this setting). Regards, Monty --------------------------------------------------------------------- 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
