On Sat, Jun 16, 2001 at 08:00:04PM -0500, Dan Nelson wrote:
> In the last episode (Jun 16), Jeremy Zawodny said:
> > 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).
>
> I
In the last episode (Jun 16), Jeremy Zawodny said:
> 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).
I'm not sure "Using filesort" actually means it is going to create a
file
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.
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 quer
gt; From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: 16 June 2001 15:33
> To: Dan Nelson
> Cc: [EMAIL PROTECTED]
> Subject: Re: What does tmp_table_size *really* do?
>
>
> On Fri, 15 Jun 2001, Dan Nelson wrote:
> > 30 seconds of cscope browsing on the mysql source
A better tool is Source Navigator,
available at Red Hat site.
It's Cscope on steroids!
Kevin
[EMAIL PROTECTED] wrote:
>
> On Fri, 15 Jun 2001, Dan Nelson wrote:
> > 30 seconds of cscope browsing on the mysql source shows the follwing
> ^^
>
On Fri, 15 Jun 2001, Dan Nelson wrote:
> 30 seconds of cscope browsing on the mysql source shows the follwing
^^
What is cscope? Where can I get it? =)
Sincerely,
Jan
--
Mr. Jan-Aage Bruvoll IT Project Manager
20 Min Holding, Thurgauerstrasse 40, CH-8050 Zurich
O
On Fri, Jun 15, 2001 at 10:03:57PM -0500, Dan Nelson wrote:
>
> 30 seconds of cscope browsing on the mysql source shows the follwing
> comments right before calls to create_tmp_table():
>
> /* Create a tmp table if distinct or if the sort is too complicated */
> /* group data to new table */
>
In the last episode (Jun 15), Jeremy Zawodny said:
> The manual (http://www.mysql.com/doc/S/H/SHOW_VARIABLES.html) states:
>
> If an in-memory temporary table exceeds this size, MySQL will
> automatically convert it to an on-disk MyISAM table. Increase the
> value of tmp_table_size if you d
The manual (http://www.mysql.com/doc/S/H/SHOW_VARIABLES.html) states:
If an in-memory temporary table exceeds this size, MySQL will
automatically convert it to an on-disk MyISAM table. Increase the
value of tmp_table_size if you do many advanced GROUP BY queries and
you have lots of memor
10 matches
Mail list logo
