Search Results
https://dev.mysql.com/doc/refman/9.7/en/data-dictionary-schema.html
Data dictionary tables are protected and may only be accessed in debug builds of MySQL. However, MySQL supports access to data stored in data dictionary tables through INFORMATION_SCHEMA tables and SHOW statements. For an overview of the tables ...
https://dev.mysql.com/doc/refman/9.7/en/federated-usagenotes.html
The remote table that a FEDERATED table points to must exist before you try to access the table through the FEDERATED table. It is possible for one FEDERATED table to point to another, but you must be careful not to create a loop. A FEDERATED table ...The following items indicate features that the FEDERATED storage engine does and does not support: The remote server must be a MySQL ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-limitations-transactions.html
NDBCLUSTER stores only part of a column value that uses any of MySQL's BLOB or TEXT data types in the table visible to MySQL; the remainder of the BLOB or TEXT is stored in a separate internal table that is not accessible to MySQL. This issue does ... A number of limitations exist in NDB Cluster with regard to the handling of ...
https://dev.mysql.com/doc/refman/9.7/en/upgrade-prerequisites.html
Preliminary checks: The following issues must not be present: There must be no tables that use obsolete data types or functions. Triggers must not have a missing or empty definer or an invalid creation context (indicated by the character_set_client, ... Before upgrading to the latest MySQL 9.7 release, ensure the upgrade readiness of your current MySQL 9.6 or MySQL 8.4 server instance by performing the preliminary checks described ...
https://dev.mysql.com/doc/refman/9.7/en/identifier-case-sensitivity.html
Each table within a database corresponds to at least one file within the database directory (and possibly more, depending on the storage engine). Consequently, the case sensitivity of the underlying operating system plays a part in the case ... In ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-heatwave-estimate-cluster-size.html
Optionally, log into your DB System and run ANALYZE TABLE on tables you intend to load into the MySQL HeatWave Cluster. Estimates should generally be valid without running ANALYZE TABLE , but running ANALYZE TABLE ensures that estimates are as ...
https://dev.mysql.com/doc/refman/9.7/en/index-page-merge-threshold.html
The MERGE_THRESHOLD for index pages can be defined for a table or for individual indexes. A MERGE_THRESHOLD value defined for an individual index takes priority over a MERGE_THRESHOLD value defined for the table. Setting MERGE_THRESHOLD for a Table ...If the “page-full” percentage for an index page falls below the MERGE_THRESHOLD value when a row is deleted or when a row is shortened by an UPDATE operation, InnoDB attempts to merge the index page with a neighboring index ...
https://dev.mysql.com/doc/refman/9.7/en/partitioning-range.html
A table that is partitioned by range is partitioned in such a way that each partition contains rows for which the partitioning expression value lies within a given range. While the examples work as shown for purposes of the present discussion, you ...Ranges should be contiguous but not overlapping, and are defined using the VALUES LESS THAN ...
https://dev.mysql.com/doc/refman/9.7/en/problems-connecting.html
Under Linux or Unix, check your IP tables (or similar) configuration to ensure that the port has not been blocked. The grant tables must be properly set up so that the server can use them for access control. For some distribution types (such as ...
https://dev.mysql.com/doc/mysql-enterprise-backup/9.7/en/backup-special-options.html
--safe-replica-backup-timeout=SECONDS For a replication setup, the option specifies the time (in seconds) mysqlbackup will wait for Replica_open_temp_tables to become “0” (which happens when no temporary tables are open) to complete the backup ... These options are for backing up database servers that play specific roles in replication, or contain certain kinds of data that require special care in backing ...