On Sat, Jun 16, 2001 at 12:35:52PM -0500, Dan Nelson wrote:
> In the last episode (Jun 16), Jeremy Zawodny said:
> > Ah, thanks. The funny thing is that I *did* think to check the source
> > code for a different problem I ran into severl minutes later.
> >
> > I'll have to poke at this some more. I just restarted with a 64MB
> > maximum and one of my more common queries is still "Using
> > temporary". I find it difficult to believe that I'm pulling enough
> > data to fill a 64MB table. The entire dataset is about 6 times that
> > size, and I know I'm not pulling even close to 1/6th of the data.
>
> I think all "Using temporary" means is that mysql has to modify the
> result set (i.e. sort or group it) before passing it to the client.
> The temp table will stay in RAM unless it gets larger than the
> tmp_table_size value, so to tell whether a particular query needed
> an on-disk temp table, you'll probably have to compare the
> created_tmp_disk_tables stat value before and after the query.
Err, I forgot to mention that there's a "Using filesort" in the output
as well. That makes me believe it wants to write to disk (even if
there may be sufficient RAM).
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 439-9951
MySQL 3.23.29: up 0 days, processed 3,104,493 queries (72/sec. avg)
---------------------------------------------------------------------
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