Skip to main content
Share Your Experience: Take the 2024 Developer Survey

Questions tagged [mysql-archive-format]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
2 votes
1 answer
381 views

ARCHIVE not enabled by default on MariaDB 10.1

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 ...
MarkDQ's user avatar
  • 493
0 votes
1 answer
663 views

Site broken. How do I fix Couldn't repair table: civicrm.log_civicrm_status_pref?

On Drupal 7.52 and CiviCRM 4.7.13 Recently I discovered Civicrm couldn't connect to MySQL. This wonderful error popped up when registering someone for an event: DB Error: no database selected ...
carclubadmin's user avatar
3 votes
1 answer
136 views

CiviCRM logging enabled. I am now getting an error on mysqldump. Unknown storage engine 'ARCHIVE'

I getting the following error when I try to dump my civicrm drupal database Couldn't read status information for table log_civicrm_install_canary () mysqldump: Couldn't execute 'show create table ...
Steven's user avatar
  • 51
12 votes
4 answers
2k views

MyISAM database but all civicrm_ tables are INNODB... is this a problem?

I just upgraded a large site to 4.7 (without any issues in the upgrade process by the way). The new "System Status" admin screen gives a warning as follows: "Your database is configured to use the ...
Laryn's user avatar
  • 8,268
8 votes
6 answers
620 views

How can I improve the performance of the change log table?

Retrieving the change log for a contact takes ages for my client - maybe a response of 10 minutes to get just 79 records for one contact. The contact database has about 39K rows, but with about 950k ...
Andy Clark's user avatar
  • 4,845
1 vote
2 answers
64 views

What causes periodic database errors while using logging, and what should I do about it?

Running a Drupal site with CiviCRM Logging enabled. It seems like once a month we get a crash. On investigation one of the log tables is corrupted. Since the tables are type Archive MYSQL provides ...
user469's user avatar
  • 305