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

Release notes for PS and PXC 8.0.31 says audit_log_flush is deprecated but it seems not

Details

    • Improvement
    • Status: Done
    • Medium
    • Resolution: Won't Fix
    • 8.0.31-23 (Q4 2022)
    • None
    • Documentation
    • None
    • Yes
    • Yes

    Description

      Hi Team,

      Release notes for PS and PXC 8.0.31 says audit_log_flush is deprecated  but it seems not the case.

      Our documents :

      https://docs.percona.com/percona-server/8.0/release-notes/8.0.31-23.html

      https://docs.percona.com/percona-xtradb-cluster/8.0/release-notes/8.0.31-23.html

       says :

      "The audit_log_flush variable has been deprecated and will be removed in future releases."

      It looks like a mistake in documentation,  as there are no commits related to audit_log_flush since October 2022, when this commit was pushed to the tree: https://github.com/percona/percona-server/commit/953c14e90df417e969905657a1f349d89ddb710d

      We can see other related commits here: https://github.com/percona/percona-server/search?o=desc&q=audit+log+flush&s=committer-date&type=commits

       

      As per upstream document, it is replace by function audit_log_rotate : https://dev.mysql.com/doc/refman/8.0/en/audit-log-reference.html#sysvar_audit_log_flush

      But we cannot find the said function :

       

      mysql> SELECT @@version, @@version_comment;
      +-----------+-----------------------------------------------------+
      | @@version | @@version_comment                                   |
      +-----------+-----------------------------------------------------+
      | 8.0.31-23 | Percona Server (GPL), Release 23, Revision 71449379 |
      +-----------+-----------------------------------------------------+
      1 row in set (0.00 sec)
      mysql> SELECT * FROM information_schema.routines WHERE routine_name  like '%audit%';
      Empty set (0.00 sec)
      mysql> SHOW GLOBAL VARIABLES LIKE 'audit_log_f%';
      +------------------+-----------+
      | Variable_name    | Value     |
      +------------------+-----------+
      | audit_log_file   | audit.log |
      | audit_log_flush  | OFF       |
      | audit_log_format | OLD       |
      +------------------+-----------+
      3 rows in set (0.00 sec)
      

      We cannot also find the function in  the source code :

      # grep audit_log_rotate -R percona-server-8.0.31-23/ | grep -v rotate_

       

       

       

       

      Attachments

        Activity

          People

            Unassigned Unassigned
            aristotle.po Aristotle Po
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Smart Checklist