Uploaded image for project: 'Percona Server'
  1. Percona Server
  2. PS-4963

audit_log_rotations is meant to not be dynamic, but can be changed with set global

    Details

    • Type: Bug
    • Status: Done
    • Priority: Low
    • Resolution: Duplicate
    • Affects Version/s: 5.7.23-23
    • Fix Version/s: None
    • Component/s: Documentation

      Description

      Tested against PS 5.7.23-23.

      audit_log_rotations is meant to be non-dynamic, however, it is possible to change its value with set global.

       

      mysql [localhost] {root} ((none)) > set global audit_log_rotations=100;
      Query OK, 0 rows affected (0.00 sec)

      Note, it doesn't change anything (old value is used).

       

      Steps to reproduce:

       

      1. Configure MySQL with the below:
      plugin-load=audit_log.so
      audit_log_policy=ALL
      audit_log_format=OLD
      audit_log_file=/auditlog/audit.log
      audit_log_rotate_on_size=512K 

       2. Change the value of audit_log_rotations with set global.

        Smart Checklist

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  george.lorch George Lorch
                  Reporter:
                  iwo.panowicz Iwo Panowicz
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  2 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    Time Tracking

                    Estimated:
                    Original Estimate - Not Specified
                    Not Specified
                    Remaining:
                    Remaining Estimate - Not Specified
                    Not Specified
                    Logged:
                    Time Spent - 2 hours, 25 minutes
                    2h 25m