>>>>> "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
