Search Results
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 ...
https://dev.mysql.com/doc/internals/en/open.html
Usage This example is from the CSV storage engine: int ha_tina::open(const char *name, int mode, uint test_if_locked) { DBUG_ENTER("ha_tina::open"); if (!(share= get_share(name, table))) DBUG_RETURN(1); thr_lock_data_init(&share->lock,&lock,NULL); ...Synopsis virtual int open ( name, mode, test_if_locked); const char * name ; int mode ; uint test_if_locked ; Description This is the open ...
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 ...