Search Results
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/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/risky-handling-around-additional-sessions.html
If a disconnect <connection> or KILL <connection_id> or --exec <client program which connects to the server> occurs within a script for mysqltest than the next statements will be executed even if the disconnect or kill is not complete finished. (2) ...This is most probably good for the throughput of usual application but has some annoying consequences for the development of ...
https://dev.mysql.com/doc/internals/en/rnd-next.html
Purpose Reads the next row from a table and returns it to the server. The Field structure for the table is the key to getting data into buf in a manner that will allow the server to understand it. Synopsis virtual int rnd_next ( buf); byte * buf ; ...
https://dev.mysql.com/doc/internals/en/secure-password-authentication.html
The password is calculated by: SHA1( password ) XOR SHA1( "20-bytes random data from server" <concat> SHA1( SHA1( password ) ) ) .
https://dev.mysql.com/doc/internals/en/threads.html
The mysql_install_db script starts a server with an option telling it to start this thread and read commands in from a file. Threads in mysqld can run at four different priorities, defined in mysql_priv.h: #define INTERRUPT_PRIOR 10 #define ...
https://dev.mysql.com/doc/internals/en/x-protocol-xplugin-implementation-of-the-x-protocol.html
Topics in this section: Mysqlx.Sql::StmtExecute Collations The X Plugin implements the X Protocol for the MySQL Server. Mysqlx.Sql::StmtExecute StmtExecute implements several namespaces: sql The SQL interface which expects: .stmt to be a string ...
https://dev.mysql.com/doc/mysqld-version-reference/en/build-options.html
The following table details the CMake configuration options available when building MySQL Server from source. Whether the item is available in the corresponding MySQL Server series. Introduced: The version or versions in which the item was ...
https://dev.mysql.com/doc/mysqld-version-reference/en/built-in-functions.html
The following table shows all built-in functions and operators available in MySQL Server. Whether the item is available in the corresponding MySQL Server release series. Introduced: The version or versions in which the item was introduced.
https://dev.mysql.com/doc/mysqld-version-reference/en/information-schema-tables.html
The following table shows all INFORMATION_SCHEMA tables available in MySQL Server. Whether the item is available in the corresponding MySQL Server series. Introduced: The version or versions in which the item was introduced. Deprecated: The version ...