Search Results
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-get.html
row *************************** Name: NodeIdServer Value: NULL Process1: ndb_mgmd NodeId1: 49 Process2: ndbmtd NodeId2: 1 Level: Default Comment: Mandatory *************************** 9. get [--include-defaults|-d] [--all] ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-list-warnings.html
mcm> list warnings --max=4 Timestamp Host Message 2022-01-06 06:49:09 torsk ndb_cluster_connection_pool specified without ndb_cluster_connection_pool_nodeids 2022-01-06 10:17:22 flundra Config variable max_delayed_threads was deprecated in mysqld ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-show-warnings.html
Using the show warnings command, you can check the warnings (up to the last five) issued to the agent log (mcmd.log). | | Warning | 1287 | 2021-07-12 21:27:38 '@@delayed_insert_timeout' is deprecated and will be removed in a future release.
https://dev.mysql.com/doc/refman/9.7/en/adding-character-set.html
Add these lines to the “declaration” section: #ifdef HAVE_CHARSET_MYSET extern CHARSET_INFO my_charset_MYSET_general_ci; extern CHARSET_INFO my_charset_MYSET_bin; #endif Add these lines to the “registration” section: #ifdef ... This section ...
https://dev.mysql.com/doc/refman/9.7/en/bit-value-literals.html
For example, a bit literal assigned to a user-defined variable is a binary string by default. A leading 0b is case-sensitive and cannot be written as 0B. In numeric contexts, MySQL treats a bit literal like an integer. To ensure numeric treatment of ...
https://dev.mysql.com/doc/refman/9.7/en/clone-plugin-concurrent-ddl.html
Concurrent DDL support on the donor is controlled by the clone_block_ddl variable. In MySQL 9.7, concurrent DDL is permitted on the donor by default. Concurrent DDL support can be enabled and disabled dynamically using a SET statement like this ...
https://dev.mysql.com/doc/refman/9.7/en/enum.html
For example, this CREATE TABLE statement does not work because the CONCAT function cannot be used to construct an enumeration value: CREATE TABLE sizes ( size ENUM('small', CONCAT('med','ium'), 'large') ); You also cannot employ a user variable as ... An ENUM is a string object with a value chosen from a list of permitted values that are enumerated explicitly in the column specification at table creation ...
https://dev.mysql.com/doc/refman/9.7/en/explain-for-connection.html
To obtain the execution plan for an explainable statement executing in a named connection, use this statement: EXPLAIN [options] FOR CONNECTION connection_id; EXPLAIN FOR CONNECTION returns the EXPLAIN information that is currently being used to ...
https://dev.mysql.com/doc/refman/9.7/en/extended-show.html
Some extensions to SHOW statements accompany the implementation of INFORMATION_SCHEMA: SHOW can be used to get information about the structure of INFORMATION_SCHEMA itself. Several SHOW statements accept a WHERE clause that provides more ...
https://dev.mysql.com/doc/refman/9.7/en/group-replication-flow-control.html
MySQL Group Replication ensures that a transaction commits only after a majority of the members in a group have received it and agreed on the relative order amongst all transactions sent concurrently. This approach works well if the total number of ...