Search Results
https://dev.mysql.com/doc/refman/8.4/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/8.4/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/8.4/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/8.4/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/8.4/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/8.4/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 ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-what-is-new.html
What is New in NDB Cluster 8.4 Major changes and new features in NDB Cluster 8.4 which are likely to be of interest are listed here: ndbinfo transporter_details table. The transporter_details table provides information about individual transporters ... What is New in NDB Cluster 8.4 Changes in NDB 8.x Innovation Releases The following sections describe changes in the implementation of MySQL NDB Cluster in NDB Cluster 8.0 through 8.0.44, as compared to earlier release ...
https://dev.mysql.com/doc/refman/8.4/en/optimizer-issues.html
Use ANALYZE TABLE tbl_name to update the key distributions for the scanned table. Use FORCE INDEX for the scanned table to tell MySQL that table scans are very expensive compared to using the given index: SELECT * FROM t1, t2 FORCE INDEX ... MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/option-files.html
On Windows, MySQL programs read startup options from the files shown in the following table, in the specified order (files listed first are read first, files read later take precedence). On Unix and Unix-like systems, MySQL programs read startup ...
https://dev.mysql.com/doc/refman/8.4/en/other-vendor-data-types.html
To facilitate the use of code written for SQL implementations from other vendors, MySQL maps data types as shown in the following table. These mappings make it easier to import table definitions from other database systems into MySQL. If you create ...