List:General Discussion« Previous MessageNext Message »
From:Michael Widenius Date:May 24 1999 1:02am
Subject:Re: a problem (The table 'SQL134597_0' is full)
View as plain text  
>>>>> "glen" == glen  <glen@stripped> writes:

glen> Pete Harlan wrote:
>> > i have sql clause like this:
>> > insert into stat_tmp1 (v) select HTTP_REFERER from log_sessions,log_hits
> where
>> > log_sessions.time>'19990518' and log_sessions.time<='19990518
> 23:59:59' and
>> > log_sessions.ID=log_hits.session_ID group by session_ID
>> >
>> > and getting this error:
>> > ERROR 1114 at line 1: The table 'SQL134595_0' is full
>> > Try #1...
>> 
>> My /etc/my.cnf includes:
>> 
>> [mysqld]
>> set-variable = tmp_table_size=8M
>> 
>> which solves this problem for me.

glen> ok, thanx, as i don't want to add that all queries should be done with disk
glen> buffering (--big-tables option)
glen> the question is to how big this tmp_table_size should be set?

glen> number_of_records seclected*size_of_all_fields_together in that query?

Yes.

(MySQL 3.23 will not have this problem anymore;  It will automaticly
convert in memory heap tables to disk based heap tables if the heap
table grows over tmp_table_size).

Regards,
Monty
Thread
DISTINCT and COUNT() SQL QueryMike Machado1 May
  • Re: DISTINCT and COUNT() SQL Queryjkraai1 May
    • Re: DISTINCT and COUNT() SQL QueryPaul DuBois1 May
  • RE: DISTINCT and COUNT() SQL QueryDon Read1 May
  • Re: DISTINCT and COUNT() SQL QueryMike Machado1 May
    • Re: DISTINCT and COUNT() SQL QueryThimble Smith1 May
  • Re: DISTINCT and COUNT() SQL QueryJim Faucette1 May
  • 3.22.21 RAM Usagejkraai2 May
    • 3.22.21 RAM UsageMichael Widenius2 May
  • Re: 3.22.21 RAM Usagejkraai2 May
  • a problemglen19 May
    • Re: a problem (The table 'SQL134597_0' is full)Pete Harlan20 May
      • Re: a problem (The table 'SQL134597_0' is full)glen20 May
        • Re: a problem (The table 'SQL134597_0' is full)Benjamin Pflugmann21 May
        • Re: a problem (The table 'SQL134597_0' is full)Michael Widenius24 May