Answers.Body: <p>My strong advice to you would be to change the tables to be anything but ARCHIVE. Even InnoDB would be fine and preferred over ARHCIVE. We've had a number of sites have their entire audit schema's become corrupt and its been down to the storage engine being ARCHIVE.</p>
  
  <p>Also you'll probably want to add indexes into the audit schema otherwise you cant access the change log without waiting for minutes.</p>
  
  <p>I think later versions of CiviCRM do not use ARCHIVE storage format by default</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-03-26T00:25:07.917Z
Answers.Text: ARCHIVE is indeed a corruption prone format which even can lead to site outages when things go bad. That said, it's worth mentioning here that switching to InnoDB may significantly increase storage requirements, since ARCHIVE is a compressed format, and InnoDB is not.
Answers.UserDisplayName: Chris Burgess
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-03-27T09:33:59.290Z
Answers.Text: Thanks Chris, yes, you're right and worth noting. Its a much easier problem to solve though - trying to recover a corrupt ARCHIVE tables is a nightmare!
Answers.UserDisplayName: Parvez Saleh
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-03-27T19:35:04.607Z
Answers.Text: Disks are cheap! Just need to be sure they have enough before ditching ☠ ARCHIVE
Answers.UserDisplayName: Chris Burgess
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-03-24T14:29:02.510Z
Answers.LastActivityDate: 2017-03-25T22:00:55.957Z
Answers.LastEditDate: 2017-03-25T22:00:55.957Z
Answers.UserDisplayName: Parvez Saleh
Body: <p>The ARCHIVE storage engine is enabled by default on MariaDB 10.0, but no longer from 10.1.</p>
  
  <p>Therefore, you get a <em>DB unknown error</em> when CiviCRM tries to create a logging db table when logging is active (admin=>system=>misc), for instance when creating a new custom field.</p>
  
  <p>From MariaDB 10.1, the plugin needs to be specifically enabled, for example:</p>
  
  <pre><code>INSTALL SONAME 'ha_archive';
  </code></pre>
  
  <p>More on <a href="https://mariadb.com/kb/en/mariadb/archive/" rel="nofollow noreferrer">https://mariadb.com/kb/en/mariadb/archive/</a> </p>
  
Tags: <custom-fields><logging><mysql-archive-format>
Title: ARCHIVE not enabled by default on MariaDB 10.1
ThreadText: # ARCHIVE not enabled by default on MariaDB 10.1
  
  (Asked by: username_0 on 2017-03-18)
  
  The ARCHIVE storage engine is enabled by default on MariaDB 10.0, but no longer from 10.1.
  Therefore, you get a DB unknown error when CiviCRM tries to create a logging db table when logging is active (admin=>system=>misc), for instance when creating a new custom field.
  From MariaDB 10.1, the plugin needs to be specifically enabled, for example:
  INSTALL SONAME 'ha_archive';
  
  More on https://mariadb.com/kb/en/mariadb/archive/
  
  **Tags:** custom-fields, logging, mysql-archive-format
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2017-03-24. Score: 2
  
  My strong advice to you would be to change the tables to be anything but ARCHIVE. Even InnoDB would be fine and preferred over ARHCIVE. We've had a number of sites have their entire audit schema's become corrupt and its been down to the storage engine being ARCHIVE.
  
  Also you'll probably want to add indexes into the audit schema otherwise you cant access the change log without waiting for minutes.
  
  I think later versions of CiviCRM do not use ARCHIVE storage format by default
  
  > **Comments:**
  > **username_2**: ARCHIVE is indeed a corruption prone format which even can lead to site outages when things go bad. That said, it's worth mentioning here that switching to InnoDB may significantly increase storage requirements, since ARCHIVE is a compressed format, and InnoDB is not.  
  > **username_1**: Thanks Chris, yes, you're right and worth noting. Its a much easier problem to solve though - trying to recover a corrupt ARCHIVE tables is a nightmare!  
  > **username_2**: Disks are cheap! Just need to be sure they have enough before ditching ☠ ARCHIVE  
  
  ---
  
  