Hi ,
"ORDER BY", will always use some temporary table for doing sort operation.
For that matter, any group function, like min,max,group by,order by will use
temporary table before displaying the final results.
Regards
anandkl
On 8/10/07, Mike Zupan <[EMAIL PROTECTED]> wrote:
>
> neither of those
neither of those have fixed the issue.. I can create a sample database if
anyone wants it to be of some help.
Mike
On 8/10/07, Ananda Kumar <[EMAIL PROTECTED]> wrote:
>
> Also, its not good to set sort_buffer_size=256M, as this much of memory
> will get allocated to each session, and if u have mo
Also, its not good to set sort_buffer_size=256M, as this much of memory will
get allocated to each session, and if u have more than 10 connections at any
point of time then it will more than 2GB RAM will get allocated and system
will be slow.
I feel sort_buffer_size=1MB should be good in my.cnf
Yo
at your mysql prompt
set sort_area_size=1;
try this
regards
anandkl
On 8/10/07, Mike Zupan <[EMAIL PROTECTED]> wrote:
>
> Which is the my.cnf entry I need to increase. I'm only getting around 4k
>
> back_log = 75
> skip-innodb
> max_connections = 500
> key_buffer = 512M
> sort_buffer_s
Which is the my.cnf entry I need to increase. I'm only getting around 4k
back_log = 75
skip-innodb
max_connections = 500
key_buffer = 512M
sort_buffer_size = 256M
join_buffer_size = 128M
read_buffer_size = 128M
sort_buffer_size = 128M
table_cache = 1800
thread_cache_size = 384
wait_timeout = 7200
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 disk.
Try increasing the memory buffer size or eliminating more rows from the
query.
-Original Message-
From: Mike Zupan [ma