Skip to main content

Questions tagged [db-logging]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
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
2 votes
4 answers
132 views

CiviCRM Upgrade to 5.60, civicrm_job_log foreign key constraint

During the db upgrade portion of a D7+CiviCRM 5.58.1->5.60.0 upgrade, I'm hitting the error below. Anyone else? Clues? ALTER TABLE civicrm_job_log ADD CONSTRAINT FK_civicrm_job_log_job_id ...
Alan Dixon's user avatar
  • 6,861
8 votes
6 answers
621 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
5 votes
3 answers
299 views

Missing Log Tables Error

It seems that daily, my System Status page is giving me the following error: Missing Log Tables You don't have logging enabled on some tables. This may cause errors on performing insert/update ...
themak's user avatar
  • 3,441
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
1 vote
1 answer
306 views

Large CiviCRM Logs

CiviCRM 4.7.31 (upgrading today) Drupal 7.x Our log_civicrm_group table crashed and needed repair. We had to run the repair twice from the command line for it to actually work. It's about 850MB large ...
Zachary's user avatar
  • 1,797