Hi.
As said in the mail before yours, you can set this option for single
queries. See section 7.24 SET OPTION syntax.
He already gave an example on what fits for him.
What fits for you heavily depends on your databases and the queries
you run and has to be figured out by yourself. One method is to
increase it (in 1MB steps for example) until you get no more errors
and then add a spare part (for example 50%) which you feel comfortable
with.
Bye,
Benjamin.
On Thu, May 20, 1999 at 12:20:08PM +0300, glen@stripped wrote:
> 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.
>
> ok, thanx, as i don't want to add that all queries should be done with disk
> buffering (--big-tables option)
> the question is to how big this tmp_table_size should be set?
> number_of_records seclected*size_of_all_fields_together in that query?
>
> --
> glen
>
>
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail mysql-thread3621@stripped
>
> To unsubscribe, send a message to the address shown in the
> List-Unsubscribe header of this message. If you cannot see it,
> e-mail mysql-unsubscribe@stripped instead.
Attachment: [application/pgp-signature]
