Search Results
https://dev.mysql.com/doc/internals/en/optimizer-tracing-typical-usage.html
# Turn tracing on (it's off by default): SET optimizer_trace="enabled=on"; SELECT ...; # your query here SELECT * FROM INFORMATION_SCHEMA.OPTIMIZER_TRACE; # possibly more queries... # When done with tracing, disable it: SET ...
https://dev.mysql.com/doc/internals/en/optimizer-tracing.html
In MySQL 5.6, a new tracing capability was added to the MySQL optimizer. The interface is provided by a set of optimizer_trace_xxx system variables and the INFORMATION_SCHEMA.OPTIMIZER_TRACE table, but is subject to change.
https://dev.mysql.com/doc/internals/en/os-specific-commands.html
The exec and system commands enable tests to execute external commands. However, many of such commands are available only on certain platforms. (For example, rm is Unix-specific and not available on Windows.) Please avoid these commands if possible. Have a look at the mysqltest manual and the t/mysqltest.test test ...
https://dev.mysql.com/doc/internals/en/out-parameter-set.html
Starting with MySQL 5.5.3, prepared statements can bind OUT parameters of stored procedures. They are returned as an extra resultset in the multi-resultset response. The client announces it can handle OUT parameters by settting the ...
https://dev.mysql.com/doc/internals/en/overview.html
The MySQL protocol is used between MySQL Clients and a MySQL Server.
https://dev.mysql.com/doc/internals/en/packager-friendly-build-options.html
MySQL source distribution contains sources for zlib (compression library), yaSSL (ssl library), libedit, and (in MySQL 5.5 only) readline. MySQL can be compiled using either libraries available on the system or, to minimize external dependencies, ...
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. At the end of the test, you need to drop just this database. Do not forget to remove all users you created and all ...
https://dev.mysql.com/doc/internals/en/plugin-services-components.html
On the plugin side of the services interface, the relevant information is provided in a set of header files. A plugin accesses this information by including the plugin.h file (which plugins must include anyway): #include <mysql/plugin.h> plugin.h ...
https://dev.mysql.com/doc/internals/en/pstack-directory.html
This is a set of publicly-available debugging aids which all do pretty well the same thing: display the contents of the stack, along with symbolic information, for a running process. There are versions for various object file formats (such as ELF ...
https://dev.mysql.com/doc/internals/en/public-key-retrieval.html
If the client doesn't have the public key it can ask for it by: sending 0x01 as auth response in the Protocol::HandshakeResponse41 server will send a Protocol::AuthMoreData with the keyfile client sends the encrypted password .