Plugins and Components
Certain MySQL Server plugins and components are loaded in the DB system automatically. You do not need to install any of these plugins.
- MySQL Enterprise Thread Pool: The thread pool plugin provides an alternative thread-handling model designed to reduce overhead and improve performance. See MySQL Enterprise Thread Pool.
- MySQL Enterprise Audit plugin: The audit plugin enables MySQL
Server to produce a log file containing an audit record of server activity. The log
contents include when clients connect and disconnect, and what actions they perform
while connected, such as which databases and tables they access. You can add
statistics for the time and size of each query to detect outliers. You cannot change
the default values of the plugin.
audit_log_buffer_size: 10485760
audit_log_compression: GZIP
audit_log_database: mysql_audit
audit_log_file: /db/audit/audit.log
audit_log_flush_interval_seconds: 60
audit_log_format: JSON
audit_log_format_unix_timestamp: ON
audit_log_max_size: 5368709120
audit_log_prune_seconds: 604800
audit_log_rotate_on_size: 52428800
mysql_audit
schema. See Default MySQL Privileges, and MySQL Enterprise Audit Plugin. - The
connection_control
plugin: MySQL Server includes a plugin library that enables administrators to introduce an increasing delay in server response to connection attempts after a configurable number of consecutive failed attempts. The default value of the variables of theconnection-control
plugin are as follows, and you cannot change the default values:connection_control_failed_connections_threshold : 3
connection_control_max_connection_delay: 10000
connection_control_min_connection_delay:1000
- The
validate_password
component: The component serves to improve security by requiring account passwords and enabling strength testing of potential passwords. The default value of the variables of thevalidate_password
component are as follows, and you cannot change the default values:validate_password.check_user_name: ON
validate_password.length: 8
validate_password.mixed_case_count:1
validate_password.number_count:1
validate_password.policy: MEDIUM
validate_password.special_char_count :1
- Data masking: The general-purpose masking functions mask arbitrary strings, special-purpose masking functions mask specific types of values, and generate functions generate random values. See Data Masking.