Search Results
https://dev.mysql.com/doc/internals/en/perfect-cleanup.html
Cleaning up becomes much more comfortable and less error prone if you create your "own" database and create all tables there. It checks if there are additional objects like user or tables, modifed system table etc. At the end of the test, you need ...
https://dev.mysql.com/doc/internals/en/select-steps.html
Every select is performed in these base steps: JOIN::prepare Initialization and linking JOIN structure to st_select_lex. fix_fields() for all items (after fix_fields(), we know everything about item).
https://dev.mysql.com/doc/internals/en/source-files-related-to-the-binary-log.html
rpl_record.h /rpl_record.cc: Utilities for encoding and decoding table rows into and out of the format used by row events. The mapping is used by the row logging system to identify tables. rpl_utility.h /rpl_utility.cc: Contains auxiliary classes ...
https://dev.mysql.com/doc/internals/en/support-for-non-sequential-reads.html
In addition to table scanning, storage engines can implement methods for non-sequential reading. Two examples of such operations are multi-table UPDATE and SELECT .. (Note: this is not "can" but rather a "must" because certain operations rely on ...
https://dev.mysql.com/doc/internals/en/transactions-current-situation.html
Nowadays a statement transaction is started for each statement that accesses transactional tables or uses the binary log. A failure of a statement that uses nontransactional tables would cause a rollback of the statement transaction, but that's ...
https://dev.mysql.com/doc/internals/en/x-protocol-lifecycle-lifecycle.html
Extensions If the result of CapabilitiesGet contains a extension key from the table below it supports the feature. Topics in this section: Connection Session Stages of Session Setup Authentication Pipelining Max Message Length Extensions The ...
https://dev.mysql.com/doc/internals/en/x-protocol-notices-notices.html
Global Notices Global Notices are sent by the server in case of events happen that are unrelated to the currently active message sequence: server is shutting down node disconnected from group schema or table dropped binlog events Server Shutting ...
https://dev.mysql.com/doc/mysql-installer/en/server-advanced-options.html
Table Names Case You can set the following options during the initial and subsequent configuration the server. Lower Case Sets the lower_case_table_names option value to 1 (default), in which table names are stored in lowercase on disk and ... This ...
https://dev.mysql.com/doc/mysqld-version-reference/en/optvar-changes-8-0.html
The following list details the changes to specific options and variables within MySQL 8.0.
https://dev.mysql.com/doc/ndbapi/en/ch04s03s04s01.html
Table 4.120 com.mysql.clusterj.* Name Description DEFAULT_PROPERTY_CLUSTER_BYTE_BUFFER_POOL_SIZES "256, 10240, 102400, 1048576" DEFAULT_PROPERTY_CLUSTER_CONNECT_AUTO_INCREMENT_BATCH_SIZE 10 DEFAULT_PROPERTY_CLUSTER_CONNECT_AUTO_INCREMENT_START 1 ...