PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/group-replication-connection-security.html
Group Replication Requirements For The MySQL Communication Stack The network address configured by the group_replication_local_address system variable for each group member must be set to one of the IP addresses and ports that MySQL Server is ...
https://dev.mysql.com/doc/refman/8.0/en/range-optimization.html
For the data set shown earlier, the algorithm operates like this: Get the first distinct value of the first key part (f1 = 1). The predicates on A_1, ..., A_k must be equality predicates and they must be constants. The query must be a conjunctive ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-configuration-overview.html
When performing a node restart or an initial node restart, all of the cluster's data nodes must be restarted in turn (also referred to as a rolling restart). All tables include the data type for the parameter, option, or variable, as well as its ...
https://dev.mysql.com/doc/refman/8.0/en/replication-gtids-howto.html
Tell the replica to use the source with GTID based transactions as the replication data source, and to use GTID-based auto-positioning rather than file-based positioning. Instruct the replica to use the source as the replication data source and to ...This is a “cold start” procedure that assumes either that you are starting the source server for the first time, or that it is possible to stop it; for information about provisioning replicas using GTIDs from a running source server, see Section 19.1.3.5, “Using GTIDs for Failover and ...
https://dev.mysql.com/doc/refman/8.0/en/replication-administration-skip.html
First you need to identify the replicated event that caused the error. Details of the error and the last successfully applied transaction are recorded in the Performance Schema table replication_applier_status_by_worker. You can use mysqlbinlog to ... If replication stops due to an issue with an event in a replicated transaction, you can resume replication by skipping the failed transaction on the ...
https://dev.mysql.com/doc/refman/8.0/en/implicit-commit.html
The CREATE TABLE statement in InnoDB is processed as a single transaction. SELECT.) Statements that implicitly use or modify tables in the mysql database. LOAD DATA causes an implicit commit only for tables using the NDB storage engine. The ...
https://dev.mysql.com/doc/refman/8.0/en/external-locking.html
External locking is the use of file system locking to manage contention for MyISAM database tables by multiple processes. Here are some examples: If you run multiple servers that use the same database directory (not recommended), each server must ...If you use myisamchk for write operations such as repairing or optimizing tables, or if you use myisampack to pack tables, you must always ensure that the mysqld server is not using the ...
https://dev.mysql.com/doc/refman/8.0/en/replication-mode-change-online-disable-gtids.html
The file and channel names are strings; both of these must be quoted when used in the STOP REPLICA, CHANGE REPLICATION SOURCE TO, and START REPLICA statements. The file and channel names are strings, and so must be quoted when used in the STOP ...
https://dev.mysql.com/doc/refman/8.0/en/enterprise-encryption-functions-legacy.html
MySQL Enterprise Encryption functions have these general characteristics: For arguments of the wrong type or an incorrect number of arguments, each function returns an error. For successful decryption, the key string must correspond to the public or ... In releases before MySQL 8.0.30, MySQL Enterprise Encryption's functions are based on the openssl_udf shared ...This occurs, for example, if a function does not support a specified ...
https://dev.mysql.com/doc/refman/8.0/en/estimating-performance.html
In MySQL, an index block is usually 1,024 bytes and the data pointer is usually four bytes. This index would require storage of about 500,000 * 7 * 3/2 = 5.2MB (assuming a typical index buffer fill ratio of 2/3), so you probably have much of the ...