Search Results
https://dev.mysql.com/doc/internals/en/optimizer-joins-access-methods.html
Bad join choices can cause more damage than bad choices in single-table searches, so MySQL developers have spent proportionally more time making sure that the tables in a query are joined in an optimal order and that optimal access methods (often ...
https://dev.mysql.com/doc/internals/en/preface.html
We make no guarantee that it is fully up to date. We do hope it illustrates how MySQL programmers work, and how MySQL Server works as a result. License Restrictions This software and related documentation are provided under a license agreement ...
https://dev.mysql.com/doc/internals/en/select-structure.html
There are two structures that describe selects: st_select_lex (SELECT_LEX) for representing SELECT itself st_select_lex_unit (SELECT_LEX_UNIT) for grouping several selects in a bunch The latter item represents UNION operation (the absence of UNION ...In the future, this structure will be used for EXCEPT and INTERSECT as ...
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/storage-engine-options.html
The --with-plugins configure option accepts two constructs that have no direct equivalent in CMake: --with-plugins accepts a comma-separated list of engine names --with-plugins accepts a “group name” value that is shorthand for a set of engines ... Storage engines are plugins, so the options that control plugin building specify which storage engines to ...
https://dev.mysql.com/doc/internals/en/transactions-notes-on-ddl-and-normal-transaction.html
And finally there is a group of DDL statements such as RENAME/DROP TABLE, which don't start new transactions and don't commit. DDL statements and operations with nontransactional engines do not "register" in thd->transaction lists, and thus do not ...
https://dev.mysql.com/doc/internals/en/transformations-row-in.html
A subquery with HAVING, SUM() function, or GROUP BY will transformed in the following way: ROW(l1, l2, ... To rewrite a row IN subquery, the method used is Item_in_subselect::row_value_transformer. It works in almost the same way as the scalar ...
https://dev.mysql.com/doc/internals/en/user-level-locks.html
Depending on their appearance in the select list, the where clause, the group by clause, etc, of select, update or other statements, these statements can be blocked at different code points. User-level locks are controlled with the SQL functions ...
https://dev.mysql.com/doc/mysql-installer/en/mysql-installer-catalog-dashboard.html
When the Program Shortcut check box is selected, the product appears in the Start menu under the MySQL group. This section describes the MySQL Installer product catalog, the dashboard, and other actions related to product selection and upgrades.
https://dev.mysql.com/doc/mysql-installer/en/mysql-installer-setup.html
The initial setup adds a link to the Start menu under the MySQL folder group. Choosing a Setup Type Path Conflicts Check Requirements MySQL Installer Configuration Files When you download MySQL Installer for the first time, a setup wizard guides ...