r(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
lijk 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
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 in
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 | Dyn
[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 s
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
> 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
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 l
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?
"Ralf R. Kotowski" wrote:
>
> 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 u
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 Ra
11 matches
Mail list logo