Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-disk-data-storage-requirements.html
You can obtain an estimate the amount of space available in data files and undo log files by querying the Information Schema FILES table. Important Starting the cluster with the --initial option does not remove Disk Data files. The following items ...For each row, this is equal to the space required to store the largest possible value for that ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-disk-data.html
Column data and logging metadata are kept in data files and undo log files, conceptualized as tablespaces and log file groups, as described in the next section—see Section 25.6.11.1, “NDB Cluster Disk Data Objects”. For information about these ...Disk Data latency parameters Section 25.6.15.32, “The ndbinfo diskstat Table” Section 25.6.15.33, “The ndbinfo diskstats_1sec Table” Section 25.6.15.50, “The ndbinfo pgman_time_track_stats ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-supported-data-types.html
Columns with unsupported data types must be excluded, and defined as NOT SECONDARY before loading a table. JSON As of MySQL 9.0.0, the JSON data type supports the following functions and operators: Cast-functions and operators, see: Section 5.3.3, ...Numeric data types: BIGINT BOOL DECIMAL DOUBLE FLOAT INT INTEGER MEDIUMINT SMALLINT TINYINT Temporal data types: DATE DATETIME TIME TIMESTAMP YEAR Temporal types are only supported with strict SQL ...
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/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/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/replication-features-load-data.html
If you need to recover from a replication error involving a LOAD DATA INFILE operation logged in statement format, and the replicated event is trusted, you could grant the FILE privilege to the PRIVILEGE_CHECKS_USER account temporarily, removing it ...If you use LOAD DATA with binlog_format=STATEMENT, each replica on which the changes are to be applied creates a temporary file containing the ...
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 ...