Hello, We are experiencing database performance problems with locks occurring. We think it is because jobs that require a huge amount of inserts is holding on to innodb_autoinc. We are thinking of changing the following to see if it helps.
innodb_autoinc_lock_mode = 1 to: innodb_autoinc_lock_mode = 2 I think the change causes a problem with database replication. However, we currently are not doing DB replication so we don't think that will be a problem. Does anyone know if this change will cause other problems? Thanks, -craig
------------------------------------------------------------------------------
_______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
