Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-wait-summary-tables.html
See that discussion for information about the content of wait events, the current and recent wait event tables, and how to control wait event collection, which is disabled by default. The Performance Schema maintains tables for collecting current ...
https://dev.mysql.com/doc/refman/8.4/en/pluggable-authentication.html
Because this is insecure, if the server is started with the --skip-grant-tables option, it also disables remote connections by enabling skip_networking. When a client connects to the MySQL server, the server uses the user name provided by the ...
https://dev.mysql.com/doc/refman/8.4/en/prepare.html
PREPARE stmt_name FROM preparable_stmt The PREPARE statement prepares a SQL statement and assigns it a name, stmt_name, by which to refer to the statement later. The prepared statement is executed with EXECUTE and released with DEALLOCATE PREPARE.
https://dev.mysql.com/doc/refman/8.4/en/processlist-access.html
You can enable or disable Performance Schema thread monitoring, as described in Section 29.12.22.8, “The threads Table”. The Performance Schema threads table also provides thread information, but table access uses a different privilege model.
https://dev.mysql.com/doc/refman/8.4/en/proxy-users.html
If the check_proxy_users system variable is enabled, the server performs proxy user mapping for any authentication plugins that make such a request: By default, check_proxy_users is disabled, so the server performs no proxy user mapping even for ...
https://dev.mysql.com/doc/refman/8.4/en/replication-binlog-encryption.html
The exception is if encryption was active previously on the server and was then disabled, in which case the binary log encryption key that was in use before is used again. MySQL binary log files and relay log files can be encrypted, helping to ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-json.html
In MySQL 8.4, it is possible to log partial updates to JSON documents (see Partial Updates of JSON Values). The logging behavior depends on the format used, as described here: Statement-based replication. JSON partial updates are not logged as such ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-timeout.html
The global value of the system variable replica_transaction_retries sets the maximum number of times for applier threads on a single-threaded or multithreaded replica to automatically retry failed transactions before stopping. Transactions are ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-transaction-inconsistencies.html
Binary logging and replica update logging are not required on the replica to set replica_preserve_commit_order=ON, and can be disabled if wanted. When GTID-based replication is in use (GTID_MODE=ON) and SOURCE_AUTO_POSITION is set for the ...
https://dev.mysql.com/doc/refman/8.4/en/replication-functions-async-failover.html
Failover between replicas is controlled by the mysql_start_failover_channels_if_primary member action, which is enabled by default, and can be disabled using the group_replication_disable_member_action function. The following functions enable you ...