Playing with MySql and the MailArchive Performance Fix.<\/p>\n
\ngetSummarizableReference
\ngetSummarizableReference
\ndbReadLock
\nudhcp-macvpn-972:~ csev$ mysql -u root
\nWelcome to the MySQL monitor. Commands end with ; or \\g.
\nYour MySQL connection id is 3 to server version: 5.0.20-max
\nType ‘help;’ or ‘\\h’ for help. Type ‘\\c’ to clear the buffer.
\nmysql> create database sakai default character set utf8;
\nQuery OK, 1 row affected (0.00 sec)
\nmysql> grant all on sakai.* to sakaiuser@’localhost’ identified by ‘sakaipassword’;
\nQuery OK, 0 rows affected (0.00 sec)
\nmysql> grant all on sakai.* to sakaiuser@’127.0.0.1′ identified by ‘sakaipassword’;
\nQuery OK, 0 rows affected (0.00 sec)
\nmysql>
\nhttp:\/\/confluence.sakaiproject.org\/confluence\/display\/DOC\/Install+Guide+-+DB+%282.4%29#InstallGuide-DB%282.4%29-create
\nJust add this:
\nhibernate.dialect=org.hibernate.dialect.MySQLDialect
\nvendor@org.sakaiproject.db.api.SqlService=mysql
\ndriverClassName@javax.sql.BaseDataSource=com.mysql.jdbc.Driver
\nurl@javax.sql.BaseDataSource=jdbc:mysql:\/\/localhost:3306\/sakai?useUnicode=true&characterEncoding=UTF-8
\nusername@javax.sql.BaseDataSource=sakaiuser
\npassword@javax.sql.BaseDataSource=sakaipassword
\nvalidationQuery@javax.sql.BaseDataSource=show variables like ‘version’
\ndefaultTransactionIsolationString@javax.sql.BaseDataSource=TRANSACTION_READ_COMMITTED
\ncp ~\/dev\/keepzips\/mysql-connector-java-3.1.11\/mysql-connector-java-3.1.11-bin.jar ~\/dev\/jakarta-tomcat-5.5.9\/common\/lib\/<\/p>\n","protected":false},"excerpt":{"rendered":"
Playing with MySql and the MailArchive Performance Fix.<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-429","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/www.dr-chuck.com\/csev-blog\/wp-json\/wp\/v2\/posts\/429","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dr-chuck.com\/csev-blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dr-chuck.com\/csev-blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dr-chuck.com\/csev-blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dr-chuck.com\/csev-blog\/wp-json\/wp\/v2\/comments?post=429"}],"version-history":[{"count":1,"href":"https:\/\/www.dr-chuck.com\/csev-blog\/wp-json\/wp\/v2\/posts\/429\/revisions"}],"predecessor-version":[{"id":2538,"href":"https:\/\/www.dr-chuck.com\/csev-blog\/wp-json\/wp\/v2\/posts\/429\/revisions\/2538"}],"wp:attachment":[{"href":"https:\/\/www.dr-chuck.com\/csev-blog\/wp-json\/wp\/v2\/media?parent=429"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dr-chuck.com\/csev-blog\/wp-json\/wp\/v2\/categories?post=429"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dr-chuck.com\/csev-blog\/wp-json\/wp\/v2\/tags?post=429"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}