Search Results
https://dev.mysql.com/doc/ndbapi/en/ndb-error-codes-temporary-resource-error.html
The following list enumerates all NDB errors of type TR (Temporary Resource error).
https://dev.mysql.com/doc/ndbapi/en/ndb-ndboperation.html
Lock handles and unlock operations are not supported for unique index read operations. Index columns cannot be used in place of table columns with this method. For index scans, partitioning information can be supplied for each range. Beginning with ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-metric-innodb-adaptivehashactivity-category.html
Table 6.10 InnoDB Adaptive Hash Activity Metrics NameDescriptionHash Node Heap The total number of (16Kb) pages allocated to the InnoDB adaptive hash index. Hash Searches Per Sec The per second average of the searches within InnoDB satisified by the ... Lists the InnoDB Adaptive Hash Activity metrics and provides a brief description of ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema-buffer-pool-tables.html
The InnoDB INFORMATION_SCHEMA buffer pool tables provide buffer pool status information and metadata about the pages within the InnoDB buffer pool. The InnoDB INFORMATION_SCHEMA buffer pool tables include those listed below: mysql> SHOW TABLES FROM ...
https://dev.mysql.com/doc/refman/8.4/en/key-space.html
You can roughly calculate the size for the index file as (key_length+4)/0.67, summed over all keys. If the first index part is a string, it is also prefix compressed. Space compression makes the index file smaller than the worst-case figure if a ...
https://dev.mysql.com/doc/refman/8.4/en/midpoint-insertion.html
When an index block is read from a table into the key cache, it is placed at the end of the warm sublist. At present, the number of hits required to promote a block (3) is the same for all index blocks. The midpoint insertion strategy helps to ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-limitations-performance.html
If necessary, you can employ USE INDEX or FORCE INDEX to alter the execution plan. See Section 10.9.4, “Index Hints”, for more information on how to do this. Unique hash indexes created with USING HASH cannot be used for accessing a table if ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-logs-cluster-log.html
The most recent GCI that can be used has the index current_gci, and the oldest GCI from which the cluster can be restored has the index old_gci. The GCI in progress has the index started_gci, and the most recent GCI to have been completed has the ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-error-log-table.html
The error_log table has these indexes: Primary key on (LOGGED) Index on (THREAD_ID) Index on (PRIO) Index on (ERROR_CODE) Index on (SUBSYSTEM) TRUNCATE TABLE is not permitted for the error_log table. Of the logs the MySQL server maintains, one is ...
https://dev.mysql.com/doc/refman/8.4/en/pluggable-storage-common-layer.html
Physical Storage: This involves everything from the overall page size for tables and indexes as well as the format used for storing data to physical disk. Index Support: Different application scenarios tend to benefit from different index strategies. Each storage engine generally has its own indexing methods, although some (such as B-tree indexes) are common to nearly all ... A MySQL pluggable storage engine is the component in the MySQL database server that is responsible for performing the actual ...