Search Results
https://dev.mysql.com/doc/internals/en/optimizer-definitions.html
This description uses a narrow definition: The optimizer is the set of routines which decide what execution path the DBMS should take for queries. MySQL changes these routines frequently, so you should compare what is said here with what's in the ...
https://dev.mysql.com/doc/internals/en/optimizer-index-merge-join-type.html
7.2.2.5.3 The range Optimizer For range queries, the MySQL optimizer builds a SEL_TREE object which represents a condition in this form: range_cond = (cond_key_1 AND cond_key_2 AND ... 7.2.2.5.1 Overview Index Merge is used when table condition can ...
https://dev.mysql.com/doc/internals/en/optimizer-order-by-clauses.html
In general, the optimizer will skip the sort procedure for the ORDER BY clause if it sees that the rows will be in order anyway. For the query: SELECT column1 FROM Table1 ORDER BY 'x'; the optimizer will throw out the ORDER BY clause. For the ...
https://dev.mysql.com/doc/internals/en/prepared-stored-procedure-execution.html
Execution of a stored procedure statement is similar to execution of a prepared statement. During execution of a stored procedure, THD::stmt_arena points to the permanent query arena of the stored procedure. This arena happens to be also the ...
https://dev.mysql.com/doc/internals/en/tracing-example.html
All traces have the same basic structure, but if a statement uses subqueries, there are several join preparations/optimizations/executions, subquery-specific transformations not shown here... The statement's execution is naturally made of "steps": ...
https://dev.mysql.com/doc/ndbapi/en/mccj-overview-clusterj-object-models.html
The QueryBuilder interface makes it possible to construct criteria queries dynamically, using domain object model properties as query modeling elements. This section discusses the ClusterJ API and the object model used to represent the data handled ...
https://dev.mysql.com/doc/ndbapi/en/ndb-error-codes-schema-error.html
The following list enumerates all NDB errors of type SE (Schema error).
https://dev.mysql.com/doc/relnotes/connector-net/en/news-8-0-10.html
Functionality Added or Changed Bugs Fixed Functionality Added or Changed The .NET Core 2.0 implementation now supports the following connection-string options: AutoEnlist, InteractiveSession, Logging, Replication, and UseUsageAdvisor. (Bug ...
https://dev.mysql.com/doc/relnotes/connector-odbc/en/news-8-0-26.html
Deprecation and Removal Notes Functionality Added or Changed Bugs Fixed Deprecation and Removal Notes The TLSv1.0 and TLSv1.1 connection protocols are now deprecated and support for them is subject to removal in a future Connector/ODBC version. (WL ...
https://dev.mysql.com/doc/relnotes/connector-odbc/en/news-9-1-0.html
(Bug #36972449) Fixed a potential Out of Bounds (OOB) issue related to escaping large queries. (Bug #115584, Bug #36841317) When connected to a MySQL 5.7 server, queries using bound parameters would not succeed and emitted a "No data supplied for ...