Search Results
https://dev.mysql.com/doc/c-api/8.4/en/mysql-options4.html
MYSQL_OPT_CONNECT_ATTR_ADD (argument types: char *, char *) This option adds an attribute key-value pair to the current set of connection attributes to pass to the server at connect time. The first and second strings indicate the key and value, ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/myai-installation-clean.html
Note The certificates and keys you provide must satisfy MySQL requirements. The certificate, key, and bundle files specified must be readable by the root user who installs MySQL AI; adjust their file permissions if needed. The certificate, key, and ... Installing MySQL AI requires the following steps: Install the MySQL AI ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-bulk-load-mysql-server.html
It can do the following: Optimize the loading of data sorted by primary key. IN PRIMARY KEY ORDER: Use when the data is already sorted. For a file series, the primary keys in each file must be disjoint and in ascending order from one file to the ...
https://dev.mysql.com/doc/connectors/en/connector-j-usagenotes-troubleshooting.html
3.14.6: Updating a table that contains a primary key that is either FLOAT or compound primary key that uses FLOAT fails to update the table and raises an exception. 3.14.6: Updating a table that contains a primary key that is either FLOAT or ...
https://dev.mysql.com/doc/internals/en/bulk-insert.html
Instead of writing each key value to B-tree (that is, to the key cache, although the bulk insert code doesn't know about the key cache), we store keys in a balanced binary (red-black) tree, in memory. When this tree reaches its memory limit, we ...
https://dev.mysql.com/doc/internals/en/heap-directory.html
All the MySQL table handlers (that is, the handlers that MySQL itself produces) have files with similar names and functions. Thus, this (heap) directory contains a lot of duplication of the myisam directory (for the MyISAM table handler). Such ...
https://dev.mysql.com/doc/internals/en/index-read-idx.html
Purpose Find a row based on a key and return. Synopsis virtual int index_read_idx ( buf, index, key, keypart_map, find_flag); byte * buf ; uint index ; const byte * key ; ulonglong keypart_map ; enum ha_rkey_function find_flag ; Description This is ...
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/optimizer-index-merge-join-type.html
When doing Index Merge, MySQL retrieves rows for each of the keyscans and then runs them through a duplicate elimination procedure. for query: SELECT * FROM t WHERE (goodkey1=c1 OR goodkey1=c2) AND badkey=c3 scan on badkey will be chosen even if ...
https://dev.mysql.com/doc/internals/en/optimizer-joins-access-methods.html
The key routine that performs the search for an optimal QEP is sql/sql_select.cc, find_best(). Bad join choices can cause more damage than bad choices in single-table searches, so MySQL developers have spent proportionally more time making sure ...