Search Results
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-mysqlai-ml-rag-table.html
The specified input table must already exist, must not be empty, and must have a primary key. The input column must not be a part of the primary key and must not have NULL values or empty strings. The new output table has key columns which contains ... The ML_RAG_TABLE routine runs multiple retrieval-augmented generation (RAG) queries in a batch, in ...
https://dev.mysql.com/doc/workbench/en/wb-mysql-connections-methods-ssh.html
It is recommended that an SSH key file is also used. You can convert an existing PuTTY Private Key (ppk) file to OpenSSH format by using the PuTTY Key Generator (PuTTYGen) utility. This connection method enables MySQL Workbench to connect to MySQL ...
https://dev.mysql.com/doc/workbench/en/wb-performance-explain.html
It is fast because the index search directly leads to the page with all the row data REF Green Non-Unique Key Lookup Low-medium -- Low if the number of matching rows is small; higher as the number of rows increases FULLTEXT Yellow Fulltext Index ...
https://dev.mysql.com/doc/workbench/en/wb-tutorial-visual-explain-dbt3.html
The Type changed from ALL to range, possible keys (and used key) changed from NULL to i_o_orderdate, and the number of scanned rows changed from 1.5 million to about 33 thousand. This tutorial describes how to use Explain reports to locate and fix ...
https://dev.mysql.com/doc/internals/en/guided-tour-majordir-myisam.html
Key handling programs on mysql-5.0/myisam: size name comment ---- ---- ------- 4668 mi_rkey.c for random key searches 3646 mi_rnext.c for next-key searches 15440 mi_key.c for managing keys + more mi_*.c programs The final notable group of files in ...We will begin by mentioning that myisam is one of what we call the MySQL storage engine ...
https://dev.mysql.com/doc/internals/en/guided-tour-skeleton.html
When an editor supports ctags (and the list is long, but vi and emacs of course are there), the function definition is one key press away - no guessing involved. Will be included in the TABLE structure */ handler(TABLE *table_arg) : ... And now ...
https://dev.mysql.com/doc/internals/en/index-read.html
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 ha_rkey_function find_flag ; Description This is the index_read method.
https://dev.mysql.com/doc/internals/en/myisam-column-attributes.html
Note that internally this can be 2 even if Field_varchar->field_length < 256 (for example, for a shortened key to a varchar(256)) ... When creating a key for the handler, HA_KEYTYPE_VARTEXT1 and HA_KEYTYPE_BINARY1 are used for a key on a column that ... Next I'll describe the physical attributes of each column in a ...
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/tracing-example.html
"rest_of_plan": [ { "database": "test", "table": "alias2", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "PRIMARY", "records": 1, "cost": 20.2, "chosen": true We choose ref access on the primary key of alias2. } ...The statement's execution is naturally made of "steps": "steps": [ { "join_preparation": { This is a join's preparation "select#": 1, for the first SELECT of the statement (which has only one, ...