Michael Grover wrote:
>
> This simple query:
>
> create temporary table mike select * from wy
> union all
> select * from ks;
>
> will cause the following error:
>
> "[root@localhost:3306] ERROR 1114: The table '#sqla08_3_1' is full"
>
> what's wierd is I only have a "#sqla08_3_0" table in my c:\winnt\temp
> dir...
>
> The second table is being created in memory, If you increase
> "max_heap_table_size" enough to cover the total result size, there is no
> error.
>
> What Im worried about is that if you have alot of user's, Alot of memory
> will get used fast for unions?
>
> mike
>
> Colin Faber wrote:
> >
> > Um.. by default the temp table should "spill" into a scratch disk like
> > swap system.. normally this is handled in /tmp possibly you're
> > allocating all available real memory all swap and filling /tmp.
> >
> > Look into that.
> >
> > Mike Grover wrote:
> > >
> > > It's memory, A query with a union apparently uses memory to do a union
> > > Before it pushes the results into a temp table?
> > >
> > > Any way around this?
> > >
> > > mike
> > >
> > > -----Original Message-----
> > > From: Colin Faber [mailto:[EMAIL PROTECTED]]
> > > Sent: Wednesday, May 15, 2002 2:58 PM
> > > To: Mike Grover
> > > Cc: [EMAIL PROTECTED]
> > > Subject: Re: Temp Table size?
> > >
> > > Hi Mike,
> > >
> > > Possibly out of available memory. (Or disk space assuming that's what
> > > it's hitting)
> > >
> > > Mike Grover wrote:
> > > >
> > > > When I create a temp table, If I put to much in it,
> > > > I get a "Temp Table [Table name] is Full" error.
> > > >
> > > > I changed my tmp_table_size to a ver large number.
> > > >
> > > > Still same error, Any Ideas?
> > > >
> > > > This is windows 2000
> > > > MySQL 4.01
> > > > Config Loaded Form my.ini in winnt dir.
> > > >
> > > > Show Variables for server shows new tmp_table_size set
> > > > In ini file.
> > > >
> > > > mike
> > > >
> > > > ---------------------------------------------------------------------
> > > > Before posting, please check:
> > > > http://www.mysql.com/manual.php (the manual)
> > > > http://lists.mysql.com/ (the list archive)
> > > >
> > > > To request this thread, e-mail <[EMAIL PROTECTED]>
> > > > To unsubscribe, e-mail
> > > > <[EMAIL PROTECTED]>
> > > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> > >
> > > --
> > > Colin Faber
> > > (303) 736-5160
> > > fpsn.net, Inc.
> > >
> > > ---------------------------------------------------------------------
> > > Before posting, please check:
> > > http://www.mysql.com/manual.php (the manual)
> > > http://lists.mysql.com/ (the list archive)
> > >
> > > To request this thread, e-mail <[EMAIL PROTECTED]>
> > > To unsubscribe, e-mail
> > > <[EMAIL PROTECTED]>
> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> >
> > --
> > Colin Faber
> > (303) 736-5160
> > fpsn.net, Inc.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
