Search Results
https://dev.mysql.com/doc/refman/9.7/en/mysqldump.html
The mysqldump client utility performs logical backups, producing a set of SQL statements that can be executed to reproduce the original database object definitions and table data. To work around this issue, use the --result-file option, which ...It ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-programs-ndb-restore.html
Options that can be used with ndb_restore are shown in the following table. --allow-pk-changes Command-Line Format --allow-pk-changes[=0|1] Type Integer Default Value 0 Minimum Value 0 Maximum Value 1 When this option is set to 1, ndb_restore allows ... The NDB Cluster restoration program is implemented as a separate command-line utility ndb_restore, which can normally be found in the MySQL bin ...
https://dev.mysql.com/doc/refman/9.7/en/mysqlcheck.html
The mysqlcheck client performs table maintenance: It checks, repairs, optimizes, or analyzes tables. Each table is locked and therefore unavailable to other sessions while it is being processed, although for check operations, the table is locked ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-online-operations.html
MySQL NDB Cluster supports online table schema changes using ALTER TABLE ... For ALGORITHM=COPY, the mysqld NDB Cluster handler performs the following actions: Tells the data nodes to create an empty copy of the table, and to make the required ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-programs-ndb-desc.html
ndb_desc provides a detailed description of one or more NDB tables. The Version column in the output contains the table's schema object version. Three of the table properties that can be set using NDB_TABLE comments embedded in CREATE TABLE and ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-loading-data-uri.html
As of MySQL 9.3.1, and only on MySQL HeatWave on OCI, you can use uniform resource identifiers (URI) to specify files for loading data when creating external tables manually. Review the following examples for different ways to create external ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-ml-predict-table.html
ML_PREDICT_TABLE generates predictions for an entire table of unlabeled data and saves the results to an output table. ML_PREDICT_TABLE Overview ML_PREDICT_TABLE Syntax Required ML_PREDICT_TABLE Parameters ML_PREDICT_TABLE Options Options for ...As ...
https://dev.mysql.com/doc/refman/9.7/en/explain-output.html
EXPLAIN returns a row of information for each table used in the SELECT statement. It lists the tables in the output in the order that MySQL would read them while processing the statement. This means that MySQL reads a row from the first table, then ... The EXPLAIN statement provides information about how MySQL executes ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-ndbinfo-memory-per-fragment.html
memory_per_fragment Table: Notes memory_per_fragment Table: Examples The memory_per_fragment table provides information about the usage of memory by individual fragments. See the Notes later in this section to see how you can use this to find out ...This is true as long as all data nodes are running and connected to the cluster; for a data node that is missing, there are no rows for the fragment replicas that it ...
https://dev.mysql.com/doc/refman/9.7/en/optimizer-hints.html
For example, you can enable an optimization for one table in a statement and disable the optimization for a different table. References to table and index names follow the usual identifier case-sensitivity rules (see Section 11.2.3, “Identifier ...