Search Results
https://dev.mysql.com/doc/internals/en/guided-tour-osdir.html
We're now getting into the directories which aren't “major.” Starting with: dbug pstack regex strings zlib Now it's time to reveal a startling fact, which is we didn't write all of the source code in all of the source code directories all by ...
https://dev.mysql.com/doc/internals/en/implementing-savepoint-set-method.html
When savepoint_set() is called, the storage engine needs to store savepoint information into sv so that the server can later roll back the transaction to the savepoint or release the savepoint resources. The savepoint_set() method is called ...
https://dev.mysql.com/doc/internals/en/join-buffer-size.html
(In other words, we store the same row combination several times into different buffers.) . Basic information about the join buffer cache: The size of each join buffer is determined by the value of the join_buffer_size system variable. This buffer ...
https://dev.mysql.com/doc/internals/en/libmysql-directory.html
The libmysql files are split into three directories: libmysql (this one), libmysql_r (the next one), and libmysqld (the next one after that). The files here are for producing MySQL as a library (for example, a Windows DLL). The idea is that, instead ...
https://dev.mysql.com/doc/internals/en/make-test-protocols-more-understandable.html
Please have the test write comments into the protocol if this makes the surrounding protocol content much more understandable. This is especially true for tests that do the following: Suppress the printing of SQL statements and result sets Work ...
https://dev.mysql.com/doc/internals/en/myisampack.html
After that it tries to combine byte value compression trees of different columns into one or more code trees. When starting to analyze the existing uncompressed data, it collects distinct column values up to a limit of 8KB. If there are more, it ...
https://dev.mysql.com/doc/internals/en/mysql-packet.html
If a MySQL client or server wants to send data, it: Splits the data into packets of size (224−1) bytes Prepends to each chunk a packet header Protocol::Packet Data between client and server is exchanged in packets of max 16MByte size. The number ...
https://dev.mysql.com/doc/internals/en/optimizer-constants-constant-tables.html
A MySQL constant is something more than a mere literal in the query. unique_not_null_column INT NOT NULL UNIQUE then this expression FROM Table1 ... These rules mean that a constant table has at most one row value. MySQL will evaluate a constant ...
https://dev.mysql.com/doc/internals/en/optimizer-definitions.html
A transformation occurs when one query is changed into another query which delivers the same result. This description uses a narrow definition: The optimizer is the set of routines which decide what execution path the DBMS should take for queries.
https://dev.mysql.com/doc/internals/en/optimizer-joins-access-methods.html
Bad join choices can cause more damage than bad choices in single-table searches, so MySQL developers have spent proportionally more time making sure that the tables in a query are joined in an optimal order and that optimal access methods (often ...