Search Results
https://dev.mysql.com/doc/internals/en/interface-to-third-party-tools.html
For example, the AC_INIT line for MySQL 5.5.7-rc looked like this: AC_INIT([MySQL Server], [5.5.7-rc], [], [mysql]) Such tools now can read the VERSION file. Previously, third-party tools that need to determine the MySQL version from the MySQL ...
https://dev.mysql.com/doc/internals/en/logging-transactions-definitions.html
(D-N-write) A statement makes an N-write if it makes any type of change to the server state that will not be changed by a ROLLBACK. To reason about logging different table types, we make some preliminary definitions. (D-T-table) A table that has a ...
https://dev.mysql.com/doc/internals/en/multi-statement.html
A multi-statement is permitting COM_QUERY to send more than one query to the server, separated by ';' characters. The client must announce that it wants multi-statements by either setting the CLIENT_MULTI_STATEMENTS capability or by using ...
https://dev.mysql.com/doc/internals/en/myisam-files.html
If it isn't and the server was started with the --myisam-recover option, check the table and try to recover it if it's crashed. Some notes about MyISAM file handling: If a table is never updated, MySQL will never touch the table files, so it would ...
https://dev.mysql.com/doc/internals/en/mysql-specific-cmake-macros.html
RECOMPILE_FOR_EMBEDDED Must be recompiled with the -DEMBEDDED_SERVER preprocessor flag for use with the embedded server. Few plugins need this, typically mandatory storage engines that depend on internal structures and on the EMBEDDED_SERVER flag.
https://dev.mysql.com/doc/internals/en/open.html
The server opens all tables by calling ha_open() which then calls the handler specific open(). Synopsis virtual int open ( name, mode, test_if_locked); const char * name ; int mode ; uint test_if_locked ; Description This is the open method. For ...
https://dev.mysql.com/doc/internals/en/opening-a-table.html
Before any read or write operations are performed on a table, the MySQL server will call the [custom-engine.html#custom-engine-api-reference-open handler::open()] method to open the table data and index files (if they exist). int open(const char ...
https://dev.mysql.com/doc/internals/en/optimizer-code-concepts.html
This section discusses key optimizer concepts, terminology, and how these are reflected in the MySQL server source code.
https://dev.mysql.com/doc/internals/en/optimizer-code.html
This diagram shows the structure of the function handle_select() in /sql/sql_select.cc (the server code that handles a query): handle_select() mysql_select() JOIN::prepare() setup_fields() JOIN::optimize() /* optimizer is from here ... */ ...
https://dev.mysql.com/doc/internals/en/optimizer-early-nulls-filtering.html
This feature is implemented in these places in the server code: The ref analyzer (contained in such functions as update_ref_and_keys()) detects and marks equalities like that shown above by setting KEY_FIELD::null_rejecting=TRUE. Suppose we have a ...