Search Results
https://dev.mysql.com/doc/internals/en/myisampack-tricks.html
As already mentioned, myisampack uses some tricks to decrease the amount of data to be encoded. These cope with leading and trailing spaces or zeros or with all blank or NULL fields. They do not materialize in the compressed data files other than ...
https://dev.mysql.com/doc/internals/en/optimizer-partition-pruning.html
What's important for the current discussion is that we can walk over it and collect partitioning and subpartitioning intervals. Partitions that did not get into this set (that is, those that were pruned away) will not be accessed at all: this is how ...
https://dev.mysql.com/doc/internals/en/optimizer-primary-optimizations.html
This section discusses the most important optimizations performed by the server.
https://dev.mysql.com/doc/internals/en/select-select-result.html
This class has a very important role in SELECT performance with select_result class and classes inherited from it (usually called with a select_ prefix). The key methods in this class are the following: send_fields sends given item list headers ...
https://dev.mysql.com/doc/internals/en/sql-directory.html
Programs for handling SQL commands. The "core" of MySQL. These are the .c and .cc files in the sql directory: derror.cc --- read language-dependent message file des_key_file.cc --- load DES keys from plaintext file discover.cc --- Functions for ...
https://dev.mysql.com/doc/internals/en/store-lock.html
If TL_UNLOCK is set If we are not doing a LOCK TABLE or DISCARD/IMPORT TABLESPACE, then allow multiple writers */ if ((lock_type >= TL_WRITE_CONCURRENT_INSERT && lock_type <= TL_WRITE) && !thd->in_lock_tables && !thd->tablespace_op) lock_type = ...
https://dev.mysql.com/doc/internals/en/synchronization-pattern.html
A bit off-topic: At some places, the loop is taken around the whole synchronization pattern: while (!thd->killed && !end_of_wait_condition) { pthread_mutex_lock(&mutex); thd->enter_cond(&condition_variable, &mutex, new_message); if (!thd->killed [&& ...This is done to allow the thread to be interrupted (killed) from its ...
https://dev.mysql.com/doc/internals/en/test-faults.html
Status of this section: up to date 2010-09-08 The assessment of the replication code in the presence of faults is extremely important to increase reliability. In particular, one needs to know if servers will either correctly recover or print out ...
https://dev.mysql.com/doc/internals/en/transactions-data-layout.html
The list of registered engines has a few important properties: No engine is registered in the list twice. These members correspond to the statement and normal transactions respectively: thd->transaction.stmt contains a list of engines that are ...
https://dev.mysql.com/doc/internals/en/transactions-roles-responsibilities.html
Important: Unless this invariant is preserved, the server will not know that a transaction in a given engine is read-write and will not involve the two-phase commit protocol! The end of a statement causes invocation of the ... The server has only ...