Search Results
https://dev.mysql.com/doc/internals/en/perfect-cleanup.html
Close all connections which you have explicitly created and please ensure that the disconnect is finished = the sessions are no more visible within the processlist. Cleaning up becomes much more comfortable and less error prone if you create your ...
https://dev.mysql.com/doc/internals/en/prepared-stored.html
The original implementation is streamlined for this mode and has a single global connection state THD shared among all operational steps. Let us start with a general description of the MySQL statement processing workflow in order to provide the ...
https://dev.mysql.com/doc/internals/en/query-event.html
Binlog::QUERY_EVENT: The query event is used to send text querys right the binlog. Post-header 4 slave_proxy_id 4 execution time 1 schema length 2 error-code if binlog-version ≥ 4: 2 status-vars length Payload string[$len] status-vars ...
https://dev.mysql.com/doc/internals/en/server-tools-directory.html
Quoting from the README file within this directory: "Instance Manager - manage MySQL instances locally and remotely. File description: mysqlmanager.cc - entry point to the manager, main, options.{h,cc} - handle startup options.
https://dev.mysql.com/doc/internals/en/source-directory-listing.html
Directory — Short Comment bdb — The Berkeley Database table handler BitKeeper — BitKeeper administration (not part of the source distribution) BUILD — Frequently used build scripts client — Client library cmd-line-utils — Command-line ...
https://dev.mysql.com/doc/internals/en/ssl.html
For an unencrypted connection the server starts with its Initial Handshake Packet: 36 00 00 00 0a 35 2e 35 2e 32 2d 6d 32 00 52 00 6....5.5.2-m2.R. The preceding packet is from SSL_connect() which does the SSL greeting and certificate exchange. The ...
https://dev.mysql.com/doc/internals/en/status-flags.html
SERVER_STATUS_LAST_ROW_SENT 0x0080 SERVER_STATUS_DB_DROPPED 0x0100 SERVER_STATUS_NO_BACKSLASH_ESCAPES 0x0200 SERVER_STATUS_METADATA_CHANGED 0x0400 SERVER_QUERY_WAS_SLOW 0x0800 SERVER_PS_OUT_PARAMS 0x1000 SERVER_STATUS_IN_TRANS_READONLY 0x2000 in a ...Protocol::StatusFlags Flag Value Comment SERVER_STATUS_IN_TRANS 0x0001 a transaction is active SERVER_STATUS_AUTOCOMMIT 0x0002 auto-commit is enabled SERVER_MORE_RESULTS_EXISTS 0x0008 SERVER_STATUS_NO_GOOD_INDEX_USED 0x0010 SERVER_STATUS_NO_INDEX_USED 0x0020 SERVER_STATUS_CURSOR_EXISTS 0x0040 Used by Binary Protocol Resultset to signal that COM_STMT_FETCH must be used to fetch the ...
https://dev.mysql.com/doc/internals/en/successful-authentication.html
Note Many authentication methods, including the native mysql password methods, consists of a single challenge--response exchange. In that case no extra packets are exchanged in step 4 and server sends OK_Packet directly after receiving Handshake ...
https://dev.mysql.com/doc/internals/en/tests-directory.html
The files in this directory are test programs that can be used as a base to write a program to simulate problems in MySQL in various scenarios: forks, locks, big records, exporting, truncating, and so on.
https://dev.mysql.com/doc/internals/en/transaction-management.html
In each client connection, MySQL maintains two transactional states: A statement transaction A standard transaction, also called a normal transaction .