Author Topic: Is it possible to store log entries in different database in civicrm? (Read 350 times)

manikandan.civicrm · January 22, 2015, 10:08:00 am

I have more than 40K users in my civirm web application. I enabled the log to track the each users activity in the system. But now the log tables are become too much big. Due to that my application performance is affecting. So I thought to decide storing log tables in different database. Is it good idea if yes, this facility is already available in civi? Please reply.

Thanks in advance

manikandan.civicrm · January 23, 2015, 06:38:31 am

At last I found out the solution myself. It's already available in civicrm itself. In civicrm.settings.php file, by default we are tracking the log in same database like below.

Code: [Select]

define( 'CIVICRM_DSN' , 'mysql://username:password@host/database?new_link=true' );

define('CIVICRM_LOGGING_DSN', CIVICRM_DSN);

So we can change the CiviCRM Logging into different database by changing the variable CIVICRM_LOGGING_DSN.

Code: [Select]

define( 'CIVICRM_LOGGING_DSN' ,'mysql://username:password@host/log_database?new_link=true' );

CiviCRM Community Forums (archive)

News:

Author Topic: Is it possible to store log entries in different database in civicrm? (Read 350 times)

manikandan.civicrm

Is it possible to store log entries in different database in civicrm?

manikandan.civicrm

Re: Is it possible to store log entries in different database in civicrm?