Hi, Your setting tmp_table_size is probably very low. (something like 1048576) Try increasing your value to 2M or 4M, and you might want to increase your key_buffer as wel to 16M.
I would also like to advise you to rephrase your query to something that looks like: select * from players inner join on roster Roster.playerId=Players.id order by player.plast limit 1,10 or use a left join. The above query syntax uses less memory. >> select * from Players,Roster where Roster.playerId=Players.id order by >> Players.plast limit 1,10 Regards, Almar van Pel -----Oorspronkelijk bericht----- Van: Mayo, Chuck [mailto:[EMAIL PROTECTED]] Verzonden: donderdag, december 13, 2001 04.11 Aan: '[EMAIL PROTECTED]' Onderwerp: JOIN and Table Full error Hi all, I'm pretty new with MySQL and am trying to implement my first join. All works as expected until I try to order the output with an "order by" clause; select * from Players,Roster where Roster.playerId=Players.id order by Players.plast limit 1,10 and I receive an error from the MySQL interpreter; ERROR 1114: The table 'SQLe1b02_0' is full I have no tables by that name, must be a temp? There seems to be ample space in my filesystem, can someone tell me why this is happening and, even better, how to fix it? --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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
