aC forum: InnoDB vs. MyISAM http://www.activecollab.com/forums/topic/783/ Recent posts on topic: InnoDB vs. MyISAM en-us Sat, 30 Aug 2008 11:28:07 UTC http://www.activecollab.com/forums/post/8710/#post8710 http://www.activecollab.com/forums/post/8710/#post8710 Post #4 by db163404 db163404 Installation goes smoothly by simply navigating to this file: public/install/installation/acInstallation.class.php and putting the first line in the function as return true; This will ignore the InnoDB check... obviously there will not be transaction locking and what not enforced at the database by doing this, all other functionality seems to work fine... except when I upload files they get downloaded as corrupt files... bummer. The other thing is I'm not able to upload logos.

]]> Thu, 13 Sep 2007 00:10:49 UTC http://www.activecollab.com/forums/post/8709/#post8709 http://www.activecollab.com/forums/post/8709/#post8709 Post #3 by db163404 db163404 I've run into the same problem. I can easily change the DDL file (mysql_schema.php) what other files would need edited to get the install to work? Or do I just need to do a manual installation instead of the automated one?

]]> Wed, 12 Sep 2007 20:30:41 UTC http://www.activecollab.com/forums/post/3663/#post3663 http://www.activecollab.com/forums/post/3663/#post3663 Post #2 by Ilija Studen Ilija Studen OK, here is a short explanation. Problem is that MyISAM does not support transaction. Quote from Wikipedia:

A single transaction might require several queries, each reading and/or writing information in the database. When this happens it is usually important to be sure that the database is not left with only some of the queries carried out. For example, when doing a money transfer, if the money was debited from one account, it is important that it also be credited to the depositing account.

InnoDB has support for transactions. MyISAM does not support them (it supports FULLTEXT indexes on the other hand and some other nice stuff). From that reason activeCollab uses InnoDB on tables that use transactions and where we need to make sure that there are no operations that are partially executed.

Transactions greatly reduce development time and help to prevent some "ghost" errors that are resulted with data being out of sync (you hear about them on forum, but can't reproduce them or cache them).

This does not mean that activeCollab can't run on databases that does not support InnoDB. It just mean that it is not recommended and supported. Hack the code at your own risk.

]]> Sun, 08 Oct 2006 09:56:35 UTC http://www.activecollab.com/forums/post/3649/#post3649 http://www.activecollab.com/forums/post/3649/#post3649 Post #1 by Ludwigw Ludwigw Hey,

Why does aC need InnoDB? My host has decided they won't support it but InnoDB indefinately which is a shame. However since MyISAM is the default and most popular Storage Engine can't aC run on that?

Or maybe have an alternate version that runs on MyISAM for folks like me who don't have access to InnoDB. Wouldit be possibleto have one set of files, with two installers, or an option in the installer to detect whether you have InnoDB and if not it will drop back to MyISAM.

Maybe we could have a discussion about this?

Ludwig

]]> Sat, 07 Oct 2006 23:50:02 UTC