Questions tagged [mysql-archive-format]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
2
votes
1answer
228 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 ...
0
votes
1answer
481 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 ...
2
votes
1answer
98 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 ...
10
votes
4answers
1k 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 ...
8
votes
6answers
362 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 ...
1
vote
2answers
61 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 ...