= 38M
> > > > query_cache_size = 256M
> > > > query_cache_type = 1
> > > > query_prealloc_size = 65536
> > > > query_alloc_block_size = 131072
> > > > default-storage-engine = MyISAM
> > > >
> > > >
> > > > On
t; [EMAIL PROTECTED]> wrote:
> > > >
> > > > It goes to a temporary table when MySQL does not have enough memory
> > > > (allocated) to store the temporary results in memory, so it needs to
> > > > create
> > > > a temporary table on
store the temporary results in memory, so it needs to
> > > create
> > > a temporary table on disk.
> > >
> > > Try increasing the memory buffer size or eliminating more rows from
> > the
> > > query.
> > >
> > > -Original M
y table on disk.
> >
> > Try increasing the memory buffer size or eliminating more rows from the
> > query.
> >
> > -Original Message-
> > From: Mike Zupan [mailto:[EMAIL PROTECTED]
> > Sent: Friday, 10 August 2007 4:52 AM
> > To: mysql@lists.m
sk.
>
> Try increasing the memory buffer size or eliminating more rows from the
> query.
>
> -Original Message-
> From: Mike Zupan [mailto:[EMAIL PROTECTED]
> Sent: Friday, 10 August 2007 4:52 AM
> To: mysql@lists.mysql.com
> Subject: remove temporary table from SE
[mailto:[EMAIL PROTECTED]
Sent: Friday, 10 August 2007 4:52 AM
To: mysql@lists.mysql.com
Subject: remove temporary table from SELECT query
I have been pulling my hair out over a temporary table being created in the
following query
SELECT SQL_NO_CACHE SQL_CALC_FOUND_ROWS entryid,title FROM
I have been pulling my hair out over a temporary table being created in the
following query
SELECT SQL_NO_CACHE SQL_CALC_FOUND_ROWS entryid,title FROM
friends_test INNER JOIN entries ON friendLink=userid AND userLink=2 order by
entryid
if I change userLink=2 to friendLink=2 it is fine and its ver
