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/performance-schema-table-wait-summary-tables.html
The table_io_waits_summary_by_table table has these grouping columns to indicate how the table aggregates events: OBJECT_TYPE, OBJECT_SCHEMA, and OBJECT_NAME. The only difference is the additional group column, INDEX_NAME, which corresponds to the ... The following sections describe the table I/O and lock wait summary tables: table_io_waits_summary_by_index_usage: Table I/O waits per index table_io_waits_summary_by_table: Table I/O waits per table table_lock_waits_summary_by_table: Table lock waits per table 29.12.20.8.1 The table_io_waits_summary_by_table Table The table_io_waits_summary_by_table table aggregates all table I/O wait events, as generated by the wait/io/table/sql/handler ...
https://dev.mysql.com/doc/refman/8.0/en/replication-security.html
For Group Replication, binary log encryption and privilege checks can be used as a security measure on replication group members. You should also consider encrypting the connections between group members, comprising group communication connections ... To protect against unauthorized access to data that is stored on and transferred between replication source servers and replicas, set up all the servers involved using the security measures that you would choose for any MySQL instance in your installation, as described in Chapter 8, ...
https://dev.mysql.com/doc/refman/8.0/en/stop-replica.html
Note that the Group Replication applier channel (group_replication_applier) has no replication I/O (receiver) thread, only a replication SQL (applier) thread. The replication channels for Group Replication (group_replication_applier and ...] ...
https://dev.mysql.com/doc/refman/8.0/en/thread-pool-tuning.html
Of chief importance is the number of thread groups in the thread pool, which can be set on server startup using the --thread-pool-size option; this cannot be changed at runtime. The maximum number of query threads permitted in a thread group is ...
https://dev.mysql.com/doc/refman/8.0/en/using-encrypted-connections.html
See Section 20.6.2, “Securing Group Communication Connections with Secure Socket Layer (SSL)”. Several configuration parameters are available to indicate whether to use encrypted connections, and to specify the appropriate certificate and key ...
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/general-thread-states.html
Copying to group table If a statement has different ORDER BY and GROUP BY criteria, the rows are sorted by group and copied to a temporary table. Sorting for group The thread is doing a sort to satisfy a GROUP BY. The following list describes ...
https://dev.mysql.com/doc/refman/8.0/en/ipv6-support.html
From MySQL 8.0.14, Group Replication group members can use IPv6 addresses for communications within the group. A group can contain a mix of members using IPv6 and members using IPv4. See Section 20.5.5, “Support For IPv6 And For Mixed IPv6 And ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-install-linux-binary.html
This section covers the steps necessary to install the correct executables for each type of Cluster node from precompiled binaries supplied by Oracle. For setting up a cluster using precompiled binaries, the first step in the installation process ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-online-add-node-basics.html
Execute one or more CREATE NODEGROUP commands in the NDB Cluster management client to create the new node group or node groups to which the new data nodes belong. Note This needs to be done only for tables already existing at the time the new node ... In this section, we list the basic steps required to add new data nodes to an NDB ...