From: kabel (listsvoidship.net)
Date: Wed Apr 21 2010 - 14:10:38 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Using 5.0.51, I have a fairly substantial SELECT ... GROUP BY query to
which I have added the "SQL_BIG_RESULT" hint.

According to the 5.0 SELECT manual,
"SQL_BIG_RESULT can be used with GROUP BY or DISTINCT to tell the
optimizer that the result set has many rows. In this case, MySQL
directly uses disk-based temporary tables if needed, and prefers sorting
to using a temporary table with a key on the GROUP BY elements."

However, during query execution, I saw "Converting HEAP to MyISAM" in
the processlist for that thread. I may be misunderstanding the manual,
but shouldn't that hint force the temporary table to disk rather than a
HEAP table?

Thanks for any help anyone can provide,

kabel

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]