Search Results
https://dev.mysql.com/doc/internals/en/custom-engine-source-files.html
The easiest way to implement a new storage engine is to begin by copying and modifying the EXAMPLE storage engine. The files ha_example.cc and ha_example.h can be found in the storage/example directory of the MySQL 5.1 source tree. For instructions ...
https://dev.mysql.com/doc/internals/en/huffman-compression.html
In his article from 1952 Huffman proved that his algorithm uses the least possible number of bits to encode a sequence of messages. The number of bits assigned to each message depends on its probability to appear in the sequence. One could take all ...
https://dev.mysql.com/doc/internals/en/join-buffer-size.html
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 is used only when the join is of type ALL or index (in other words, when no possible keys ...
https://dev.mysql.com/doc/internals/en/generating-browsable-binary-log-information.html
Source files in the sql directory of a MySQL source tree or source distribution contain comments that can be processed with doxygen to generate HTML files that describe classes, files, and so forth. To generate the HTML files and view information ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-oracle-mysql-discovery.html
It is possible to discover MySQL instances automatically, using OMS Auto Discovery. To configure Auto Discovery for Oracle MySQL, do the following: From the Setup menu, select Add Target, Configure Auto Discovery. From the Targets on Hosts table, ...
https://dev.mysql.com/doc/internals/en/guided-tour-majordir-mysys.html
The next major directory is labelled mysys, which stands for MySQL System Library. This is the toolbox directory, for example it has low level routines for file access. The .c files in mysys have procedures and functions that are handy for calling ...
https://dev.mysql.com/doc/internals/en/system-variables-controlling-trace.html
A brief overview from "mysqld --verbose --help": --optimizer-trace=name Controls tracing of the Optimizer: --optimizer-trace-features=name Enables/disables tracing of selected features of the Optimizer: ...
https://dev.mysql.com/doc/internals/en/external-lock.html
Synopsis virtual int external_lock ( thd, lock_type); THD * thd ; int lock_type ; Description This is the external_lock method. The locking methods for mysql section in lock.cc has additional comments on this topic that may be useful to read. If you ...
https://dev.mysql.com/doc/internals/en/optimizer-range-join-type.html
Some conditions can work with indexes, but over a (possibly wide) range of keys. The optimizer will use an index (range search) for column1 LIKE 'x%' but not for column1 LIKE '%x' That is, there is no range search if the first character in the ...
https://dev.mysql.com/doc/internals/en/optimizer-eliminating-dead-code.html
A transformation takes place for conditions that are always true, for example: WHERE 0=0 AND column1='y' In this case, the first condition is removed, leaving WHERE column1='y' See: /sql/sql_select.cc, remove_eq_conds(). A transformation also takes ...