Playing with MySql and the MailArchive Performance Fix.

getSummarizableReference
getSummarizableReference
dbReadLock
udhcp-macvpn-972:~ csev$ mysql -u root
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3 to server version: 5.0.20-max
Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the buffer.
mysql> create database sakai default character set utf8;
Query OK, 1 row affected (0.00 sec)
mysql> grant all on sakai.* to sakaiuser@’localhost’ identified by ‘sakaipassword’;
Query OK, 0 rows affected (0.00 sec)
mysql> grant all on sakai.* to sakaiuser@’127.0.0.1′ identified by ‘sakaipassword’;
Query OK, 0 rows affected (0.00 sec)
mysql>
http://confluence.sakaiproject.org/confluence/display/DOC/Install+Guide+-+DB+%282.4%29#InstallGuide-DB%282.4%29-create
Just add this:
hibernate.dialect=org.hibernate.dialect.MySQLDialect
vendor@org.sakaiproject.db.api.SqlService=mysql
driverClassName@javax.sql.BaseDataSource=com.mysql.jdbc.Driver
url@javax.sql.BaseDataSource=jdbc:mysql://localhost:3306/sakai?useUnicode=true&characterEncoding=UTF-8
username@javax.sql.BaseDataSource=sakaiuser
password@javax.sql.BaseDataSource=sakaipassword
validationQuery@javax.sql.BaseDataSource=show variables like ‘version’
defaultTransactionIsolationString@javax.sql.BaseDataSource=TRANSACTION_READ_COMMITTED
cp ~/dev/keepzips/mysql-connector-java-3.1.11/mysql-connector-java-3.1.11-bin.jar ~/dev/jakarta-tomcat-5.5.9/common/lib/