The task of purging the old audit in DualShield Management Console may fail when you are trying to delete a huge amount of records. On MySQL you may experience the following error,
ERROR 1206 (HY000): The total number of locks exceeds the lock table size
The batch-delete stored procedure tries to avoid this problem. Please use it at your own risk.
Its speed still relies on the correct indexing. The following indexes are essential,
id, log_date,parent_id on log table
parent_id on log_field table
Important: If you have configured SQL replication, please disable the binary logs first. On MySQL, you can do it with SET SESSION SQL_LOG_BIN = 0; MS SQL server should have the similar option,
MS SQL Server version,