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
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 enou
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.
TIA,
R.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://
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