Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-replication.html
This section explains how to set up and manage a configuration in which one group of computers operating as an NDB Cluster replicates to a second computer or group of computers. Note NDB Cluster does not support replication using GTIDs; ... NDB ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-indexes.html
For example: SELECT MIN(key_part2),MAX(key_part2) FROM tbl_name WHERE key_part1=10; To sort or group a table if the sorting or grouping is done on a leftmost prefix of a usable index (for example, ORDER BY key_part1, key_part2). (Or, if the index is ... Indexes are used to find rows with specific column values ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-innodb-cluster-introduction.html
MySQL Server, and Group Replication, which enables a set of MySQL instances to provide high-availability. InnoDB Cluster provides an alternative, easy to use programmatic way to work with Group Replication. The following diagram shows an overview of ... This chapter introduces MySQL InnoDB Cluster, which combines MySQL technologies to enable you to deploy and administer a complete integrated high availability solution for ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-firewall-tables.html
They provide information about firewall operation: firewall_groups: Information about firewall group profiles. The following sections describe the Performance Schema tables associated with MySQL Enterprise Firewall (see Section 8.4.7, “MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-ndb-sync-pending-objects-table.html
This table provides information about NDB database objects for which mismatches have been detected and which are waiting to be synchronized between the NDB dictionary and the MySQL data dictionary.
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-table-descriptions.html
Tables in the performance_schema database can be grouped as follows: Setup tables. These tables contain information aggregated over groups of events, including those that have been discarded from the history tables. These do not fall into any of ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-threads-table.html
row *************************** THREAD_ID: 1 NAME: thread/sql/main TYPE: BACKGROUND PROCESSLIST_ID: NULL PROCESSLIST_USER: NULL PROCESSLIST_HOST: NULL PROCESSLIST_DB: mysql PROCESSLIST_COMMAND: NULL PROCESSLIST_TIME: 418094 PROCESSLIST_STATE: NULL ... The threads table contains a row for each server ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-tp-connections-table.html
TP_GROUP_ID The index of the thread group in the global array. CONNECT_HANDLER_INDEX The index of the connection handler thread in the group which processed the connection request; a higher number means the connection load has triggered the creation ... The tp_connections table contains one row per connection managed by the Thread Pool ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-tp-thread-state-table.html
The tp_thread_state table has these columns: TP_GROUP_ID The thread group ID. TP_GROUP_ID and TP_THREAD_NUMBER together provide a unique key within the table. The xxx_WAIT columns of the tp_thread_group_stats table accumulate counts for each wait ...
https://dev.mysql.com/doc/refman/8.4/en/problems-with-float.html
Floating-point numbers sometimes cause confusion because they are approximate and not stored as exact values. A floating-point value as written in an SQL statement may not be the same as the value represented internally. Attempts to treat ...