Forum OpenACS Q&A: Re: OpenACS assessment...

Collapse
2: Re: OpenACS assessment... (response to 1)
Posted by Torben Brosten on
Here's a start for discussion references (running out of battery power):

2. Postgres is successively losing to MySQL. Is MySQL?s performance already better in some areas?

Plans for the mid-term future[1]:

As an alternative to the one-thread-per-connection model, manage a pool of threads to handle queries.

. MySQL Manual | 1.8.5.3 Transactions and Atomic Operations[2]

1.8.5.3 Transactions and Atomic Operations MySQL Server (version 3.23-max and all versions 4.0 and above) supports transactions with the InnoDB and BDB transactional storage engines. InnoDB provides full ACID compliance...

Features available in MySql 4.0[3]

Comparing leading databases[4] (MySQL perspective)

MySql gotchas[5]

MySql passes the acid test?[6]

Recent thread comparing mysql and postgresql[7]

Articles in Germany about posgresql[8]

1. http://www.mysql.com/doc/en/TODO_sometime.html
2. http://www.mysql.com/doc/en/ANSI_diff_Transactions.html
3. http://www.mysql.com/doc/en/Nutshell_4.0_features.html
4. http://www.mysql.com/information/features.html
5. https://openacs.org/forums/message-view?message_id=145359
6. https://openacs.org/forums/message-view?message_id=20355
7. http://archives.postgresql.org/pgsql-general/2003-03/msg01215.php
  http://archives.postgresql.org/pgsql-general/2003-03/msg01267.php
8. http://archives.postgresql.org/pgsql-advocacy/2003-11/msg00214.php