Search Results
https://dev.mysql.com/doc/refman/9.7/en/group-by-modifiers.html
The GROUP BY clause permits a WITH ROLLUP modifier that causes summary output to include extra rows that represent higher-level (that is, super-aggregate) summary operations. ROLLUP thus enables you to answer questions at multiple levels of ...
https://dev.mysql.com/doc/refman/9.7/en/group-replication-requirements.html
Convert any tables in other storage engines to use InnoDB before using the instance with Group Replication. Every table that is to be replicated by the group must have a defined primary key, or primary key equivalent where the equivalent is a ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-index-types.html
Each InnoDB table has a special index called the clustered index that stores row data. When you define a PRIMARY KEY on a table, InnoDB uses it as the clustered index. If you do not define a PRIMARY KEY for a table, InnoDB uses the first UNIQUE ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-information-schema-innodb_cmp.html
The INNODB_CMP and INNODB_CMP_RESET tables provide status information about operations related to compressed tables, which are described in Section 17.9, “InnoDB Table and Page Compression”. These two tables have identical contents, but reading ...For example, if you archive the output of INNODB_CMP_RESET every 60 minutes, you see the statistics for each hourly ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-purge-configuration.html
If DML action is concentrated on a single table, purge operations for the table are performed by a single purge thread, which can result in slowed purge operations, increased purge lag, and increased tablespace file size if the DML operations ...
https://dev.mysql.com/doc/refman/9.7/en/json-duality-views-updatable.html
Sub-statement generation: The JSON duality view decomposes and generates the necessary DML operations targeting the normalized base tables. Inserting objects for JSON duality views on self referencing tables and circularly referencing tables is ...
https://dev.mysql.com/doc/refman/9.7/en/json-utility-functions.html
This section documents utility functions that act on JSON values, or strings that can be parsed as JSON values. JSON_PRETTY() prints out a JSON value in a format that is easy to read. JSON_STORAGE_SIZE() and JSON_STORAGE_FREE() show, respectively, ...
https://dev.mysql.com/doc/refman/9.7/en/linux-installation-rpm.html
A standard installation of MySQL using the RPM packages result in files and resources created under the system directories, shown in the following table. The recommended way to install MySQL on RPM-based Linux distributions is by using the RPM ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-limitations-unsupported.html
A number of features supported by other storage engines are not supported for NDB tables. If a prefix is used as part of an index specification in a statement such as CREATE TABLE, ALTER TABLE, or CREATE INDEX, the prefix is not created by NDB. A ...Trying to use any of these features in NDB Cluster does not cause errors in or of itself; however, errors may occur in applications that expects the features to be supported or ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-replication-general.html
Important If you attempt to use NDB Cluster Replication with --binlog-format=STATEMENT, replication fails to work properly because the ndb_binlog_index table on the source cluster and the epoch column of the ndb_apply_status table on the replica ...