[development] merging node tables (was: Drupal 6 code freeze)

Gerhard Killesreiter gerhard at killesreiter.de
Mon Jul 2 18:08:50 UTC 2007


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Dries Buytaert schrieb:

>  6. I'd like to see us merge the node, node_comment_statistics and
> node_counter tables. (Important performance improvement that is likely
> to break APIs.)

This is only a performance improvement if you don't run MyISAM. If you
run MyISAM this will totally push a busy DB server over the edge as it
will cause table locks on the node table for every comment added (or
even every node viewed if you use Drupal's view counter).

Doing this merge (and thus also "won't fix" this issue:
http://drupal.org/node/109037) essentially means "don't run a high load
Drupal site on MyISAM".

Now, this isn't neccessarily a bad message, but I want to make sure that
people know about this message _before_ this is rolled into D6.

Cheers,
	Gerhard
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFGiT8yfg6TFvELooQRAmZUAKCOsQ/2Ki2TuFlxHO807mpTU5owYQCghcQP
y8GHmcHN9r4wtYPNWWlsCpU=
=Qsjd
-----END PGP SIGNATURE-----


More information about the development mailing list