Search Results
https://dev.mysql.com/doc/refman/8.4/en/explain.html
In practice, the DESCRIBE keyword is more often used to obtain information about table structure, whereas EXPLAIN is used to obtain a query execution plan (that is, an explanation of how MySQL would execute a query). By default, DESCRIBE displays ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-optimization.html
Applications that monitor databases may make frequent use of INFORMATION_SCHEMA tables. To write queries for these tables most efficiently, use the following general guidelines: Try to query only INFORMATION_SCHEMA tables that are views on data ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-locks-set.html
If you have no indexes suitable for your statement and MySQL must scan the entire table to process the statement, every row of the table becomes locked, which in turn blocks all inserts by other users to the table. For example, in a UNION, scanned ... A locking read, an UPDATE, or a DELETE generally set record locks on every index record that is scanned in the processing of an SQL ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-mysqlai-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/identifier-qualifiers.html
For example, this statement creates a table using the unqualified name t1: CREATE TABLE t1 (i INT); Because t1 includes no qualifier to specify a database, the statement creates the table in the default database. This statement creates a table using ...An unqualified name is permitted in contexts where interpretation of the name is ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-page-compression.html
InnoDB supports page-level compression for tables that reside in file-per-table tablespaces. Page compression is enabled by specifying the COMPRESSION attribute with CREATE TABLE or ALTER TABLE. Enabling Page Compression To enable page compression, ...Supported Platforms Page compression requires sparse file and hole punching ...
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/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 ...