On Sun, Mar 24, 2002 at 08:22:59AM -0700, Tom Brettin wrote: > What are the various reasons that could explain the following error > message. It happens as a result of an equi-join. > > The table 'SQL746e7_0' is full > > How can I get additional information such as where is that table being > written to disk (I could check the amt of free disk space).
Try adjusting tmp_table_size. This is a FAQ. -- Michael Bacarella | Netgraft Corporation | 545 Eighth Ave #401 Systems Analysis | New York, NY 10018 Technical Support | 212 946-1038 | 917 670-6982 Managed Services | [EMAIL PROTECTED] --------------------------------------------------------------------- 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