Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-install-windows-initial-start.html
The output should appear similar to what is shown here: C:\mysql\bin> ndb_mgmd 2010-06-23 07:53:34 [MgmtSrvr] INFO -- NDB Cluster Management Server. The management node should be started first, followed by the data nodes, and then finally by any SQL ... Once the NDB Cluster executables and needed configuration files are in place, performing an initial start of the cluster is simply a matter of starting the NDB Cluster executables for all nodes in the ...
https://dev.mysql.com/doc/connectors/en/connector-net-tutorials-mysqlscript.html
This method causes the script (sequence of statements) assigned to the Query property of the MySqlScript object to be executed. The Query property can be set through the MySqlScript constructor or by using the Query property. MySqlScript script = ...
https://dev.mysql.com/doc/connector-net/en/connector-net-tutorials-mysqlscript.html
This method causes the script (sequence of statements) assigned to the Query property of the MySqlScript object to be executed. The Query property can be set through the MySqlScript constructor or by using the Query property. MySqlScript script = ...
https://dev.mysql.com/doc/refman/8.4/en/data-masking-components-installation.html
$> mysql -u root -p -e "SET PERSIST_ONLY component_masking.masking_database=mask_db" Enter password: (enter root password here) After modifying the variable, restart the server to cause the new setting to take effect. Components provide expanded ...
https://dev.mysql.com/doc/refman/8.4/en/declare-handler.html
It can take the following forms: mysql_error_code: An integer literal indicating a MySQL error code, such as 1051 to specify “unknown table”: DECLARE CONTINUE HANDLER FOR 1051 BEGIN -- body of handler END; Do not use MySQL error code 0 because ...statement handler_action: { CONTINUE | EXIT | UNDO } condition_value: { mysql_error_code | SQLSTATE [VALUE] sqlstate_value | condition_name | SQLWARNING | NOT FOUND | SQLEXCEPTION } The DECLARE ...
https://dev.mysql.com/doc/internals/en/creating-handlerton.html
An integer that uniquely identifies the storage engine within the MySQL server. Possible values are defined in sql/handler.h and copied here: #define HTON_NO_FLAGS 0 #define HTON_CLOSE_CURSORS_AT_COMMIT (1 << 0) #define HTON_ALTER_NOT_SUPPORTED (1 ...This method is only called once when the server starts to allow the storage engine class to perform any housekeeping that is necessary before handlers are ... The handlerton (short for handler singleton) defines the ...
https://dev.mysql.com/doc/refman/8.4/en/create-index.html
For a unique index, an error occurs regardless of SQL mode because reducing the index length might enable insertion of nonunique entries that do not meet the specified uniqueness requirement. For more information, see Section 15.1.9, “ALTER TABLE ... CREATE [UNIQUE | FULLTEXT | SPATIAL] INDEX index_name [index_type] ON tbl_name (key_part,...) [index_option] [algorithm_option | lock_option] ...
https://dev.mysql.com/doc/refman/8.4/en/firewall-reference.html
In response to such a mode-setting attempt, the firewall produces a diagnostic message that is returned as a result set rather than as an SQL error: mysql> CALL sp_set_firewall_mode('a@b','PROTECTING'); ...The firewall database can be the mysql ...
https://dev.mysql.com/doc/refman/8.4/en/identifiers.html
mysql> SET sql_mode='ANSI_QUOTES'; mysql> CREATE TABLE "test" (col INT); Query OK, 0 rows affected (0.00 sec) The ANSI_QUOTES mode causes the server to interpret double-quoted strings as identifiers. The server SQL mode is controlled as described in ... Certain objects within MySQL, including database, table, index, column, alias, view, stored procedure, partition, tablespace, resource group and other object names are known as ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-rolling-restart.html
This also applies to any MySQL Server version change that may apply, in addition to the NDB engine version change, so do not forget to take this into account when planning the upgrade. To make a change in the cluster's configuration, such as adding ... This section discusses how to perform a rolling restart of an NDB Cluster installation, so called because it involves stopping and starting (or restarting) each node in turn, so that the cluster itself remains ...