Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-adaptive-hash.html
Each index is bound to a specific partition, and each partition is protected by a separate latch. If there are numerous threads waiting on rw-latches created in btr0sea.c, consider increasing the number of adaptive hash index partitions or disabling ... The adaptive hash index enables InnoDB to perform more like an in-memory database on systems with appropriate combinations of workload and sufficient memory for the buffer pool without sacrificing transactional features or ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-dictionary-tables.html
dictionary_tables contains the columns listed here: table_id The table' unique ID database_name Name of the database containing the table table_name Name of the table status The table status; one of New, Changed, Retrieved, Invalid, or Altered.
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-option-tables.html
Ndb_api_pruned_scan_count: Number of scans that have been pruned to one partition by this MySQL Server (SQL node). Ndb_api_pruned_scan_count_session: Number of scans that have been pruned to one partition in this client session. The following list ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-params-ndbd.html
MaxReorgBuildBatchSize: Maximum scan batch size to use for reorganization of table partitions. Increasing this value may speed up table partition reorganization but impacts ongoing traffic as well. PartitionsPerNode: Determines the number of table ... The listings in this section provide information about parameters used in the [ndbd] or [ndbd default] sections of a config.ini file for configuring NDB Cluster data ...
https://dev.mysql.com/doc/refman/8.4/en/upgrade-prerequisites.html
There must be no partitioned tables that use a storage engine that does not have native partitioning support. To identify such tables, execute this query: SELECT TABLE_SCHEMA, TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE ENGINE NOT IN ('innodb', ... Before upgrading to the latest MySQL 8.4 release, ensure the upgrade readiness of your current MySQL 8.3 or MySQL 8.4 server instance by performing the preliminary checks described ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-6.html
Partitioning: Truncating a partition was rejected with a duplicate entry error when the partition ID exceeded INT_MAX, preventing creation of new partitioned tables. To mitigate this issue, the Table_partition_values_pk class constructor now uses ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-attribute-tables-mysqld.html
Ndb_api_pruned_scan_count: Number of scans that have been pruned to one partition by this MySQL Server (SQL node). Ndb_api_pruned_scan_count_session: Number of scans that have been pruned to one partition in this client session.
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-attribute-tables-ndbd.html
MaxReorgBuildBatchSize: Maximum scan batch size to use for reorganization of table partitions. Increasing this value may speed up table partition reorganization but impacts ongoing traffic as well. PartitionsPerNode: Determines the number of table ... ApiFailureHandlingTimeout: Maximum time for API node failure handling before ...
https://dev.mysql.com/doc/ndbapi/en/ndb-ndboperation.html
[...] Flags: The accepted names and values are shown in the following list: OO_ABORTOPTION: 0x01 OO_GETVALUE: 0x02 OO_SETVALUE: 0x04 OO_PARTITION_ID: 0x08 OO_INTERPRETED: 0x10 OO_ANYVALUE: 0x20 OO_CUSTOMDATA: 0x40 OO_LOCKHANDLE: 0x80 OO_QUEUABLE ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-about-auto-parallel-load.html
mysql> GRANT SELECT ON performance_schema.* TO 'user_name'@'%'; Automatic Loading and Unloading of DB System Tables and Partitions As of MySQL 8.4.0, Auto Parallel Load adds the functionality to use Autopilot to collect statistics about frequently ... Auto Parallel Load is a feature of MySQL HeatWave that automates many of the steps for loading data, which include the following: Excluding schemas, tables, and columns that cannot be ...