Search Results
https://dev.mysql.com/doc/refman/8.4/en/charset-table.html
Every table has a table character set and a table collation. The CREATE TABLE and ALTER TABLE statements have optional clauses for specifying the table character set and collation: CREATE TABLE tbl_name (column_list) [[DEFAULT] CHARACTER SET ...If ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-tablespaces-table.html
The INNODB_TABLESPACES table provides metadata about InnoDB file-per-table, general, and undo tablespaces. For related usage information and examples, see Section 17.15.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”. Note The ...
https://dev.mysql.com/doc/refman/8.4/en/nontransactional-tables.html
If you receive the following message when trying to perform a ROLLBACK, it means that one or more of the tables you used in the transaction do not support transactions: Warning: Some non-transactional changed tables couldn't be rolled back These ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-statement-histogram-summary-tables.html
The Performance Schema maintains statement event summary tables that contain information about minimum, maximum, and average statement latency (see Section 29.12.20.3, “Statement Summary Tables”). Section 29.12.6, “Performance Schema ...To ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-progress-table-update.html
Rename the original mysql.backup_progress table to mysql.backup_progress_old, and the mysql.backup_progress_new table to mysql.backup_progress. Note If you are working with a multiprimary Group Replication setting, make sure these privileges are ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-autopilot-report-table.html
When Advisor or Auto Parallel Load run, they send detailed output to the heatwave_autopilot_report table in the sys schema. All versions prior to MySQL 8.0.32 use the heatwave_advisor_report and heatwave_load_report tables for reporting Autopilot ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-model-catalog-table.html
The MODEL_CATALOG table (ML_SCHEMA_user_name.MODEL_CATALOG) has the following columns: model_id A primary key, and a unique auto-incrementing numeric identifier for the model. The generated model_handle format is schemaName_tableName_userName_No, ...The model handle is generated or set by the user when the ML_TRAIN routine runs on a training ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-model-catalog-table.html
The MODEL_CATALOG table (ML_SCHEMA_user_name.MODEL_CATALOG) has the following columns: model_id A primary key, and a unique auto-incrementing numeric identifier for the model. The generated model_handle format is schemaName_tableName_userName_No, ...The model handle is generated or set by the user when the ML_TRAIN routine runs on a training ...
https://dev.mysql.com/doc/refman/8.4/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/heatwave/en/mys-hw-create-table-select.html
This topic describes how to create a new table and insert data using a SELECT query. SELECT statement is executed, the SELECT query is offloaded to MySQL HeatWave for processing, while the table is created in the DB System. row ...When the query is ...