-
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
|
|
+---+--+--+-++--
--+
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
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
Hello,
I keep getting this:
insert into tmp select * from ascend_log_2001_08_25;
ERROR 1114: The table 'tmp' is full
tmp is a heap table
I've looked through the docs and mailing list archives and can't find anything
that matches my problem. I'm using 3.23.41 so it should switch to disk if it
[EMAIL PROTECTED] wrote:
Hello,
I keep getting this:
insert into tmp select * from ascend_log_2001_08_25;
ERROR 1114: The table 'tmp' is full
tmp is a heap table
There is a size limit to temp tables. See:
http://www.mysql.com/doc/F/u/Full_table.html about increasing the allowed size
for
That's what I thought at first as well. But my tmp_table_size is set to 64MB
and I used the --big-tables option just to be sure.
Also, show table status says the size is well below 64MB:
Name | Type | Row_format | Rows| Avg_row_length | Data_length | Max_data_length
tmp| HEAP |
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?
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
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."
MySQL tries to create a temporary table to handle your "order by" command.
These tables are usually created in /tmp
Ok I get a table is full error...
So how/where do I set the tmp_table_size ? or the BIG_TABLES
option so that its started that way at system start-up?
from what I gather the Big_Tables option writes ALL tmp tables to
disk, is that correct? so I should use tmp_table_size instead (got
512 MB
10 matches
Mail list logo
