[development] Good article on MEMORY temp tables in MySQL
gerhard at killesreiter.de
Sat Aug 18 09:36:01 UTC 2007
-----BEGIN PGP SIGNED MESSAGE-----
Robert Douglass schrieb:
> For those of you who like reading performance tuning stuff:
> 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.
You wouldn't believe the amazing mySQL bugs Narayan has discovered in
that area. ;(
"BLOB/TEXT columns are not supported with MEMORY storage engine so must
use on disk MyISAM temporary table."
There are a number of queries that could be improved to not use e.g. the
teaser. I think it would be better if the query would first get the nids
in the requested order and then in a second step get the needed teasers.
Of course, the /tmp partition mySQL writes to is mapped to memory, so
the difference between in memory and on disk shouldn't be that large.
In other news: A new slow query log is available on the infra list.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
-----END PGP SIGNATURE-----
More information about the development