[development] Good article on MEMORY temp tables in MySQL
Robert Douglass
rob at robshouse.net
Sat Aug 18 07:53:58 UTC 2007
For those of you who like reading performance tuning stuff:
http://www.mysqlperformanceblog.com/2007/08/16/how-much-overhead-is-caused-by-on-disk-temporary-tables/
This could be particularly relevant to Drupal.org if we are still
getting temp tables written to disk. It turns out that even when we
specify MEMORY for temp tables, MySQL still has the option of writing to
disk if other buffers aren't large enough.
-R
More information about the development
mailing list