Search Results
https://dev.mysql.com/doc/internals/en/general-trace-structure.html
A trace follows closely the actual execution path: there is a join-preparation object, a join-optimization object, a join-execution object, for each JOIN. Calls to the range optimizer, cost evaluations, reasons why an access path is chosen over ...
https://dev.mysql.com/doc/internals/en/indexing-overview.html
Adding index support to a storage engine revolves around two tasks: providing information to the optimizer and implementing index-related methods. The information provided to the optimizer helps the optimizer to make better decisions about which ...
https://dev.mysql.com/doc/internals/en/info.html
SHOW also makes use of this data Another note, you will probably want to have the following in your code: if (records < 2) records = 2 The reason is that the server will optimize for cases of only a single record. Usage This example is from the CSV ...Synopsis virtual int info ( flag); uint flag ; Description This is the info ...
https://dev.mysql.com/doc/internals/en/select-special-engines.html
The normal engine can be replaced with such special engines only during the optimization process.
https://dev.mysql.com/doc/internals/en/selectexplain.html
mysql_select creates a JOIN for select if it does not already exist (it might already exist because if it called for subquery JOIN can be created in JOIN::optimize of outer query when it decided to calculate the value of the subquery). For an ...
https://dev.mysql.com/doc/internals/en/sql-directory.html
Programs for handling SQL commands. The "core" of MySQL. These are the .c and .cc files in the sql directory: derror.cc --- read language-dependent message file des_key_file.cc --- load DES keys from plaintext file discover.cc --- Functions for ...
https://dev.mysql.com/doc/internals/en/strings-directory.html
Often the MySQL changes are attempts to optimize the standard libraries. It doesn't seem that anyone tried to optimize for recent Pentium class processors, though. But again, they look like optimizations for old members of the Intel processor family. Many of the files in this subdirectory are equivalent to well-known functions that appear in most C string ...
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-using-clusterj-operations.html
In addition, queries are optimized to detect whether columns of the primary key are specified as part of the query criteria, and if so, a primary key lookup or scan is executed as a strategy to implement the query. As with primary keys, if a query ...To insert a new row into the table, first create a new instance of ...
https://dev.mysql.com/doc/ndbapi/en/ndb-ndb-cluster-connection.html
set_data_node_neighbour() Sets a neighbor node for for optimal transaction coordinator placement set_max_adaptive_send_time() Set timeout to elapse before adaptive send forces the sending of all pending signals. This section provides information ...