Search Results
https://dev.mysql.com/doc/internals/en/optimizer-range-join-type.html
Some conditions can work with indexes, but over a (possibly wide) range of keys. The optimizer will use an index (range search) for column1 LIKE 'x%' but not for column1 LIKE '%x' That is, there is no range search if the first character in the ...
https://dev.mysql.com/doc/internals/en/parsing-key-information.html
Many of the index methods pass a byte array named *key that identifies the index entry to be read in a standard format. Your storage engine will need to extract the information stored in the key and translate it into its internal index format to ...
https://dev.mysql.com/doc/ndbapi/en/mccj-using-clusterj-annotations.html
The annotations @PrimaryKey and @Index inform ClusterJ about indexes in the database table. They can be found in package com.mysql.clusterj.annotation, and can be imported like this: import com.mysql.clusterj.annotation.Column; import ... In ...
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 ...