[Building Sakai] Converting MyISAM to Innodb

Sam Ottenhoff ottenhoff at longsight.com
Mon May 12 06:24:30 PDT 2014


I believe the dw_ tables are "data warehouse" tables that belong to the OSP
project.  If you don't use OSP, you can ignore those tables.

--Sam


On Mon, May 12, 2014 at 7:44 AM, Ciellie
<ciellie.jansenvanvuuren at nwu.ac.za>wrote:

> Hallo
>
> We ran a conversion script and change MyISAM tables to Innodb I set this
> propery in sakai.properties :
> hibernate.dialect=org.hibernate.dialect.MySQLInnoDBDialect
>
> Still when I startup Hybernate change the dw_ tables to MyISAM. Currently
> our service is down as the db is running at a load of 300 We want to
> upgrade
> to mySql 5.5 from 5.0 and convert to Innodb to get better performance.
>
> Can we keep the dw_ tables as MyISAM or will we run into a problem.
>
> Thank you
> Ciellie
>
> _______________________________________________
> sakai-dev mailing list
> sakai-dev at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>
> TO UNSUBSCRIBE: send email to
> sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of
> "unsubscribe"
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20140512/62a63dbf/attachment.html 


More information about the sakai-dev mailing list