Author Topic: ISAM vs InnoDB (Read 3879 times)

charlieg · October 22, 2008, 06:40:00 am

I found your software and was thrilled to find that all of this function was available for non-profits like mine AND works with Joomla. But there is no free lunch. I am using Community Builder and a lot of other software. I am not the programmer so take it easy on me. But we are getting messages about the problem of ISAM vs InnoDB. I don't know why my database was set up with ISAM or the trade offs, but what would it take for someone who was knowledgeable to convert civiCRM to ISAM?

Why should this NOT be done? Why should it?

"Your database is configured to use the MyISAM database engine. CiviCRM requires InnoDB. You will need to convert any MyISAM tables in your database to InnoDB. Using MyISAM tables will result in data integrity issues. This will be a fatal error in CiviCRM v2.1."

Feel free to point me anywhere to help me understand this issue.
Thanks for your help.
Charlie Gallie
charliegallie@comcast.net

Donald Lobo · October 22, 2008, 07:12:41 am

for myisam vs innodb a simple google search yields:

http://www.google.com/search?q=innodb+myisam+mysql&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla:en-US:official&client=firefox-a
http://dev.mysql.com/doc/refman/5.0/en/storage-engines.html

You might want to read some of those articles. Basically we think referential integrity is quite important for a CRM and hence insist on InnoDB

If your system does not depend on any InnoDB features / referential interity, converting a MyISAM table to InnoDB should be relatively easy

lobo

CiviCRM Community Forums (archive)

News:

Author Topic: ISAM vs InnoDB (Read 3879 times)

charlieg

ISAM vs InnoDB

Donald Lobo

Re: ISAM vs InnoDB