Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids-concepts.html
A global transaction identifier (GTID) is a unique identifier created and associated with each transaction committed on the server of origin (the source). This identifier is unique not only to the server on which it originated, but is unique across ...If a client transaction is not written to the binary log (for example, because the transaction was filtered out, or the transaction was read-only), it is not assigned a GTID on the server of ...
https://dev.mysql.com/doc/refman/8.4/en/plugin-loading.html
The statement also registers the plugin in the mysql.plugin table to cause the server to load it on subsequent restarts. Alternatively, the INSTALL PLUGIN statement causes the server to load the plugin code from the library file at runtime: INSTALL ...Built-in Plugins Plugins Registered in the mysql.plugin System Table Plugins Named with Command-Line Options Plugins Installed with the INSTALL PLUGIN Statement Built-in Plugins A built-in plugin is known by the server ...
https://dev.mysql.com/doc/refman/8.4/en/binary-log.html
For example, if you are using InnoDB tables and the MySQL server processes a COMMIT statement, it writes many prepared transactions to the binary log in sequence, synchronizes the binary log, and then commits the transaction into InnoDB. The session ...You enable encryption on a MySQL server by setting the binlog_encryption system variable to ...The binary log has two important purposes: For replication, the ...
https://dev.mysql.com/doc/refman/8.4/en/replication-options-gtids.html
The MySQL Server system variables described in this section are used to monitor and control Global Transaction Identifiers (GTIDs). If all binary logs on the server were generated using MySQL 5.7.8 or later, binlog_gtid_simple_recovery=TRUE can ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-option-tables.html
Ndb_api_uk_op_count: Number of operations based on or using unique keys by this MySQL Server (SQL node). Ndb_api_wait_meta_request_count: Number of times thread has been blocked waiting for metadata-based signal by this MySQL Server (SQL node). For ... The following list includes command-line options, system variables, and status variables applicable within mysqld when it is running as an SQL node in an NDB ...
https://dev.mysql.com/doc/refman/8.4/en/webauthn-pluggable-authentication.html
Before installing the server-side plugin, define a unique name for the relying party ID (used for device registration and authentication), which is the MySQL server. MySQL Enterprise Edition supports an authentication method that enables users to ...
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin-remote.html
To determine the MySQL server version, issue the following query: mysql> SHOW VARIABLES LIKE 'version'; +---------------+-------+ | Variable_name | Value | +---------------+-------+ | version | 8.4.6 | +---------------+-------+ The donor and ... The ...When the optional DATA DIRECTORY [=] 'clone_dir' clause is not used, a cloning operation removes user-created data (schemas, tables, tablespaces) and binary logs from the recipient data directory, clones the new data to the recipient data directory, and automatically restarts the server ...
https://dev.mysql.com/doc/connectors/en/connector-j-usagenotes-troubleshooting.html
Questions 3.14.1: When I try to connect to the database with MySQL Connector/J, I get the following exception: SQLException: Server configuration denies access to data source SQLState: 08001 VendorError: 0 What is going on? I can connect just fine ...Why is this happening? 3.14.3: I'm trying to use MySQL Connector/J in an applet or application and I get an exception similar to: SQLException: Cannot connect to MySQL server on ...
https://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-troubleshooting.html
Questions 16.1: When I try to connect to the database with MySQL Connector/J, I get the following exception: SQLException: Server configuration denies access to data source SQLState: 08001 VendorError: 0 What is going on? I can connect just fine ...
https://dev.mysql.com/doc/mysql-secure-deployment-guide/8.0/en/secure-deployment-post-install.html
Server version 8.0.19-commercial Protocol version 10 Connection Localhost via UNIX socket UNIX socket /tmp/mysql.sock Uptime: 11 min 7 sec Threads: 3 Questions: 8 Slow queries: 0 Opens: 146 Flush tables: 3 Open tables: 63 Queries per second avg: ...