Search Results
https://dev.mysql.com/doc/refman/8.4/en/limit-optimization.html
If you combine LIMIT row_count with ORDER BY, MySQL stops sorting as soon as it has found the first row_count rows of the sorted result, rather than sorting the entire result. If ordering is done by using an index, this is very fast. One ... If you ...
https://dev.mysql.com/doc/internals/en/transformation-scalar-in.html
If the select statement has an ORDER BY clause, it will be wiped out, because there is no sense in ORDER BY without LIMIT here. To rewrite a scalar IN subquery, the Item_in_subselect::single_value_transformer method is used. The scalar IN subquery ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-connections-pages-database-processes.html
Important This report retrieves data from the processlist view of the sys schema. If the sys schema, version 1.5.1 or higher, is not installed on the monitored MySQL server, the report is not populated. Table 3.1 Database Processes Dashboard Name ...
https://dev.mysql.com/doc/refman/8.4/en/json.html
You should be aware that the result of this ordering is subject to change and not guaranteed to be consistent across releases. JSON Path Syntax Many of the JSON functions supported by MySQL and described elsewhere in this Manual (see Section 14.17, ...The JSON data type provides these advantages over storing JSON-format strings in a string column: Automatic validation of JSON documents stored in JSON ...
https://dev.mysql.com/doc/refman/8.4/en/window-functions-frames.html
(For details about the permitted units specifiers, see the description of the DATE_ADD() function in Section 14.7, “Date and Time Functions”.) RANGE on a numeric or temporal expr requires ORDER BY on a numeric or temporal expression, ... The ...
https://dev.mysql.com/doc/ndbapi/en/mccj-overview-clusterj-object-models.html
This section discusses the ClusterJ API and the object model used to represent the data handled by the application. The ClusterJ API depends on 4 main interfaces: Session, SessionFactory, Transaction, and QueryBuilder. All access to NDB Cluster ...
https://dev.mysql.com/doc/ndbapi/en/ndb-nodejs-api-context.html
It contains functions that are executed immediately if called from a session, or when the batch is executed. The Mynode implementation does have any concept of a user and does not define any such property. find(Function constructor, Object keys, ...
https://dev.mysql.com/doc/mysql-secure-deployment-guide/8.0/en/secure-deployment-post-install.html
Post-installation setup involves creating a safe directory for import and export operations, configuring server startup options, initializing the data directory, starting MySQL using systemd, resetting the password for the MySQL root@localhost user ...
https://dev.mysql.com/doc/ndbapi/en/ndb-examples-recattr-vs-ndbrecord.html
* Note that this assumes that a operations are executed in * the order they are defined by NDBAPI, which is not guaranteed. To * ensure execution order, the application should perform a NoCommit * execute between operations. * We are assuming that ... This example illustrates the key differences between the old-style NdbRecAttr API and the newer approach using NdbRecord when performing some common tasks in an NDB API ...
https://dev.mysql.com/doc/ndbapi/en/mccj-clusterj-_query.html
Parameters are resolved in the order they were declared in the query. 4.3.1.19.15 setOrdering(Query.Ordering, String...) public abstract void setOrdering(Ordering ordering, String[] orderingFields); Set ordering for the results of this query. There ... A Query instance represents a specific query with bound ...