MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Emmett Bishop Date:June 15 2005 8:50pm
Subject:Re: Table full
View as plain text  
Mathias,

Thanks for the reply. I couldn't find a server
variable named "max_temp_table_size" but I did find
one named "max_heap_table_size". Is that what you
meant? BTW, I forgot to mention that I'm using MySQL
4.0.20. Could it be that this variable that you
mention is only in later versions?

Basically, what I'm trying to do is a multi-table
update statement. If I select too many rows I get the
"Table #sql-123 is full" error. If I bite off a small
enough chunk, the query works.

Thanks again,

Tripp

--- mfatene@stripped wrote:

> hi,
> seems to be a temp table (sybase notation).
> see max_temp_table_size
> 
> Mathias
> Selon Emmett Bishop <dyne_erg@stripped>:
> 
> > Howdy all, I have a question about a SQL statement
> > that I'm trying to execute. When I execute the
> > statement I get the following error: The table
> > '#sql_bd6_3' is full.
> >
> > What does this mean exactly?
> >
> > Thanks,
> >
> > Tripp
> >
> >
> >
> > __________________________________
> > Yahoo! Mail Mobile
> > Take Yahoo! Mail with you! Check email on your
> mobile phone.
> > http://mobile.yahoo.com/learn/mail
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:   
> http://lists.mysql.com/mysql?unsub=1
> >
> >
> 
> 
> 
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:   
>
http://lists.mysql.com/mysql?unsub=1
> 
> 


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 
Thread
How to write subqueries?Unknown Sender14 Jun
  • Re: How to write subqueries?SGreen14 Jun
    • RE: How to write subqueries?Rhino14 Jun
  • RE: How to write subqueries?Rhino14 Jun
  • Re: How to write subqueries?mfatene14 Jun
    • Re: How to write subqueries?Unknown Sender14 Jun
      • Re: How to write subqueries?mfatene14 Jun
        • Table fullEmmett Bishop15 Jun
          • Re: Table fullmfatene15 Jun
            • Re: Table fullEmmett Bishop15 Jun
              • Re: Table fullmfatene15 Jun
                • Re: Table fullEmmett Bishop15 Jun
                  • Re: Table fullmos16 Jun
                    • Re: Table fullEmmett Bishop16 Jun
                      • Re: Table fullmfatene16 Jun
        • Re: How to write subqueries?Unknown Sender15 Jun
    • Re: How to write subqueries?Unknown Sender14 Jun