Search Results
https://dev.mysql.com/doc/heatwave-aws/en/mysql-server-default-privileges.html
Default MySQL Privileges 3.1.2.9 Default MySQL Privileges This section lists the MySQL privileges granted to the MySQL Administrator user on the DB System and those explicitly revoked on the mysql and sys schemas.
https://dev.mysql.com/doc/refman/8.4/en/column-count-limit.html
Functional key parts (see Section 15.1.15, “CREATE INDEX Statement”) are implemented as hidden virtual generated stored columns, so each functional key part in a table index counts against the table total column limit. mysql> CREATE TABLE t (a ... This section describes limits on the number of columns in tables and the size of individual ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-user-credentials.html
The process of creating the replication user for distributed recovery can be captured in the binary log, and then you can rely on distributed recovery to replicate the statements used to create the user. Alternatively, you can disable binary logging ... Group Replication uses a distributed recovery process to synchronize group members when joining them to the ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-file-per-table-tablespaces.html
File-per-table tablespace characteristics are described under the following topics in this section: File-Per-Table Tablespace Configuration File-Per-Table Tablespace Data Files File-Per-Table Tablespace Advantages File-Per-Table Tablespace ... A ...
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 ...