Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-security-networking-issues.html
See Section 8.1.3, “Making MySQL Secure Against Attackers”, for a description of techniques you can use to secure MySQL servers. We show an example of an NDB Cluster setup using such a physically segregated network here: Figure 25.7 NDB Cluster ...Any ndb_mgm client This means that any cluster management client that is given the management server's host name (or IP address) and port (if not the standard port) can connect to the cluster and execute any management client ...
https://dev.mysql.com/doc/refman/8.4/en/alter-table.html
The outcome of attempting to change the storage engine of a table is affected by whether the desired storage engine is available and the setting of the NO_ENGINE_SUBSTITUTION SQL mode, as described in Section 7.1.11, “Server SQL Modes”. NDB ...| ... ALTER TABLE tbl_name [alter_option [, alter_option] ...] [partition_options] alter_option: { table_options | ADD [COLUMN] col_name column_definition [FIRST | AFTER col_name] | ADD [COLUMN] (col_name column_definition,...) | ADD {INDEX | KEY} [index_name] [index_type] (key_part,...) [index_option] ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-shm-definition.html
The shared-memory transporter (SHM) can improve performance by negating up to 20% of the overhead required by a TCP connection when running an API node (usually an SQL node) and a data node together on the same host. Suppose a cluster is running a ... Communications between NDB cluster nodes are normally handled using ...
https://dev.mysql.com/doc/workbench/en/wb-data-modeling-menus.html
The Database menu has these items: Query Database: Launches the SQL Editor, which enables you to create SQL code and execute it on a live server. The MySQL Workbench Commercial Editions include an advanced Find facility for models, as indicated in ... Some menu items are not available in the MySQL Workbench Community Edition of this application, and are available only in the MySQL Workbench Commercial ...
https://dev.mysql.com/doc/refman/8.4/en/function-resolution.html
MySQL supports built-in (native) functions, loadable functions, and stored functions. This section describes how the server recognizes whether the name of a built-in function is used as a function call or as an identifier, and how the server ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-config.html
This tool extracts current configuration information for data nodes, SQL nodes, and API nodes from one of a number of sources: an NDB Cluster management node, or its config.ini or my.cnf file. --config-binary-file=path-to-file Command-Line Format ...By default, the management node is the source for the configuration data; to override the default, execute ndb_config with the --config-file or --mycnf ...
https://dev.mysql.com/doc/refman/8.4/en/resource-groups.html
MySQL supports creation and management of resource groups, and permits assigning threads running within the server to particular groups so that threads execute according to the resources available to the group. The following sections describe ...
https://dev.mysql.com/doc/refman/8.4/en/optimize-table.html
To keep the index maintenance period to a reasonable time, set the innodb_ft_num_word_optimize option to specify how many words to update in the search index, and run a sequence of OPTIMIZE TABLE statements until the search index is fully updated.
https://dev.mysql.com/doc/refman/8.4/en/with.html
Each subclause provides a subquery that produces a result set, and associates a name with the subquery. They are defined using a WITH clause: with_clause: WITH [RECURSIVE] cte_name [(col_name [, col_name] ...)] AS (subquery) [, cte_name [(col_name ... A common table expression (CTE) is a named temporary result set that exists within the scope of a single statement and that can be referred to later within that statement, possibly multiple ...
https://dev.mysql.com/doc/connectors/en/connector-net-programming-mysqlcommand.html
Query-attributes support varies by server version: Prior to MySQL Server 8.0.23: no support for query attributes. MySQL Server 8.0.23 to 8.0.24: support for query attributes in regular statements only. MySQL Server 8.0.25 and higher: support for ...