On 15 Aug 2006, at 15:00, Gerhard Killesreiter wrote:
I can only guess why these tables were chosen: they have a lot of writes. Locking would only be an issue for the cache table.
And the variables table. Modules that frequently use variable_get()/variable_set() to store temporary results can bring your site to halt. variable_set() requires 4 SQL queries, and does a table lock that is likely to stall other Apache clients. :-)
For the latter I advocate my merge table patch at http://drupal.org/ node/78503
Did you actually benchmark that patch?
It would also be helpful if anybody could compare the use of InnoDB vs my patch.
I compared a InnoDB with a MyISAM cache table and noticed little or no performance gain. -- Dries Buytaert :: http://www.buytaert.net/