PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.5Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/group-replication-frequently-asked-questions.html
What is the group_replication_bootstrap_group option used for? The bootstrap flag instructs a member to create a group and act as the initial seed server. When the group is originally created, or when shutting down and restarting the entire group.
https://dev.mysql.com/doc/refman/8.0/en/group-replication-responses-failure-expel.html
You can use the group_replication_member_expel_timeout system variable, which is available from MySQL 8.0.13, to allow additional time between the creation of a suspicion and the expulsion of the suspect member. A suspicion is created when one ...A ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-secure-user.html
20.6.3.1.1 Replication User With The Caching SHA-2 Authentication Plugin By default, users created in MySQL 8 use Section 8.4.1.2, “Caching SHA-2 Pluggable Authentication”. For more information on RSA key-pairs, see Section 8.3.3, “Creating ...
https://dev.mysql.com/doc/refman/8.0/en/hash-joins.html
If this happens, you should be aware that the join may not succeed if a hash join cannot fit into memory and it creates more files than set for open_files_limit. By default, MySQL (8.0.18 and later) employs hash joins whenever possible. It is ...
https://dev.mysql.com/doc/refman/8.0/en/identifier-case-sensitivity.html
To avoid problems caused by such differences, it is best to adopt a consistent convention, such as always creating and referring to databases and tables using lowercase names. Value Meaning 0 Table and database names are stored on disk using the ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-partitions-table.html
PARTITION_EXPRESSION The expression for the partitioning function used in the CREATE TABLE or ALTER TABLE statement that created the table's current partitioning scheme. For each such row: The SUBPARTITION_NAME, SUBPARTITION_ORDINAL_POSITION, ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-user-attributes-table.html
Attributes are shown exactly as set using CREATE USER and ALTER USER statements with ATTRIBUTE or COMMENT options. For additional information and examples, see CREATE USER Comment and Attribute Options. The currently authenticated account has the ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-and-mysql-replication.html
It is possible to use replication in a way where the storage engine on the replica is not the same as the storage engine on the source. For example, you can replicate modifications to an InnoDB table on the source to a MyISAM table on the replica.
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-internals.html
The cache_policies table, config_options table, and containers table are created by the innodb_memcached_config.sql configuration script in the innodb_memcache database. The containers table contains a default entry for the test.demo_test table, ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-porting-mysql.html
CREATE VIEW numbers AS SELECT c1 KEY, CAST(c2 AS UNSIGNED INTEGER) val FROM demo_test WHERE c2 BETWEEN '0' and '9999999999'; SELECT SUM(val) FROM numbers; Note Any alphabetic values in the result set are converted into 0 by the call to CAST().