Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-about-auto-parallel-load.html
Auto Parallel Load is a feature of MySQL HeatWave that automates many of the steps for loading data, which include the following: Excluding schemas, tables, and columns that cannot be loaded. Defining RAPID as the secondary engine for tables that ...Requirements and Privileges for Auto Parallel Load To run Auto Parallel Load in normal mode, the MySQL HeatWave Cluster must be ...
https://dev.mysql.com/doc/refman/8.4/en/data-dictionary-usage-differences.html
Use of a data dictionary-enabled MySQL server entails some operational differences compared to a server that does not have a data dictionary: Previously, enabling the innodb_read_only system variable prevented creating and dropping tables only for ...The same principle applies to other table operations that require modifying data dictionary ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-dict-obj-tree.html
This means that you must know the name of any tablespace or log file group associated with a given table, or obtain this information from SHOW CREATE TABLE and then querying INFORMATION_SCHEMA.FILES, or similar means as shown here: mysql> SHOW ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-setup-threads-table.html
For background threads, setting the ENABLED value controls whether INSTRUMENTED is set to YES or NO for threads that are subsequently created for this instrument and listed in the threads table. For background threads, setting the HISTORY value ...
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/alter-table-problems.html
If you get a duplicate-key error when using ALTER TABLE to change the character set or collation of a character column, the cause is either that the new column collation maps two keys to the same value or that the table is corrupted. In the latter ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-columns-table.html
For related usage information and examples, see Section 17.15.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”. The INNODB_COLUMNS table has these columns: TABLE_ID An identifier representing the table associated with the column; the same ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-processlist-table.html
As such, the implementation of SHOW PROCESSLIST which uses this table is also deprecated. For a comparison of this table with other sources, see Sources of Process Information. This is the same value displayed in the Id column of the SHOW ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-host-cache-table.html
The host_cache_size system variable controls the size of the host cache, as well as the size of the host_cache table. Because the host_cache table exposes the contents of the host cache, it can be examined using SELECT statements. The host_cache ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-log-status-table.html
The log_status table provides information that enables an online backup tool to copy the required log files without locking those resources for the duration of the copy process. When the log_status table is queried, the server blocks logging and ...