MySQL Enterprise Audit Enabled Features Effective File Name No compression or encryption audit.log Compression audit.log.gz Encryption audit.log. pwd_id .enc Compression, encryption audit.log.gz. pwd_id .enc pwd_id  indicates the ID of the password used to encrypt or decrypt a file.  pwd_id  format is pwd_timestamp-seq , where: • pwd_timestamp  is a UTC value in  YYYYMMDD T hhmmss  format indicating when the password was created. • seq  is a sequence number. Sequence numbers start at 1 and increase for passwords that have the same  pwd_timestamp  value. Here are some example  pwd_id  password ID values: 20190403T142359-1 20190403T142400-1 20190403T142400-2 audit_log-20190403T142359-1 audit_log-20190403T142400-1 audit_log-20190403T142400-2 To construct the corresponding keyring IDs for storing passwords in the keyring, the audit log plugin adds a prefix of  audit_log-  to the  pwd_id  values. For the example password IDs just shown, the corresponding keyring IDs are: The ID of the password currently used for encryption by the audit log plugin is the one having the largest pwd_timestamp  value. If multiple passwords have that  pwd_timestamp  value, the current password ID is the one with the largest sequence number. For example, in the preceding set of password IDs, two of them have the largest timestamp,  20190403T142400 , so the current password ID is the one with the largest sequence number ( 2 ). The audit log plugin performs certain actions during initialization and termination based on the effective audit log file name: •During initialization, the plugin checks whether a file with the audit log file name already exists and renames it if so. (In this case, the plugin assumes that the previous server invocation exited unexpectedly with the audit log plugin running.) The plugin then writes to a new empty audit log file. •During termination, the plugin renames the audit log file. •File renaming (whether during plugin initialization or termination) occurs according to the usual rules for automatic size-based log file rotation; see Manual Audit Log File Rotation. • NEW : New-style XML format. This is the default. • OLD : Old-style XML format. • JSON : JSON format. Selecting Audit Log File Format To configure the audit log file format, set the  audit_log_format  system variable at server startup. These formats are available: 1490