RE: JOIN and Table Full error
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
RE: JOIN and Table Full error
| | | nearestElementary | varchar(40) | | || | | registrationDate | date | | | -00-00 | | | fextension| int(4) | | | 0 | | | mextension| int(4) | | | 0 | | | eextension| int(4) | | | 0 | | | yearstamp | int(4) | | | 0 | | | seasonstamp | varchar(10) | | || | | ageGroup | tinyint(2) | YES | | NULL | | | comment | varchar(255) | YES | | NULL | | | seasonPlayed | varchar(255) | YES | | NULL | | +---+--+--+-++-- --+ 48 rows in set (0.00 sec) -Original Message- From: Almar van Pel [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 13, 2001 9:33 AM To: Mayo, Chuck Cc: [EMAIL PROTECTED] Subject: RE: JOIN and Table Full error 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
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