Hi Phil,
Since u dont have where condition, doing a full table scan is better.
in mysql, group by also does SORTING, as if you have specified an explicit
"ORDER BY". So you can avoid ORDER BY and see if the select are same with
both group by and order by. But still you would see a FILESORT in the
Any settings which would let mysql do this in memory ? There is 8Gb Ram on
the box dedicated for mysql.
my.cnf snippet as follows
old_passwords=1
key_buffer_size=2048M
max_allowed_packet=16M
thread_stack=128K
thread_cache_size=64
thread_concurrency=8
sort_buffer_size=32M
join_buffer_size=3M
read_
Phil wrote:
I have a table as follows containing approx 1.5M rows. I pull data from it
based on the CPID and insert into an 'overall' table. After breaking down
the statement somewhat, an explain still gives a filesort. Is there any way
to avoid a filesort for this query ?
mysql> explain select
