Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-auto-parallel-load.html
| | Sufficient HeatWave cluster memory available to load all tables. If Auto Parallel Load fails with an error, inspect the errors with a query to the heatwave_autopilot_report table. mysql> SELECT log FROM sys.heatwave_autopilot_report WHERE ...
https://dev.mysql.com/doc/ndbapi/en/ndb-ndbtransaction.html
Types NdbTransaction defines 2 public types as shown in the following table: Table 2.67 NdbTransaction class types and descriptions Name Description CommitStatusType() Describes the transaction's commit status ExecType() Determines whether the ...A ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-ml-train.html
table_name: The name of the table that contains the labeled training dataset. The table name must be valid and fully qualified, so it must include the database name, database_name.table_name. The table cannot exceed 10 GB, 100 million rows, or 1017 ... Run the ML_TRAIN routine on a training dataset to produce a trained machine learning ...
https://dev.mysql.com/doc/refman/8.4/en/information-functions.html
For example, BENCHMARK(10, (SELECT * FROM t)) fails if the table t has more than one column or more than one row. The former involves the parser, optimizer, table locking, and runtime evaluation N times each. mysql> SELECT COERCIBILITY('abc' COLLATE ...It may be used to time how quickly MySQL processes the ...
https://dev.mysql.com/doc/ndbapi/en/ndb-error-codes-application-error.html
Having a table without primary key uses an autoincremented hidden key, i.e. The following list enumerates all NDB errors of type AE (Application error). NDB error code 5002 MySQL error DMEC Error message The process has wrong type. NDB error code ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-overview.html
The SQL language itself is intended to work independently of any data structures or media underlying the schemas, tables, rows, or columns with which it works. Partitioning takes this notion a step further, by enabling you to distribute portions of ... This section provides a conceptual overview of partitioning in MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-quick-start.html
The Performance Schema is implemented as a storage engine, so you can see it listed in the output from the Information Schema ENGINES table or the SHOW ENGINES statement: mysql> SELECT * FROM INFORMATION_SCHEMA.ENGINES WHERE ... This section briefly ...
https://dev.mysql.com/doc/refman/8.4/en/replication-options-binary-log.html
In a normal shutdown, the set of GTIDs from the current binary log file is saved in the mysql.gtid_executed table. Following an abnormal shutdown where this did not happen, during recovery the GTIDs are added to the table from the binary log file, ... Startup Options Used with Binary Logging System Variables Used with Binary Logging You can use the mysqld options and system variables that are described in this section to affect the operation of the binary log as well as to control which statements are written to the binary ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-incremental-load.html
Available as of MySQL 9.0.0, Lakehouse Incremental Load allows you to refresh the data in an external table. To run Lakehouse Incremental Load, load the data using Lakehouse Auto Parallel Load and set the Auto Parallel Load refresh_external_tables ...This topic contains the following sections: Before You Begin Refresh Data Overview Perform Initial Load Refresh Data What's Next Before You Begin Load structured data using Lakehouse Auto Parallel Load or ...
https://dev.mysql.com/doc/refman/8.4/en/cost-model.html
These estimates are stored in the server_cost and engine_cost tables in the mysql system database and are configurable at any time. The intent of these tables is to make it possible to easily adjust the cost estimates that the optimizer uses when it ... To generate execution plans, the optimizer uses a cost model that is based on estimates of the cost of various operations that occur during query ...