Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-export-query-results-csv-json.html
You can use one of the following formats: https://namespace_name.objectstorage.region_name.oci.customer-oci.com/p/PAR_token/n/namespace_name/b/bucket_name/o/object_path ... This topic shows the different ways to export query results as a CSV file ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-metric-innodb-logactivity-category.html
Pages Flushed Lsn The redo log sequence number within InnoDB, up to which the buffer pool has been flushed to the data files. Table 6.14 InnoDB Log Activity Metrics NameDescriptionCheckpoint File The low order 32bit value for the redo log sequence ... Lists the InnoDB Log Activity metrics and provides a brief description of ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-export-query-results-csv-non-json.html
You can create the following types of URIs: OCIFS Syntax: oci://bucket_name@namespace_name/object_path Example: oci://bucket_1@tenant_1/data_files/ PAR URI Syntax. You can use one of the following formats: ... This topic shows the different ways to ...INTO OUTFILE {URL | URI} 'uri' [FORMAT csv] [CHARACTER SET 'charset_name'] [HEADER {ON | OFF}] [{FIELDS | COLUMNS} [NULL AS 'null_char'] [TERMINATED BY 'string'] [[OPTIONALLY] ENCLOSED BY 'char'] [ESCAPED BY 'char'] ...Syntax: ...
https://dev.mysql.com/doc/refman/8.4/en/replication-howto.html
When you are using MyISAM, you must stop processing statements on the source to obtain a read-lock, then obtain its current binary log coordinates and dump its data, before permitting the source to continue executing statements. If you are using ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-limitations-parquet.html
Consider the following limitations: To load Parquet files with the VECTOR data type (from Parquet strings or from Parquet (numeric) Lists), you must load the table manually with is_strict_mode set to false. Lakehouse does not support the following ... MySQL HeatWave Lakehouse has the following limitations for Parquet ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/meb-encrypted-innodb.html
The following is a typical command for restoring a single-file backup containing encrypted InnoDB tablespaces: $ mysqlbackup --defaults-file=/usr/local/mysql/my.cnf --backup-image=/home/admin/backups/my.mbi \ --backup-dir=/home/admin/restore-tmp ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-summarize-docs.html
Generate Summary for a Single File Perform the following steps: Copy the text segment of the file from the vector store table to the @document variable: mysql> SELECT segment INTO @document FROM DBName.VectorStoreTableName WHERE document_id=0; ...
https://dev.mysql.com/doc/refman/8.4/en/creating-ssl-files-using-openssl.html
Important Whatever method you use to generate the certificate and key files, the Common Name value used for the server and client certificates/keys must each differ from the Common Name value used for the CA certificate. A typical error in this case ... This section describes how to use the openssl command to set up SSL certificate and key files for use by MySQL servers and ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-export-query-results-parquet-json.html
You can use one of the following formats: https://namespace_name.objectstorage.region_name.oci.customer-oci.com/p/PAR_token/n/namespace_name/b/bucket_name/o/object_path ... This topic shows the different ways to export query results to Parquet files. The URI must be a prefix URI and end in an unencoded / ...INTO OUTFILE WITH PARAMETERS 'file_URI_JSON "file": begin-array ("uri": "OCIFS_URI") | ("uri": "PAR_URI") | ("uri": "NATIVE_URI"), [, ...end-object ] ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-read-only-instance.html
To enable read-only mode for an entire MySQL instance, specify the following configuration options at server startup: --innodb-read-only=1 If the instance is on read-only media such as a DVD or CD, or the /var directory is not writeable by all: ...