PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html
admin_ssl_key Command-Line Format --admin-ssl-key=file_name System Variable admin_ssl_key Scope Global Dynamic Yes SET_VAR Hint Applies No Type File name Default Value NULL The admin_ssl_key system variable is like ssl_key, except that it applies to ... The MySQL server maintains many system variables that affect its ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-system-variables.html
group_replication_consistency also determines the fencing mechanism used by newly elected primaries in single primary groups. Use this mode with a group that is intended primarily for read-only operations to ensure that any read/write transactions ... This section lists the system variables that are specific to the Group Replication ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-limitations-syntax.html
Keys and indexes on NDB Cluster tables are subject to the following limitations: Column width. Attempting to create an index on an NDB table column whose width is greater than 3072 bytes is rejected with ER_TOO_LONG_KEY: Specified key was too long; ... Some SQL statements relating to certain MySQL features produce errors when used with NDB tables, as described in the following list: Temporary ...
https://dev.mysql.com/doc/refman/8.0/en/converting-tables-to-innodb.html
These keywords are important to allow multiple sessions to read and write InnoDB tables concurrently, providing substantial scalability benefits in write-heavy workloads. When you convert MyISAM tables that are large, frequently accessed, and hold ... If you have MyISAM tables that you want to convert to InnoDB for better reliability and scalability, review the following guidelines and tips before ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-configuring-consistency-guarantees.html
Although the Transaction Synchronization Points section explains that conceptually there are two synchronization points from which you can choose: on read or on write, these terms were a simplification and the terms used in Group Replication are: ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-foreign-keys.html
MySQL supports foreign keys, which permit cross-referencing related data across tables, and foreign key constraints, which help keep the related data consistent. A foreign key relationship involves a parent table that holds the initial column ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-restore.html
Requires --restore-data ADDED: NDB 8.0.29 --allow-pk-changes Command-Line Format --allow-pk-changes[=0|1] Type Integer Default Value 0 Minimum Value 0 Maximum Value 1 When this option is set to 1, ndb_restore allows the primary keys in a table ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-changing-group-mode.html
This section explains how to change the mode which a group is running in, either single or multi-primary. The functions used to change a group's mode can be run on any member. Changing to Single-Primary Mode Use the ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-ndb-comment-options.html
NDB_COLUMN Options NDB_TABLE Options It is possible to set a number of options specific to NDB Cluster in the table comment or column comments of an NDB table. Table-level options for controlling read from any replica and partition balance can be ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-persistent-stats.html
The number of columns in the table's primary key is also important to consider, as primary key columns are appended to each nonunique index. Note For nonunique indexes, InnoDB appends the columns of the primary key. Only two columns are defined for ... The persistent optimizer statistics feature improves plan stability by storing statistics to disk and making them persistent across server restarts so that the optimizer is more likely to make consistent choices each time for a given ...