Search Results
https://dev.mysql.com/doc/refman/8.4/en/audit-log-reference.html
Unless those objects are installed, the audit_log plugin operates in (deprecated) legacy mode. If these tables are missing, the audit_log plugin operates in (deprecated) legacy mode. If this function fails, an error message is returned and the audit ...Audit Log Tables MySQL Enterprise Audit uses tables in the mysql system database for persistent storage of filter and user account ...
https://dev.mysql.com/doc/refman/8.4/en/replication-options-reference.html
enforce_gtid_consistency: Prevents execution of statements that cannot be logged in transactionally safe manner. gtid_mode: Controls whether GTID based logging is enabled and what type of transactions logs can contain. relay_log_recovery: Whether ...
https://dev.mysql.com/doc/refman/8.4/en/repair-table.html
This type of repair is like that done by myisamchk --safe-recover. Caution Use the USE_FRM option only if you cannot use regular REPAIR modes. For a MyISAM table, if you do not get OK, you should try repairing it with myisamchk --safe-recover. With ...[QUICK] [EXTENDED] [USE_FRM] REPAIR TABLE repairs a possibly corrupted table, for certain storage engines ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-memory.html
The statement is always logged in statement format, even if the binary logging format is set to ROW, and it is written even if read_only or super_read_only mode is set on the server. The safe way to restart a replica that is replicating MEMORY ...
https://dev.mysql.com/doc/connectors/en/connector-j-config-failover.html
The failover support is configured by the following connection properties (their functions are explained in the paragraphs below): failOverReadOnly secondsBeforeRetrySource queriesBeforeRetrySource retriesAllDown autoReconnect autoReconnectForPools ...A failover happens when connection-related errors occur for an underlying, active ...
https://dev.mysql.com/doc/connector-j/en/connector-j-config-failover.html
The failover support is configured by the following connection properties (their functions are explained in the paragraphs below): failOverReadOnly secondsBeforeRetrySource queriesBeforeRetrySource retriesAllDown autoReconnect autoReconnectForPools ...A failover happens when connection-related errors occur for an underlying, active ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-compliance-administration-standard-rules.html
A value of 1 is the safest choice because in the event of a crash you lose at most one commit group from the binary log. Severity Minor Warning Advice Set sync_binlog = 1 within the [mysqld] section of your MySQL configuration file (my.cnf) to ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-compliance-replication-standard-rules.html
You can also cause the server to write checksums for the events using CRC32 checksums by setting the binlog_checksum system variable, to add an extra level of safety to the logs and the replication process. Source Not Verifying Checksums When ...By ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/replication-advisor-ref.html
You can also cause the server to write checksums for the events using CRC32 checksums by setting the binlog_checksum system variable, to add an extra level of safety to the logs and the replication process. You can also cause the server to write ...
https://dev.mysql.com/doc/refman/8.4/en/lock-tables.html
With auto-reconnect disabled, if the connection drops, an error occurs for the next statement issued. Interaction of Table Locking and Transactions LOCK TABLES and UNLOCK TABLES interact with the use of transactions as follows: LOCK TABLES is not ...