Btw, this is using the InnoDB engine.
-Original Message-
From: Robert DiFalco
Sent: Tuesday, October 17, 2006 9:26 AM
To: mysql@lists.mysql.com
Subject: References on Optimizing File Sort
I have an unavoidable filesort in a very large query. Can someone point
me to references for
Robert, off the top of my head, you'll probably want to make the
sort_buffer_size as large as you can, keeping in mind that this memory
setting is allocated per thread. In other words, if you have up to 32
threads, and you allocate 100 MB to this setting, you could eat up
3200 MB this way if
On Tue, 2006-10-17 at 09:26 -0700, Robert DiFalco wrote:
I have an unavoidable filesort in a very large query. Can someone point
me to references for optimizing filesort? I'm assuming this is going to
be changes to my.ini or the hardware.
Well, one method to *eliminate* Using filesort is to