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

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

Details

    • Bug
    • Status: Done
    • Low
    • Resolution: Duplicate
    • 5.7.23-23
    • None
    • 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.

      Attachments

        Issue Links

          Activity

            People

              george.lorch George Lorch (Inactive)
              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

                  Smart Checklist