Search Results
https://dev.mysql.com/doc/internals/en/huffman-compression.html
One could take all possible values - say of a table column - as "messages". But if there are too many of them, the code tables could become bigger than the uncompressed table. In his article from 1952 Huffman proved that his algorithm uses the least ...
https://dev.mysql.com/doc/internals/en/implementing-store-lock-method.html
Before adding the lock into the table lock handler mysqld calls store lock with the requested locks. Store lock can modify the lock level, for example change blocking write lock to non-blocking, ignore the lock (if we don't want to use MySQL table ... The [custom-engine.html#custom-engine-api-reference-store_lock store_lock()] method is called before any reading or writing is ...
https://dev.mysql.com/doc/internals/en/indexing-overview.html
The information provided to the optimizer helps the optimizer to make better decisions about which index to use or even to skip using an index and instead perform a table scan. Adding index support to a storage engine revolves around two tasks: ...
https://dev.mysql.com/doc/internals/en/logging-transactions-preliminary-rules.html
(PR-causality) If statement A is executed before statement B, and B is logged in statement format, and B reads tables that A may modifies, then B shall be logged after A. In particular, changes to N-tables shall be written to the binary log when ...
https://dev.mysql.com/doc/internals/en/myisammrg-directory.html
As with other table handlers, you'll find that the *.c files in the myissammrg directory have counterparts in the myisam directory. In fact, this general description of a myisammrg program is almost always true: The myisammrg function checks an ...
https://dev.mysql.com/doc/internals/en/packet-OK_Packet.html
An OK packet is sent from the server to the client to signal successful completion of a command. As of MySQL 5.7.5, OK packes are also used to indicate EOF, and EOF packets are deprecated. Consequently, the server does not send OK packets that ...
https://dev.mysql.com/doc/internals/en/support-for-non-sequential-reads.html
In addition to table scanning, storage engines can implement methods for non-sequential reading. Two examples of such operations are multi-table UPDATE and SELECT .. (Note: this is not "can" but rather a "must" because certain operations rely on ...
https://dev.mysql.com/doc/internals/en/transactions-current-situation.html
Nowadays a statement transaction is started for each statement that accesses transactional tables or uses the binary log. A failure of a statement that uses nontransactional tables would cause a rollback of the statement transaction, but that's ...
https://dev.mysql.com/doc/mysql-installer/en/server-advanced-options.html
Table Names Case You can set the following options during the initial and subsequent configuration the server. Lower Case Sets the lower_case_table_names option value to 1 (default), in which table names are stored in lowercase on disk and ... This ...
https://dev.mysql.com/doc/ndbapi/en/ch04s03s04s01.html
Table 4.120 com.mysql.clusterj.* Name Description DEFAULT_PROPERTY_CLUSTER_BYTE_BUFFER_POOL_SIZES "256, 10240, 102400, 1048576" DEFAULT_PROPERTY_CLUSTER_CONNECT_AUTO_INCREMENT_BATCH_SIZE 10 DEFAULT_PROPERTY_CLUSTER_CONNECT_AUTO_INCREMENT_START 1 ...