Search Results
https://dev.mysql.com/doc/refman/8.4/en/subquery-errors.html
Incorrect number of rows from subquery: ERROR 1242 (ER_SUBSELECT_NO_1_ROW) SQLSTATE = 21000 Message = "Subquery returns more than 1 row" This error occurs for statements where the subquery must return at most one row but returns multiple rows.
https://dev.mysql.com/doc/refman/8.4/en/sys-statement-performance-analyzer.html
Creates a report of the statements running on the server. The views are calculated based on the overall and/or delta activity. This procedure disables binary logging during its execution by manipulating the session value of the sql_log_bin system ...
https://dev.mysql.com/doc/refman/8.4/en/upgrading-what-is-upgraded.html
Installing a new version of MySQL may require upgrading these parts of the existing installation: The mysql system schema, which contains tables that store information required by the MySQL server as it runs (see Section 7.3, “The mysql System ...
https://dev.mysql.com/doc/refman/8.4/en/window-function-optimization.html
Window functions affect the strategies the optimizer considers: Derived table merging for a subquery is disabled if the subquery has window functions. Semijoins are not applicable to window function optimization because semijoins apply to ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-install-configuration-file.html
The mcmd configuration file allows you to configure mcmd with its application options. A sample configuration file is provided with the MySQL Cluster Manager distribution at mcmd8.4.6/doc/sample_mcmd.conf. Edit the [mcmd] section of the file and ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-restart-cluster.html
restart cluster [--sequential-restart] cluster_name This command performs a rolling restart (see Performing a Rolling Restart of an NDB Cluster) of the cluster named cluster_name. The cluster must already be running in order for this command to ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-terminology.html
This section provides definitions of key terms used to describe MySQL Cluster Manager and its components in this manual and in other documentation relating to MySQL Cluster Manager and MySQL NDB Cluster. A set of hosts on which MySQL NDB Cluster ...
https://dev.mysql.com/doc/mysql-errors/8.4/en/client-error-reference.html
Client error messages originate from within the MySQL client library. Here is an example client error message, as displayed by the mysql client: $> mysql -h no-such-host ERROR 2005 (HY000): Unknown MySQL server host 'no-such-host' (0) Each client ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-prepared-call-statements.html
This section describes prepared-statement support in the C API for stored procedures executed using CALL statements: Stored procedures executed using prepared CALL statements can be used in the following ways: A stored procedure can produce any ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-next-result.html
int mysql_next_result(MYSQL *mysql) Description Note mysql_next_result() is a synchronous function. Its asynchronous counterpart is mysql_next_result_nonblocking(), for use by applications that require asynchronous communication with the server.