Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-table-syntax-sql.html
The following options apply to CREATE TABLE and ALTER TABLE statements. This topic contains the following sections: CREATE TABLE Statement External Table Options with SQL Syntax Column Definitions Table Parameters File Specifications File Format ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-temporary-tablespace.html
Session Temporary Tablespaces Session temporary tablespaces store user-created temporary tables and internal temporary tables created by the optimizer when InnoDB is configured as the storage engine for on-disk internal temporary tables. A maximum ...Session temporary tablespaces are allocated to a session from a pool of temporary tablespaces on the first request to create an on-disk temporary ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-tls.html
In order to obtain signed node certificates, it is necessary first to create a Certification Authority (CA). Only the administrator (DBA) should have access to the private CA signing key with which valid node certificates are created. Hostname ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-backup-restoring.html
The restored DB System uses the same MySQL Administrator user name and password that was in effect when the backup was created. Note: No administrator user name and password are requested, because the restored DB System uses the same administrator ... Restoring a Backup to a New DB System 18.4 Restoring a Backup to a New DB System When you restore a backup, you create a new DB System and restore the backup to ...
https://dev.mysql.com/doc/refman/9.7/en/merge-storage-engine.html
Note The use of MERGE tables entails the following security issue: If a user has access to MyISAM table t, that user can create a MERGE table m that accesses t. When you create a MERGE table, MySQL creates a .MRG file on disk that contains the names ... The MERGE storage engine, also known as the MRG_MyISAM engine, is a collection of identical MyISAM tables that can be used as ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-lakehouse.html
Load the external file into MySQL HeatWave and create an external Lakehouse table. To access the file from Object Storage, you create a pre-authenticated request. See Creating a Pre-Authenticated Request in Object Storage in the MySQL HeatWave on ...
https://dev.mysql.com/doc/mysql-ai/9.7/en/mys-ai-genai-rag.html
The examples in this topic use the vector store table demo_embeddings created in the section Ingesting Files into a Vector Store. OutputTableName: the name of the table where you want to create a new column to store the generated outputs. If the ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-channel-details.html
Inactive: This status is displayed for the following reasons: The Channel is not replicating because the user has disabled it. The target DB System is Inactive, that is, the Channel is created or updated while the DB System is in Inactive state.
https://dev.mysql.com/doc/refman/9.7/en/innodb-compression-internals.html
The patterns of values in your data determine how well it compresses, but typical user data often compresses by 50% or more. Unlike compression performed by an application, or compression features of some other database management systems, InnoDB ...
https://dev.mysql.com/doc/refman/9.7/en/srjs-examples.html
Next, we create a simple JavaScript stored procedure using a CREATE PROCEDURE statement that includes an OUT parameter for passing the current date and time in a human-readable format to a user variable. First we create a table t2 containing three ... This section contains examples illustrating a number of different aspects of using JavaScript programs under various ...