Since these are Drupal-specific benchmarks, and Drupal doesn't utilize any of the ACID type stuff (even though it would be nice in D7), I think it is relevant to compare the out of the box configs like MyISAM. Speaking of which, maybe adding ACID isn't that hard - keep track of what is InnoDB and let the db include files send a START TRANSACTION when it is possible (speaking in a frame of PHP5 __construct()/__destruct() perhaps). matt@mattfarina.com wrote:
Two Thoughts:
1) MySQL 5.1 is supposed to be faster than MySQL 5.0.
2) Isn't the more accurate feature comparison InnoDB to PostgreSQL. MyISAM is a more light weight engine. InnoDB is more comparable to PostgreSQL with regard to features. Row level locking and that kind of thing.
Matt
Quoting Khalid Baheyeldin <kb@2bits.com>:
Well, I did some benchmarks, and they show that, out of the box at least, MySQL is faster.
Here they are:
http://2bits.com/articles/benchmarking-postgresql-vs-mysql-performance-using...
On Nov 25, 2007 1:24 PM, Ivan Sergio Borgonovo <mail@webthatworks.it> wrote:
I just found this:
Converted the site from MySQL to PostgreSQL
http://jamonation.com/node/734
it is not explicitly said but the site should run drupal.
-- Ivan Sergio Borgonovo http://www.webthatworks.it
-- Khalid M. Baheyeldin 2bits.com http://2bits.com Drupal optimization, development, customization and consulting.