Answers.Body: <p>Logs in a separate database is fine.  It's what we do at Veda to make the databases more portable and easier to backup.</p>
  <p>Before CiviCRM 5.16, the log tables were in Archive format, which is prone to corruption. Starting with CiviCRM 5.16 the logs are in InnoDB format - but remain in Archive format if logging was already enabled.  If possible, switch the log tables to InnoDB format using the <a href="https://github.com/eileenmcnaughton/nz.co.fuzion.innodbtriggers" rel="nofollow noreferrer">InnoDB Logging</a> extension.</p>
  <p>If you can't (size of the log tables will grow, especially when indexes are added) then yes, if the tables become corrupt the database transactions will fail but this is the same regardless of if the log tables are in the same schema or not.</p>
  <p>Hope that helps</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-01-27T15:10:11.870Z
Answers.LastActivityDate: 2022-03-02T15:17:26.483Z
Answers.LastEditDate: 2022-03-02T15:17:26.483Z
Answers.UserDisplayName: Parvez Saleh
Body: <p>Well, subject has pretty much all of the question. Anyone with firsthand experience please?</p>
  
Tags: <mysql><logs>
Title: Logs in a separate database: would CiviCRM hangs if Logs database got corrupted?
ThreadText: # Logs in a separate database: would CiviCRM hangs if Logs database got corrupted?
  
  (Asked by: username_0 on 2022-01-27)
  
  Well, subject has pretty much all of the question. Anyone with firsthand experience please?
  
  **Tags:** mysql, logs
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2022-01-27. Score: 2
  
  Logs in a separate database is fine. It's what we do at Veda to make the databases more portable and easier to backup.
  
  Before CiviCRM 5.16, the log tables were in Archive format, which is prone to corruption. Starting with CiviCRM 5.16 the logs are in InnoDB format - but remain in Archive format if logging was already enabled. If possible, switch the log tables to InnoDB format using the [InnoDB Logging](https://github.com/eileenmcnaughton/nz.co.fuzion.innodbtriggers) extension.
  
  If you can't (size of the log tables will grow, especially when indexes are added) then yes, if the tables become corrupt the database transactions will fail but this is the same regardless of if the log tables are in the same schema or not.
  
  Hope that helps
  
  
  ---
  
  