Search Results
https://dev.mysql.com/doc/internals/en/mysys-directory.html
There are 125 *.c programs in this directory: array.c --- Dynamic array handling charset.c --- Using dynamic character sets, set default character set, ... For example, the main functions in my_getwd.c are described thus: "int my_getwd _A((string ...
https://dev.mysql.com/doc/internals/en/optimizer-joins-access-methods.html
A combination of a fixed order in which tables are joined and the corresponding table access methods for each table is called query execution plan (QEP). Bad join choices can cause more damage than bad choices in single-table searches, so MySQL ...
https://dev.mysql.com/doc/internals/en/optimizer-partition-selection.html
If a partitioned table is accessed in a series of index lookups (that is, using the ref, eq_ref, or ref_or_null access methods), MySQL checks to see whether it needs to make index lookups in all partitions or that it can limit access to a ...
https://dev.mysql.com/doc/internals/en/prepared-stored-reexecution.html
The present solution introduces a concept of change management for the changes of the parsed tree and is largely a unification of numerous fixes of bugs in reexecution. Features of MySQL 4.1 and 5.0 put a new demand on the execution process: ...
https://dev.mysql.com/doc/internals/en/scripts-directory.html
Linux programmers use it where Windows programmers would use a *.bat (batch filename extension). Can be safely run during any upgrade to get the newest MySQL privilege tables mysql_install_db.sh --- Create privilege tables and func table ...
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/sleep.html
FLUSH TABLE t1; The BIG, BIG problem with 'sleep' is that you need to specify a fixed time. In some cases race conditions can be repeated when all but one thread are blocked (for example waiting for an SQL lock). Then the remaining thread has ...
https://dev.mysql.com/doc/internals/en/strings-directory.html
Many of the files in this subdirectory are equivalent to well-known functions that appear in most C string libraries. On the other hand, some of the files are MySQL additions or improvements. Often the MySQL changes are attempts to optimize the ...
https://dev.mysql.com/doc/internals/en/support-for-savepoints.html
This should be a fixed size, preferably not large as the MySQL server will allocate space to store the savepoint for all storage engines with each named savepoint. First, the implementor should know how many bytes are required to store savepoint ...
https://dev.mysql.com/doc/internals/en/tracing-example.html
The statement's execution is naturally made of "steps": "steps": [ { "join_preparation": { This is a join's preparation "select#": 1, for the first SELECT of the statement (which has only one, here). "rest_of_plan": [ { "database": "test", "table": ...