Search Results
https://dev.mysql.com/doc/refman/8.4/en/bnl-bka-optimization.html
In MySQL, a Batched Key Access (BKA) Join algorithm is available that uses both index access to the joined table and a join buffer. Benefits of BKA include improved join performance due to more efficient table scanning. Moreover, a join buffer can ...The BKA algorithm supports inner join, outer join, and semijoin operations, including nested outer ...
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin-monitoring.html
You can monitor the status and progress of a cloning operation on the recipient MySQL server instance using the clone_status and clone_progress Performance Schema tables. Note The clone_status and clone_progress Performance Schema tables can be used ...To monitor a cloning operation on the donor MySQL server instance, use the clone stage events, as described in Monitoring Cloning Operations Using Performance Schema Stage ...
https://dev.mysql.com/doc/refman/8.4/en/data-type-defaults.html
Examples: CREATE TABLE t1 ( i INT DEFAULT -1, c VARCHAR(10) DEFAULT '', price DOUBLE(16,2) DEFAULT 0.00 ); SERIAL DEFAULT VALUE is a special case. An expression default value for one column can refer to other table columns, with the exception that ... Data type specifications can have explicit or implicit default ...
https://dev.mysql.com/doc/refman/8.4/en/extensions-to-ansi.html
Be warned that if you use them, your code is most likely not portable to other SQL servers. For example, MySQL Server recognizes the STRAIGHT_JOIN keyword in the following statement, but other servers should not: SELECT /*! STRAIGHT_JOIN */ col1 ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-locking-reads.html
However, FOR SHARE supports OF table_name, NOWAIT, and SKIP LOCKED options. FOR SHARE statements do not acquire read locks on MySQL grant tables. FOR UPDATE requires the SELECT privilege and at least one of the DELETE, LOCK TABLES, or UPDATE ... If ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-management-hash-key.html
Tables which are partitioned by hash or by key are very similar to one another with regard to making changes in a partitioning setup, and both differ in a number of ways from tables which have been partitioned by range or list. For that reason, ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-genai-generate-embeddings.html
You can pass the text string in the routine manually or use data from tables in your database. To embed multiple rows of text stored in a table in a single run, you can even run a batch query. Using this method, you can create vector embedding ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-mysqlai-chat.html
If set, the routine searches for vector store tables in this schema. This parameter cannot be used in combination with the tables parameter. vector_store_columns: optional parameter which specifies column names for finding relevant vector and ...
https://dev.mysql.com/doc/ndbapi/en/ndb-start-mysql-data-types.html
This section provides information about the way in which MySQL data types are represented in NDBCLUSTER table columns and how these values can be accessed in NDB API applications. make_ndb_varchar(myVal, "NDB is way cool!!"); ...The MySQL TINYINT, ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-agent-rights.html
MySQL Enterprise Monitor Agent requires a user configured within each MySQL instance that is being monitored with suitable privileges to collect information about the server, including variable names, replication, and storage engine status ...The ...