Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-index-stat.html
To force them to be created (or updated if they already exist), invoke ndb_index_stat with the --update option, or execute ANALYZE TABLE on the table in the mysql client. --connect-retry-delay Command-Line Format --connect-retry-delay=# Type Integer ... ndb_index_stat provides per-fragment statistical information about indexes on NDB ...
https://dev.mysql.com/doc/refman/8.4/en/sys-processlist.html
The MySQL process list indicates the operations currently being performed by the set of threads executing within the server. For MySQL Community Edition Server, MySQL Enterprise Edition Server (on-premise), and MySQL HeatWave Service without MySQL ...state An action, event, or state that indicates what the thread is ...They provide more complete information than the SHOW PROCESSLIST ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-next-result.html
Its asynchronous counterpart is mysql_next_result_nonblocking(), for use by applications that require asynchronous communication with the server. mysql_next_result() reads the next statement result and returns a status to indicate whether more ...If ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-stmt-fetch.html
Setting the STMT_ATTR_UPDATE_MAX_LENGTH attribute causes the maximal length of column values to be indicated by the max_length member of the result set metadata returned by mysql_stmt_result_metadata(). Invoke mysql_stmt_fetch() with a zero-length ... int mysql_stmt_fetch(MYSQL_STMT *stmt) Description mysql_stmt_fetch() returns the next row in the result ...It returns the data ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-stmt-send-long-data.html
bool mysql_stmt_send_long_data(MYSQL_STMT *stmt, unsigned int parameter_number, const char *data, unsigned long length) Description Enables an application to send parameter data to the server in pieces (or “chunks”). data is a pointer to a ...
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 ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-limitations-other.html
For example, the following query is not offloaded: mysql> SELECT AVG(c1) AS value FROM t1 WHERE c1 IS NULL; Primary keys with column prefixes. Queries that call a stored function are not supported before MySQL 9.5.0. As of MySQL 9.5.0, queries that ...For a list of supported SQL modes, see Section 5.2, “Supported SQL ...Comparison ...
https://dev.mysql.com/doc/refman/8.4/en/binary-log-formats.html
The server uses several logging formats to record information in the binary log: Replication capabilities in MySQL originally were based on propagation of SQL statements from source to replica. You can cause this format to be used by starting the ...With mixed logging, statement-based logging is used by default, but the logging mode switches automatically to row-based in certain cases as described ...
https://dev.mysql.com/doc/refman/8.4/en/locking-functions.html
When this happens, the server chooses a caller and terminates its lock-acquisition request with an ER_USER_LOCK_DEADLOCK error. Since GET_LOCK() establishes a lock only on a single mysqld, it is not suitable for use with NDB Cluster, which has no ...