Search Results
https://dev.mysql.com/doc/ndbapi/en/mccj-clusterj-_query.html
A Query instance represents a specific query with bound parameters. Table 4.37 deletePersistentAll() Parameter Description return the number of instances deleted 4.3.1.19.9 execute(Map<String, ?>) public abstract Results<E> execute(Map<String, ?> ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-rpd-query-stats-table.html
For MySQL HeatWave AutoML routines that include multiple sub-queries, such as ML_TRAIN, a new record is used for each query. The rpd_query_stats table stores query compilation and execution statistics produced by the MySQL HeatWave plugin in JSON ...The rpd_query_stats table has these columns: CONNECTION_ID The ID of the ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-params-api.html
The listing in this section provides information about parameters used in the [mysqld] and [api] sections of a config.ini file for configuring NDB Cluster SQL nodes and API nodes. For detailed descriptions and other additional information about ...
https://dev.mysql.com/doc/connectors/en/connector-j-connp-props-high-availability-and-clustering.html
autoReconnect Should the driver try to re-establish stale and/or dead connections? If enabled the driver will throw an exception for queries issued on a stale or dead connection, which belong to the current transaction, but will attempt reconnect ...Default Value 3 Since Version 1.1 reconnectAtTxEnd If 'autoReconnect' is set to "true", should the driver attempt reconnections at the end of every transaction? Default Value false Since Version 3.0.10 retriesAllDown When using load balancing or failover, the number of times the driver should cycle through available hosts, attempting to ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-locks-set.html
A locking read, an UPDATE, or a DELETE generally set record locks on every index record that is scanned in the processing of an SQL statement. If you have no indexes suitable for your statement and MySQL must scan the entire table to process the ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-limitations-syntax.html
Some SQL statements relating to certain MySQL features produce errors when used with NDB tables, as described in the following list: Temporary tables. Using nullable columns in unique keys and primary keys means that queries using these columns are ...Trying either to create a temporary table that uses the NDB storage engine or to alter an existing temporary table to use NDB fails with the error Table storage engine 'ndbcluster' does not support the create option ...
https://dev.mysql.com/doc/refman/8.4/en/account-activity-auditing.html
Applications can use the following guidelines to perform SQL-based auditing that ties database activity to MySQL accounts. The User and Host column values in this row uniquely identify the account and correspond to the 'user_name'@'host_name' ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-autopilot-shape-advisor-sql.html
Autopilot Shape Advisor with a MySQL Client 17.3.2 Autopilot Shape Advisor with a MySQL Client Auto Shape Prediction records predictions in the shape_predictions table in the mysql_autopilot schema on the MySQL server. The MySQL HeatWave Console ...
https://dev.mysql.com/doc/refman/8.4/en/differences-from-ansi.html
We try to make MySQL Server follow the ANSI SQL standard and the ODBC SQL standard, but MySQL Server performs operations differently in some cases: There are several differences between the MySQL and standard SQL privilege systems. For example, in ...You must explicitly issue a REVOKE statement to revoke privileges for a ...
https://dev.mysql.com/doc/refman/8.4/en/statement-optimization.html
The core logic of a database application is performed through SQL statements, whether issued directly through an interpreter or submitted behind the scenes through an API. The tuning guidelines in this section help to speed up all kinds of MySQL ...