Search Results
https://dev.mysql.com/doc/internals/en/innodb-page-header.html
The PAGE_FREE pointer in the page header points to the first record in the list. The "next" pointer in the record header (specifically, in the record's Extra Bytes) points to the next record in the list. PAGE_DIRECTION and PAGE_N_DIRECTION: It's ...
https://dev.mysql.com/doc/internals/en/man-directory.html
Some user-contributed manual pages These are user-contributed "man" (manual) pages in a special markup format. The format is described in a document with a heading like "man page for man" or "macros to format man pages" which you can find in a ...
https://dev.mysql.com/doc/internals/en/miscellaneous-options.html
For Autotools MySQL build options that have CMake equivalents, the normal mapping from an Autotools option to the CMake option is to convert uppercase, remove leading dashes, replace dashes with underscores, and add a leading -D.
https://dev.mysql.com/doc/internals/en/optimizer-code.html
*/ optimize_cond() opt_sum_query() make_join_statistics() get_quick_record_count() choose_plan() /* Find the best way to access tables */ /* as specified by the user. */ optimize_straight_join() best_access_path() /* Find a (sub-)optimal plan among ... 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/preventing-use-of-optimizer-trace.html
If for some reason, as DBA of a MySQL Server, you wish to prevent all users from seeing traces of their queries, start the server with these options: --maximum-optimizer-trace-max-mem-size=0 --optimizer-trace-max-mem-size=0 This sets the maximum ...
https://dev.mysql.com/doc/internals/en/risky-handling-around-additional-sessions.html
This is most probably good for the throughput of usual application but has some annoying consequences for the development of tests. If a disconnect <connection> or KILL <connection_id> or --exec <client program which connects to the server> occurs ...
https://dev.mysql.com/doc/internals/en/transactions-current-situation.html
The normal transaction is started by the user and is usually completed by a user request as well. Nowadays a statement transaction is started for each statement that accesses transactional tables or uses the binary log. Commits of statement ...
https://dev.mysql.com/doc/internals/en/variation-of-protocol-option.html
We have a lot of tests running very similar and extremely simple SQL just for the creation of a situation to be tested, check of table content, etc. It is usual to run tests with and without the mysql-test-run.pl startup option "--ps-protocol". And ...
https://dev.mysql.com/doc/ndbapi/en/mgm-structures.html
int is_single_user: The node ID of the API or SQL node having exclusive access when the cluster is in single user mode. int is_single_user: The node ID of the API or SQL node having exclusive access when the cluster is in single user mode. This ...
https://dev.mysql.com/doc/ndbapi/en/ndb-errors-handling.html
By default, read operations are run with AO_IgnoreError, and write operations are run with AbortOnError, but this can be overridden by the user. If an error is ignored due to AO_IgnoreError being set on the operation, the execute() method returns a ... Abstract This section describes how NDB API errors can be detected and mapped onto particular ...