Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema-system-tables.html
There are six columns, three of which are hidden columns created by InnoDB (DB_ROW_ID, DB_TRX_ID, and DB_ROLL_PTR). The first index is GEN_CLUST_INDEX, which is a clustered index created by InnoDB if the table does not have a user-defined clustered ... You can extract metadata about schema objects managed by InnoDB using InnoDB INFORMATION_SCHEMA ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-row-format.html
When a table is created with ROW_FORMAT=DYNAMIC, InnoDB can store long variable-length column values (for VARCHAR, VARBINARY, and BLOB and TEXT types) fully off-page, with the clustered index record containing only a 20-byte pointer to the overflow ... The row format of a table determines how its rows are physically stored, which in turn can affect the performance of queries and DML ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-options-variables.html
--ndb-default-column-format=[FIXED|DYNAMIC] Command-Line Format --ndb-default-column-format={FIXED|DYNAMIC} System Variable ndb_default_column_format Scope Global Dynamic Yes SET_VAR Hint Applies No Type Enumeration Default Value FIXED Valid Values ... This section provides information about MySQL server options, server and status variables that are specific to NDB ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-index-stat.html
To force them to be created (or updated if they already exist), invoke ndb_index_stat with the --update option, or execute ANALYZE TABLE on the table in the mysql client. --sys-create Command-Line Format --sys-create Create all statistics tables and ... ndb_index_stat provides per-fragment statistical information about indexes on NDB ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-setup-instruments-table.html
When an instrument is enabled and executed, instrumented instances are created, which are visible in the xxx_instances tables, such as file_instances or rwlock_instances. This column can be modified, although setting ENABLED has no effect for ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-ai-aml-prepare-an-anomaly-detection-model.html
To ensure reliable predictions, you should create an additional validation dataset. You can reserve 20% of the records in the training dataset to create the validation dataset. mysql> CREATE DATABASE anomaly_data; mysql> USE anomaly_data; Create the ... This topic describes how to prepare the data to use for two anomaly detection machine learning models: a semi-supervised anomaly detection model, and an unsupervised anomaly detection model for ...
https://dev.mysql.com/doc/heatwave/en/mys-hwgenai-ml-generate-table.html
Note In versions older than MySQL 9.2.1, to alter an existing table or create a new table, MySQL requires you to set the sql-require-primary-key system variable to 0. If the specified output table doesn't exist, then a new table is created. The ...
https://dev.mysql.com/doc/refman/8.4/en/flush.html
If binary logging is enabled, the sequence number of the binary log file is incremented by one relative to the previous file. Frees memory cached by the server as a result of GRANT, CREATE USER, CREATE SERVER, and INSTALL PLUGIN statements. If relay ...| tables_option } flush_option: { BINARY LOGS | ENGINE LOGS | ERROR LOGS | GENERAL LOGS | LOGS | PRIVILEGES | OPTIMIZER_COSTS | RELAY LOGS [FOR CHANNEL channel] | SLOW LOGS | STATUS | USER_RESOURCES } tables_option: { table_synonym | table_synonym tbl_name [, tbl_name] ...
https://dev.mysql.com/doc/refman/8.4/en/identifier-mapping.html
If you are using tablespaces with InnoDB, then the specific tablespace files you create are used instead. MySQL encodes any characters that are problematic in the corresponding file system objects when it creates database directories or table files: ... There is a correspondence between database and table identifiers and names in the file ...
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids-lifecycle.html
This client transaction is assigned a GTID composed of the source's UUID and the smallest nonzero transaction sequence number not yet used on this server. A GTID is also assigned to the creation, alteration, or deletion of a database, and of a ...