Search Results
https://dev.mysql.com/doc/heatwave/en/heatwave-system-variables.html
rapid_auto_vector_index_enabled System Variable rapid_auto_vector_index_enabled Scope Global Dynamic Yes SET_VAR Hint Applies No Type Enumeration Default Value ON Valid Values ON OFF As of MySQL 9.5.0, controls automatic vector index creation for ...
https://dev.mysql.com/doc/heatwave/en/mys-hwgenai-ml-retrieve-schema-metadata.html
This output consists of a concise set of abridged CREATE TABLE statements for the tables that are most relevant to a natural-language statement, ranked in order of relevance. To view a copy of this license, visit ... Retrieves the most relevant ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-increase-dbsystem-storage.html
It is recommended that you create a backup of the DB System before updating the data storage size. Increasing Storage by Backup and Restore Create a backup of the DB System. Create a new DB System from the backup, and define a larger storage in the ... Increasing DB System Storage 3.4.7 Increasing DB System Storage You can increase the DB System storage by updating the data storage size of a DB System, by backup and restore, or by export and ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-add-package.html
add package {--basedir=|-b }path [{--hosts=|-h }host_list] package_name host_list: host[,host[,...]] This command creates a new package, or, if the package named package_name already exists, this command extends the package definition. If --hosts ...The --basedir option (short form: -b) indicates the location of the MySQL NDB Cluster installation directory on the listed hosts, and is ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-using-backup-restore-agents.html
The backup for each agent includes the following contents from the agent repository (mcm_data folder): The rep subfolder The metadata files high_water_mark and repchksum The repository is locked while the backup are in progress, to avoid creating an ... This section explains how to back up configuration data for mcmd agents and how to restore the backed-up agent ...
https://dev.mysql.com/doc/refman/9.7/en/column-indexes.html
For additional information about column indexes, see Section 15.1.18, “CREATE INDEX Statement”. Index Prefixes FULLTEXT Indexes Spatial Indexes Indexes in the MEMORY Storage Engine Index Prefixes With col_name(N) syntax in an index specification ... The most common type of index involves a single column, storing copies of the values from that column in a data structure, allowing fast lookups for the rows with the corresponding column ...
https://dev.mysql.com/doc/refman/9.7/en/ddl-rewriter.html
MySQL 9.7 includes a ddl_rewriter plugin that modifies CREATE TABLE statements received by the server before it parses and executes them. The plugin removes ENCRYPTION, DATA DIRECTORY, and INDEX DIRECTORY clauses, which may be helpful when ...For ...
https://dev.mysql.com/doc/refman/9.7/en/derived-tables.html
The JSON_TABLE() function generates a table and provides another way to create a derived table: SELECT * FROM JSON_TABLE(arg_list) [AS] tbl_name ... For information about lateral derived tables preceded by the LATERAL keyword, see Section 15.2.15.9, ...
https://dev.mysql.com/doc/refman/9.7/en/information-schema-tables-table.html
CREATE_OPTIONS shows the ENCRYPTION clause specified for tables created in file-per-table tablespaces. The encryption clause is not shown for tables created in general tablespaces. When creating a table with strict mode disabled, the storage ...The ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-persistent-stats.html
You can also configure automatic statistics recalculation for individual tables by specifying the STATS_AUTO_RECALC clause when creating or altering a table. To override these system-wide settings and configure optimizer statistics parameters for ...