Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-data-compression.html
More data per node reduces costs by minimizing the size of the MySQL HeatWave Cluster required to store the data. If data storage size is not a concern, disable data compression by setting the rapid_compression session variable to OFF before loading ... MySQL HeatWave compresses data as it is loaded, which permits MySQL HeatWave nodes to store more ...
https://dev.mysql.com/doc/refman/8.4/en/gis-data-formats.html
Two standard spatial data formats are used to represent geometry objects in queries: Well-Known Text (WKT) format Well-Known Binary (WKB) format Internally, MySQL stores geometry values in a format that is not identical to either WKT or WKB format.
https://dev.mysql.com/doc/refman/8.4/en/data-dictionary-transactional-storage.html
The mysql.ibd tablespace file must reside in the MySQL data directory and its name cannot be modified or used by another tablespace. The data dictionary schema stores dictionary data in transactional (InnoDB) tables. Data dictionary tables are ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-move-data.html
Usage The program is invoked with the names of the source and target tables; either or both of these may be qualified optionally with the database name. ndb_move_data options source target Options that can be used with ndb_move_data are shown in the ...--abort-on-error Command-Line Format --abort-on-error Dump core on permanent error (debug ...--character-sets-dir=name Command-Line ...
https://dev.mysql.com/doc/refman/8.4/en/data-type-defaults.html
An expression default value for one column can refer to other table columns, with the exception that references to generated columns or columns with expression default values must be to columns that occur earlier in the table definition. If binary ... Data type specifications can have explicit or implicit default ...Examples: CREATE TABLE t1 ( i INT DEFAULT -1, c VARCHAR(10) DEFAULT '', price ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-graphs-time-series-data-aggregation.html
When you upgrade to MySQL Enterprise Monitor 3.4, all existing timeseries data is aggregated when the upgraded MySQL Enterprise Service Manager first starts. Figure 30.1 Optimizing Graph Data Status Note While the timeseries data is being aggregated ...A progress bar is displayed on the user interface, adjacent to the system status bar, indicating the completeness of the aggregation ...
https://dev.mysql.com/doc/heatwave/en/import-data.html
This topic describes how to import data into the DB System. You can export data to Object Storage and also import it from there. For MySQL HeatWave on OCI, see Importing and Exporting Databases in the MySQL HeatWave on OCI Service Guide. For MySQL ...Import Data Use MySQL Shell Shell for importing data into a DB ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-importing-data-sample-data.html
Use the Import sample data feature in MySQL HeatWave Console to import the sample database into a DB System in any region by just a few clicks. You have to select a size for your TPCH sample database—you are suggested to choose a value that ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-exporting-data.html
Exporting Data 7.1 Exporting Data Use the dump utility of MySQL Shell to export a logical dump of the data from a MySQL instance. Connect to the MySQL instance containing the data you want to dump using MySQL Shell. Use either of the following dump ...You can dump all schemas in the instance, a selected schema, or selected tables and ...About MySQL Shell MySQL Server Compatibility MySQL HeatWave on AWS has ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-data-import-feature.html
Data Import Feature 7.2.1 Data Import Feature Use the data import feature in MySQL HeatWave Console to import data in a variety of formats such as MySQL dump files and text files from an Amazon S3 bucket to a DB System in MySQL HeatWave on AWS in ...Importing Sample Database Importing Data Using the Data Import Feature Viewing Data Import Details Parent topic: Importing Data ...