Re: a problem (The table 'SQL134597_0' is full)

[Pete Harlan]

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

From the manual:

	16.1.6 The table is full error

	This error occurs when an in-memory temporary table becomes larger
	than tmp_table_size bytes. To avoid this problem, you can
	use the -O tmp_table_size=# option to mysqld to increase the temporary
	table size, or use the SQL option
	SQL_BIG_TABLES before you issue the problematic query. See section
	7.24 SET OPTION syntax. 

	You can also start mysqld with the --big-tables option. This is
	exactly the same as using SQL_BIG_TABLES for all
	queries.

My /etc/my.cnf includes:

	[mysqld]
	set-variable = tmp_table_size=8M

which solves this problem for me.

HTH,

--
Pete Harlan
harlan@stripped