Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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,

...