Search Results
https://dev.mysql.com/doc/internals/en/binlog-row-image.html
Otherwise, if there exists a UK where all columns have the NOT NULL attribute, then that is the PKE (if there are more than one such UKs, then one is chosen arbitrarily). Status of this subsection: finished, not reviewed, not fully implemented ...
https://dev.mysql.com/doc/internals/en/com-query-response.html
NULL is sent as 0xfb everything else is converted into a string and is sent as Protocol::LengthEncodedString. Image description If it is not a valid Protocol::LengthEncodedInteger it is either a ERR_Packet or a Protocol::LOCAL_INFILE_Request. Image ...
https://dev.mysql.com/doc/internals/en/creating-tables.html
Once a handler is instanced, the first operation that will likely be required is the creation of a table. Your storage engine must implement the [custom-engine.html#custom-engine-api-reference-create create()] virtual method: virtual int ...
https://dev.mysql.com/doc/internals/en/full-text-search.html
MySQL uses Ranking with Vector Spaces for ordinary full-text queries. Rank, also known as relevance rank, also known as relevance measure, is a number that tells us how good a match is. Vector Space, which MySQL sometimes calls "natural language", ...
https://dev.mysql.com/doc/internals/en/getting-index-information.html
It is preferable for storage engines that support indexing to read the index information provided during a CREATE TABLE operation and store it for future use. The reasoning behind this is that the index information is most readily available during ...
https://dev.mysql.com/doc/internals/en/implementing-index-read-method.html
If the *key parameter is null, the storage engine should read the first key in the index. The [custom-engine.html#custom-engine-api-reference-index_read index_read()] method is used to retrieve a row based on a key: int ha_foo::index_read(byte * ...
https://dev.mysql.com/doc/internals/en/index-read.html
If the key value is null, begin at the first key of the index. Purpose Find a row based on a key and return. Synopsis virtual int index_read ( buf, key, keypart_map, find_flag); byte * buf ; const byte * key ; ulonglong keypart_map ; enum ...
https://dev.mysql.com/doc/internals/en/integer.html
Depending on the context, the first byte may also have other meanings: If it is 0xfb, it is represents a NULL in a ProtocolText::ResultsetRow. The MySQL Protocol has a set of possible encodings for integers: Fixed-length integers Length-encoded ...
https://dev.mysql.com/doc/internals/en/mismatch-of-focus-of-test-and-code-sequence.html
CREATE TABLE t1 ( id INT NOT NULL AUTO_INCREMENT, my_column VARCHAR(30), name LONGTEXT, PRIMARY KEY (id)); INSERT INTO t1(my_column,name) VALUES('2','two'); INSERT INTO t1(my_column,name) VALUES('1','one'); INSERT INTO t1(my_column,name) ...
https://dev.mysql.com/doc/internals/en/myisampack-tricks.html
These cope with leading and trailing spaces or zeros or with all blank or NULL fields. As already mentioned, myisampack uses some tricks to decrease the amount of data to be encoded. They do not materialize in the compressed data files other than ...