Search Results
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-config-metric-innodbfulltext-category.html
Enable Diag Print Whether to enable additional full-text search (FTS) diagnostic output. Result Cache Limit The InnoDB FULLTEXT search (FTS) query result cache limit (defined in bytes) per FTS query or per thread. Sort Pll Degree Number of threads ... Lists the InnoDB Fulltext configuration metrics and provides a brief description of ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-run-chat.html
By default, MySQL HeatWave Chat searches for an answer to a query across all ingested documents by automatically discovering available vector stores, and returns the answer along with relevant citations. You can limit the scope of search to specific ... When you run MySQL HeatWave Chat, it automatically loads the default ...
https://dev.mysql.com/doc/refman/8.4/en/create-table.html
This works regardless of whether there is a default database, assuming that the database exists. Indexing only a prefix of column values like this can make the index file much smaller. You can work around this restriction by creating an index on a ...| {FULLTEXT | SPATIAL} [INDEX | KEY] [index_name] (key_part,...) [index_option] ...
https://dev.mysql.com/doc/refman/8.4/en/docker-mysql-getting-started.html
Downloading the server image in a separate step is not strictly necessary; however, performing this step before you create your Docker container ensures your local image is up to date. To download the MySQL Community Edition image from the Oracle ...
https://dev.mysql.com/doc/refman/8.4/en/index-btree-hash.html
LIKE '%string%' and string is longer than three characters, MySQL uses the Turbo Boyer-Moore algorithm to initialize the pattern for the string and then uses this pattern to perform the search more quickly. (This type of index cannot be used to ...A ... Understanding the B-tree and hash data structures can help predict how different queries perform on different storage engines that use these data structures in their indexes, particularly for the MEMORY storage engine that lets you choose B-tree or hash ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-ft-being-deleted-table.html
This value is used when you perform text searches, to skip rows in the INNODB_FT_INDEX_TABLE table before data for deleted rows is physically removed from the FULLTEXT index by an OPTIMIZE TABLE statement. Because the contents of ... The ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-shell-creating-startup-scripts.html
After this, MySQL Shell does not search for startup scripts again, so implementing updates to a startup script requires a restart of MySQL Shell if you have already entered the relevant mode. When MySQL Shell is started in JavaScript or Python ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-shell-utilities-json-import-command.html
This command provides a short form syntax without using option names, and it accepts JSON documents from standard input. If the target is not an existing table, the utility searches for any collection with the specified target name, and imports the ... Note The --import command is deprecated and is subject to removal in a future ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-ai-genai-run-chat.html
By default, GenAI Chat searches for an answer to a query across all ingested documents by automatically discovering available vector stores, and returns the answer along with relevant citations. You can limit the scope of search to specific document ... When you run GenAI Chat, it automatically loads the llama3.2-3b-instruct-v1 ...
https://dev.mysql.com/doc/mysql-secure-deployment-guide/8.0/en/secure-deployment-post-install.html
(This implies the user can read any file in any database directory, because the server can access any of those files.) The FILE privilege also enables the user to create new files in any directory where the MySQL server has write access. This ...