Search Results
https://dev.mysql.com/doc/refman/8.4/en/repair-table-optimization.html
REPAIR TABLE for MyISAM tables is similar to using myisamchk for repair operations, and some of the same performance optimizations apply: myisamchk has variables that control memory allocation. For REPAIR TABLE, the same principle applies, but ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-history-table-update.html
Rename the original mysql.backup_history table to mysql.backup_history_old, and the mysql.backup_history_new table to mysql.backup_history. Note If you are working with a multiprimary Group Replication setting, make sure these privileges are granted ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-sbt-history-table-update.html
Rename the original mysql.backup_sbt_history table to mysql.backup_sbt_history_old, and the mysql.backup_sbt_history_new table to mysql.backup_sbt_history. Note If you are working with a multiprimary Group Replication setting, make sure these ...
https://dev.mysql.com/doc/workbench/en/wb-design-table-templates.html
Define table templates with commonly used columns and settings to create new tables from either a live connection or while creating an EER model. From the SQL editor, select Create Table Like from the Tables context menu, as shown in the next ...
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/refman/8.4/en/information-schema-innodb-cached-indexes-table.html
The INNODB_CACHED_INDEXES table reports the number of index pages cached in the InnoDB buffer pool for each index. For related usage information and examples, see Section 17.15.5, “InnoDB INFORMATION_SCHEMA Buffer Pool Tables”. row ...Index ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-tablespaces-brief-table.html
The INNODB_TABLESPACES_BRIEF table provides space ID, name, path, flag, and space type metadata for file-per-table, general, undo, and system tablespaces. INNODB_TABLESPACES provides the same metadata but loads more slowly because other metadata ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-table-info.html
The table_info table provides information about logging, checkpointing, distribution, and storage options in effect for individual NDB tables.
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-events-stages-history-long-table.html
The events_stages_history_long table contains the N most recent stage events that have ended globally, across all threads. Stage events are not added to the table until they have ended. When the table becomes full, the oldest row is discarded when ...The Performance Schema autosizes the value of N during server ...