CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Pre-installation Questions (Moderator: Dave Greenberg) »
  • InnoDB
Pages: [1]

Author Topic: InnoDB  (Read 1327 times)

nmaltd

  • Guest
InnoDB
June 23, 2008, 09:01:32 am
OK, so I know there are references to this all over the place - but there doesn't seem to be a difinitive answer and there are conflicing opinions so...

Our current UK based host is fantastic in every respect apart from not enabling InnoDB on their servers.

Can CiviCRM be run without InnoDB by either using a different storage engine (what happens if we actually use myISAM) or by periodically running some kind of 3rd party clean-up tool?

We really don't want to move host, so if we can do something else, that would be great.

Thanks in advance,

David

Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5760
  • Karma: 226
    • My CiviCRM Blog
Re: InnoDB
June 23, 2008, 11:34:26 am
MyISAM does not support foreign keys. We use them extensively - and use a number of related data operations (on delete - cascade etc.). Not using INNODB will definitely result in lots of data integrity issues.
Protect your investment in CiviCRM by  becoming a Member!

nmaltd

  • Guest
Re: InnoDB
June 23, 2008, 01:48:08 pm
OK - so InnoDB is a must then!
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Pre-installation Questions (Moderator: Dave Greenberg) »
  • InnoDB

This forum was archived on 2017-11-26.