Answers.Body: <p>Reading around the issue reported above I came across this extension - <a href="https://github.com/eileenmcnaughton/nz.co.fuzion.innodbtriggers" rel="nofollow noreferrer">https://github.com/eileenmcnaughton/nz.co.fuzion.innodbtriggers</a> - which I've now installed, and it appears to have resolved my issue. I'm now seeing a prompt result when looking at the change log.</p>
  <p>Maybe this extension is essential when setting up detailed logging using a separate database?</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-01-25T14:58:05.437Z
Answers.Text: I think the extension adds indexes into all the tables and changes them from ARCHIVE to Innodb format (you can't have indexes on ARCHIVE tables). This means a must faster response time but if you have a large database (5million + contacts and assoiated records) then you'd see a increase in storage size. For most users this isn't an issue, so you're probably fine.
Answers.UserDisplayName: Parvez Saleh
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-01-25T14:31:16.400Z
Answers.LastActivityDate: 2022-01-25T14:40:32.773Z
Answers.LastEditDate: 2022-01-25T14:40:32.773Z
Answers.UserDisplayName: Graham
Body: <p>Using the documentation, I've created a new database for my detailed logging data - I already had one for the CMS (Drupal) and one for Civi - and I've added the details for that database into my civicrm.settings.php file. I've turned on detailed logging via the Preferences page. I can see that the database has been populated and is storing lots of records.</p>
  <p>So far so good.</p>
  <p>But when I try to view the Change Log for any contact record, all I get is a spinning Civi icon.</p>
  <p>Have I missed a step? How do I debug (there's nothing visible in the Civi log)?</p>
  <p>running CiviCRM 5.45.0</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2022-01-25T14:00:30.173Z
Comments.Text: Spinning icon usually means error 500 which means check the webserver log. There might also be something in the browser dev tools network tab response, but it doesn't usually have details.
Comments.UserDisplayName: Demerit
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2022-01-25T14:02:03.017Z
Comments.Text: Looking at changess can take a while - does it still spin when looking at a contact with very few changes?
Comments.UserDisplayName: Andy Clark
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2022-01-25T14:45:33.713Z
Comments.Text: I tried it with various records, and left it to see if it was working, but just very slowly. I ended up getting a network error. Might have been timing out?
Comments.UserDisplayName: Graham
Tags: <logging><db-logging>
Title: How do I get Detailed Logging working?
ThreadText: # How do I get Detailed Logging working?
  
  (Asked by: username_0 on 2022-01-25)
  
  Using the documentation, I've created a new database for my detailed logging data - I already had one for the CMS (Drupal) and one for Civi - and I've added the details for that database into my civicrm.settings.php file. I've turned on detailed logging via the Preferences page. I can see that the database has been populated and is storing lots of records.
  
  So far so good.
  
  But when I try to view the Change Log for any contact record, all I get is a spinning Civi icon.
  
  Have I missed a step? How do I debug (there's nothing visible in the Civi log)?
  
  running CiviCRM 5.45.0
  
  **Tags:** logging, db-logging
  
  > **Comments:**
  > **username_1**: Spinning icon usually means error 500 which means check the webserver log. There might also be something in the browser dev tools network tab response, but it doesn't usually have details.  
  > **username_2**: Looking at changess can take a while - does it still spin when looking at a contact with very few changes?  
  > **username_0**: I tried it with various records, and left it to see if it was working, but just very slowly. I ended up getting a network error. Might have been timing out?  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_0 on 2022-01-25. Score: 3
  
  Reading around the issue reported above I came across this extension - <https://github.com/eileenmcnaughton/nz.co.fuzion.innodbtriggers> - which I've now installed, and it appears to have resolved my issue. I'm now seeing a prompt result when looking at the change log.
  
  Maybe this extension is essential when setting up detailed logging using a separate database?
  
  > **Comments:**
  > **username_3**: I think the extension adds indexes into all the tables and changes them from ARCHIVE to Innodb format (you can't have indexes on ARCHIVE tables). This means a must faster response time but if you have a large database (5million + contacts and assoiated records) then you'd see a increase in storage size. For most users this isn't an issue, so you're probably fine.  
  
  ---
  
  