Hello Igor,
I was looking at sort-intersect and noticed the following: Consider this table:
CREATE TABLE `t1` (
`k1` int(11) DEFAULT NULL,
`k2` int(11) DEFAULT NULL,
`filler` char(100) DEFAULT NULL,
KEY `k1` (`k1`),
KEY `k2` (`k2`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
Let's try
Hello,
index_merge uses @@sort_buffer_size as a guide of how much space it can use for
sorting. I think there is an issue with the way it is done.
Before index_merge was introduced, @@sort_buffer_size was used only by
filesort (also for couple of other cases like GROUP_CONCAT with sorting, but I
On 01/19/2011 02:32 PM, Sergey Petrunya wrote:
Hello,
index_merge uses @@sort_buffer_size as a guide of how much space it can use
for
sorting. I think there is an issue with the way it is done.
Before index_merge was introduced, @@sort_buffer_size was used only by
filesort (also for
3 matches
Mail list logo