On Fri, Mar 16, 2001 at 10:48:59PM +0900, Cho Bum Rae wrote:
> I tried to query below,
> "select src_ip, byte, packet from table group by src_ip order by bytes desc limit 10"
>
> Then DB said, "ERROR 1114: The table 'SQL2997368_0' is full."
>
> What is problem?
>
It really helps to search the list archives. Below is a reply I sent to
someone who asked the exact same question:
I've seen this when MySQL uses an internal table for temporary data.
There is a limit on the size of these tables. You can force MySQL to
use a file in its temporary directory to store the results:
set SQL_BIG_TABLES = 1;
An alternative is to do a SELECT SQL_BIG_RESULT ... instead of
SELECT ... . Note that SELECT SQL_BIG_RESULT doesn't work in 3.22.x,
though it is accepted by the parser. You don't mention which version
you use. 'set SQL_BIG_TABLES' works fine in 3.22.x.
Regards,
Fred.
--
Fred van Engen XO Communications B.V.
email: [EMAIL PROTECTED] Televisieweg 2
tel: +31 36 5462400 1322 AC Almere
fax: +31 36 5462424 The Netherlands
---------------------------------------------------------------------
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
