Hi, We're running MySQL 3.23.49 under Debian Linux with a 2.4.19 kernel.
I've got a 2-part question about tmp_table_size. 1) I've tried setting 'tmp_table_size' from the MySQL command interpreter, and I keep getting told that I have an SQL syntax error. The command is : set tmp_table_size="500000000"; Does this mean that tmp_table_size can't be changed in this way? 2) Does 'tmp_table_size' have an impact on the allowable max size for HEAP tables? For performance reasons I can't just set the BIG_TABLES option - the main table in the application has to be a HEAP table (or have I misunderstood how BIG_TABLES works ??). Any pointers/useful comments greatfully received :-) Regards, Paul Wilson Chime Communications Ltd --------------------------------------------------------------------- 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
