MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:mfatene Date:June 15 2005 8:54pm
Subject:Re: Table full
View as plain text  
sorri it's tmp_table_size.

mysql> show variables like '%table%';
+------------------------+----------+
| Variable_name          | Value    |
+------------------------+----------+
| innodb_file_per_table  | OFF      |
| innodb_table_locks     | ON       |
| lower_case_table_names | 1        |
| max_heap_table_size    | 16777216 |
| max_tmp_tables         | 32       |
| table_cache            | 256      |
| table_type             | InnoDB   |
| tmp_table_size         | 9437184  |
+------------------------+----------+
8 rows in set (0.00 sec)


What are :
show create table toto;
the count(*) ?
the query ?



Mathias
Selon Emmett Bishop <dyne_erg@stripped>:

> 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