https://dev.mysql.com/audit-api-message-emit.html
To install the audit_api_message_emit component, use this statement: INSTALL COMPONENT "file://component_audit_api_message_emit"; Component installation is a one-time operation that need not be done per server startup. As of MySQL 8.0.14, the ...
https://dev.mysql.com/audit-log-file-reading.html
The plugin opens each remaining candidate file, verifies that the file actually contains JSON audit events, and sorts the files using the timestamps from the first event of each file. For example: [ { "timestamp": "2020-05-18 13:39:33", "id": 0, ...
https://dev.mysql.com/audit-log-filter-definitions.html
For information about using JSON data in MySQL, see Section 11.5, “The JSON Data Type”. Filter definitions have this form, where actions indicates how filtering takes place: { "filter": actions } The following discussion describes permitted ...
https://dev.mysql.com/audit-log-legacy-filtering.html
Event Filtering by Account Event Filtering by Status To filter audited events based on the originating account, set one of these system variables at server startup or runtime: audit_log_include_accounts: The accounts to include in audit logging.
https://dev.mysql.com/automatic-start.html
systemd, the mysqld_safe and mysql.server scripts, Solaris SMF, and the macOS Startup Item (or MySQL Preference Pane) can be used to start the server manually, or automatically at system startup time. This section discusses methods for starting and ...
https://dev.mysql.com/backup-and-recovery.html
It is important to back up your databases so that you can recover your data and be up and running again in case problems occur, such as system crashes, hardware failures, or users deleting data by mistake. Backups are also essential as a safeguard ...
https://dev.mysql.com/backup-strategy-example.html
Assume also that the MySQL server is under load at the time of the crash. You should include such options as necessary to enable client programs to connect to the MySQL server. Assume that data is stored in the InnoDB storage engine, which has ...
https://dev.mysql.com/batch-mode.html
Why use a script? Here are a few reasons: If you run a query repeatedly (say, every day or every week), making it a script enables you to avoid retyping it each time you execute it. In the previous sections, you used mysql interactively to enter ...
https://dev.mysql.com/binary-log-mixed.html
The following system variables, when used with session scope (only), do not cause the logging format to switch: auto_increment_increment auto_increment_offset character_set_client character_set_connection character_set_database character_set_server ... When running in MIXED logging format, the server automatically switches from statement-based to row-based logging under the following conditions: When a function contains ...
https://dev.mysql.com/binary-log-transaction-compression-stats-table.html
The statistics cover all transactions written to the binary log and relay log from the time the server was started or the table was truncated. FIRST_TRANSACTION_TIMESTAMP The timestamp when the first transaction was written to the log. This table ...
