<pre>><i> This could be particularly relevant to <a href="http://Drupal.org">Drupal.org</a> if we are still<br></i>><i> getting temp tables written to disk. It turns out that even when we<br></i>><i> specify MEMORY for temp tables, MySQL still has the option of writing to
<br></i>><i> disk if other buffers aren't large enough.</i></pre>This problem has been driving me totally nuts for months now. Until I read this I've assumed that it was something that I was missing/doing wrong. Thanks for sharing the 411.