[Deploying Sakai] MySQL: MyISAM or InnoDB?

[Steve Swinsburg]

Hi Wolfgang,

Yes you should be using InnoDB. We successfully converted ours over about a  year ago by dumping the database and reimporting ensuring the tables were being created as InnoDB.

cheers,
Steve

On 01/08/2011, at 7:00 PM, Wolfgang Rohregger wrote:

> Hi,
> 
> I've had troubles running the Sakai 2.8.0 DB upgrade scripts for MySQL. After doing some research, there have been at least some indicators that parts, if not the whole, database enginge of MySQL might have been switched over to InnoDB.
> 
> Is InnoDB now used for all Sakai tables and should I migrate the old MyISAM tables to InnoDB?
> 
> Cheers,
> 
> Wolfgang
> _______________________________________________
> production mailing list
> production at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/production
> 
> TO UNSUBSCRIBE: send email to production-unsubscribe at collab.sakaiproject.org with a subject of "unsubscribe"