On Thu, Dec 18, 2003 at 10:37:46AM -0600, Dan Nelson wrote :
> In the last episode (Dec 18), Markus Fischer said:
> > On Tue, Dec 16, 2003 at 10:38:14AM -0600, Dan Nelson wrote :
> > > Raising sort_buffer_size and join_buffer_size may also help if your
> > > queries pull a lot of records.
> >
>
In the last episode (Dec 18), Markus Fischer said:
> On Tue, Dec 16, 2003 at 10:38:14AM -0600, Dan Nelson wrote :
> > Raising sort_buffer_size and join_buffer_size may also help if your
> > queries pull a lot of records.
>
> From what I read from the manual, sort_buffer_size is only used
>
On Tue, Dec 16, 2003 at 10:38:14AM -0600, Dan Nelson wrote :
> In the last episode (Dec 16), Markus Fischer said:
> > I'm investigating a performance problem with mysql server set up. The
> > server is running linux with 1GB ram. I'ld like to tune the
> > configuration of the server to use as much
Hi,
On Tue, Dec 16, 2003 at 10:23:05PM +1100, Chris Nolan wrote :
> How heavy is your usage of TEMPORARY TABLES? I don't use them much
> myself, but I'm sure that the others on the list will have something
> to say in that regard.
Here are the relevant numbers:
Created_tmp_disk_tables
In the last episode (Dec 16), Markus Fischer said:
> I'm investigating a performance problem with mysql server set up. The
> server is running linux with 1GB ram. I'ld like to tune the
> configuration of the server to use as much RAM as possible without
> swapping to the disc because of the big slo
Hi!
How heavy is your usage of TEMPORARY TABLES? I don't use them much
myself, but
I'm sure that the others on the list will have something to say in that
regard.
To get a better look at MySQL's usage of memory, you could try looking
at the output of
SHOW STATUS .
Regards,
Chris
Markus Fisc
