Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-overview.html
Using MySQL HeatWave GenAI, you can perform natural-language searches in a single step using either in-database or external large language models (LLMs). Note This chapter assumes that you are familiar with MySQL HeatWave DB Systems. You can use the ... MySQL HeatWave GenAI is a feature of MySQL HeatWave that lets you communicate with unstructured data in MySQL HeatWave using natural-language ...
https://dev.mysql.com/doc/refman/8.4/en/column-indexes.html
Indexing only a prefix of column values in this way can make the index file much smaller. Take this into account when specifying a prefix length for a nonbinary string column that uses a multibyte character set. If a search term exceeds the index ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-introduction.html
MySQL uses the default collation for this character set (utf8mb3_general_ci) for all searches, sorts, comparisons, and other string operations on such columns. Other terms that are sometimes used for this information are data dictionary and system ... INFORMATION_SCHEMA provides access to database metadata, information about the MySQL server such as the name of a database or table, the data type of a column, or access ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-fulltext-index.html
To support proximity search, position information for each word is also stored, as a byte offset. The number of threads that perform this work is configurable using the innodb_ft_sort_pll_degree variable. The index defined on the opening_lines table ... Full-text indexes are created on text-based columns (CHAR, VARCHAR, or TEXT columns) to speed up queries and DML operations on data contained within those ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-locking.html
In this case, gap locking is disabled for searches and index scans and is used only for foreign-key constraint checking and duplicate-key checking. In this case, InnoDB uses next-key locks for searches and index scans, which prevents phantom rows ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-transaction-isolation-levels.html
This means that if you issue several plain (nonlocking) SELECT statements within the same transaction, these SELECT statements are consistent also with respect to each other. For locking reads (SELECT with FOR UPDATE or FOR SHARE), UPDATE, and ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-using-TLS-connections-clusters.html
This section describes a few scenarios for using MySQL Cluster Manager to configure or manage TLS connections in an NDB Cluster. MySQL Cluster Manager 8.4 supports TLS Link Encryption for NDB Cluster, which is available for NDB Cluster 8.3.0 and ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/plugin-types.html
For a description of this architecture, see Overview of MySQL Storage Engine Architecture. Full-Text Parser Plugins MySQL has a built-in parser that it uses by default for full-text operations (parsing text to be indexed, or parsing a query string ... The plugin API enables creation of plugins that implement several capabilities: Loadable functions (UDFs) Storage engines Full-text parsers Daemons INFORMATION_SCHEMA tables Semisynchronous replication Auditing Authentication Password validation and strength checking Protocol tracing Query rewriting Secure keyring storage and retrieval The following sections provide an overview of these plugin ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-ai-genai-overview.html
Using GenAI, you can perform natural-language searches in a single step using either in-database or external large language models (LLMs). You can use the capabilities of the LLM to search data as well as generate or summarize content. However, as ... The GenAI feature of MySQL AI lets you communicate with unstructured data using natural-language ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-unload-tables.html
Before You Begin Load structured data using Lakehouse Auto Parallel Load or manually. To unload a table manually, specify the SECONDARY_UNLOAD clause in an ALTER TABLE statement: mysql> ALTER TABLE tbl_name SECONDARY_UNLOAD; The following example ...