Search Results
https://dev.mysql.com/doc/refman/8.4/en/query-attributes.html
Query attribute names are transmitted using the character set indicated by the character_set_client system variable. INSTALL COMPONENT loads the component, and also registers it in the mysql.component system table to cause it to be loaded during ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-replication-asynchronous-connection-failover-table.html
For the GroupReplication managed service, the identifier is the value of the group_replication_group_name system variable. You set and manage source lists using the asynchronous_connection_failover_add_source and ... This table holds the replica's ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-transaction-tables.html
For example, when the autocommit system variable is enabled, the start of each statement starts a new transaction. Transaction Boundaries In MySQL Server, transactions start explicitly with these statements: START TRANSACTION | BEGIN | XA START | XA ...Within the event hierarchy, wait events nest within stage events, which nest within statement events, which nest within transaction ...
https://dev.mysql.com/doc/refman/8.4/en/replication-asynchronous-connection-failover-source.html
For a managed group, you also specify the type of managed service (currently only Group Replication is available), and the identifier of the managed group (for Group Replication, this is the value of the group_replication_group_name system variable). You set and manage source lists using the asynchronous_connection_failover_add_source and asynchronous_connection_failover_delete_source functions to add and remove single replication source ...
https://dev.mysql.com/doc/refman/8.4/en/replication-encrypted-connections.html
The SOURCE_TLS_VERSION option specifies a comma-separated list of the TLS encryption protocols permitted by the replica for the replication connection, in a format like that for the tls_version server system variable. To use an encrypted connection ...You must obtain (or create) a suitable security certificate that you can use on the source, and a similar certificate (from the same certificate authority) on each ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/mysql-threads.html
The MySQL server creates the following threads: Connection manager threads handle client connection requests on the network interfaces that the server listens to. The server does not create threads to handle interfaces that it does not listen to.
https://dev.mysql.com/doc/refman/8.4/en/backup-methods.html
If the server was not started with that variable set, the directory location is the value of the tmpdir system variable. The location of this directory is the value of the system variable replica_load_tmpdir. To get a consistent backup, stop the ...
https://dev.mysql.com/doc/relnotes/connector-net/en/news-8-0-9.html
(Bug #25829054, Bug #25860579, WL #10954) MySQL Connector/NET now supports MySQL servers configured to use utf8mb4 as the default character set. (WL #10949) Support for connections using Unix domain socket files was extended to include MySQL servers ...For example: SessionConfigManager.Save( "mysess", "{ \"uri\": \"mysqlx://myuser@localhost/mysess\", \"appdata\": { \"biz\": \"quux\" } }" ); SessionConfigManager.Save( "mysess", "{ \"uri\": \"mysqlx://test@localhost/mysess\", \"appdata\": { \"tar\": \"zzzz\" } }" ); The mysess.uri and mysess.appdata values set by the first statement are replaced with the new values set by the second ...
https://dev.mysql.com/doc/refman/8.4/en/introduction.html
MySQL Server is intended for mission-critical, heavy-load production systems as well as for embedding into mass-deployed software. The MySQL software delivers a very fast, multithreaded, multi-user, and robust SQL (Structured Query Language) ...
https://dev.mysql.com/doc/refman/8.4/en/mysqldump-delimited-text.html
The following command dumps the contents of the db1 database to files in the /tmp database: $> mysqldump --tab=/tmp db1 The .txt files containing table data are written by the server, so they are owned by the system account used for running the ...