The task of purging the old audit logs 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 batchbulk-delete stored procedure below 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,