Search Results
https://dev.mysql.com/doc/refman/8.4/en/index-condition-pushdown-optimization.html
Index Condition Pushdown (ICP) is an optimization for the case where MySQL retrieves rows from a table using an index. Without ICP, the storage engine traverses the index to locate rows in the base table and returns them to the MySQL server which ...ICP can reduce the number of times the storage engine must access the base table and the number of times the MySQL server must access the storage ...
https://dev.mysql.com/doc/refman/8.4/en/creating-spatial-indexes.html
For more information on indexing spatial columns, see Section 15.1.15, “CREATE INDEX Statement”. For InnoDB and MyISAM tables, MySQL can create spatial indexes using syntax similar to that for creating regular indexes, but using the SPATIAL ...
https://dev.mysql.com/doc/heatwave-aws/en/running-autopilot-index-advisor-using-heatwave-console.html
Running Autopilot Index Advisor 11.1 Running Autopilot Index Advisor To run Autopilot Index Advisor, the user must connect to the DB system and have the following MySQL privileges: The EXECUTE privilege on the sys schema. Perform the following ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-auto-indexing-examples.html
| | Expected time for applying all Index creation suggestions: 25 s | | | +--------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ To ... To evaluate all user defined schemas: mysql> CALL sys.autopilot_index_advisor(NULL); To evaluate selected schemas: mysql> CALL sys.autopilot_index_advisor(JSON_OBJECT('target_schema',JSON_ARRAY('schema1','schema2', ...))); An example of the output that includes the following information: New indexes to ...
https://dev.mysql.com/doc/refman/8.4/en/index-preloading.html
To preload an index into a cache, use the LOAD INDEX INTO CACHE statement. Thus, the statement shown preloads all index blocks from t1, but only blocks for the nonleaf nodes from t2. If an index has been assigned to a key cache using a CACHE INDEX ... If there are enough blocks in a key cache to hold blocks of an entire index, or at least the blocks corresponding to its nonleaf nodes, it makes sense to preload the key cache with index blocks before starting to use ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-index-types.html
Each InnoDB table has a special index called the clustered index that stores row data. To get the best performance from queries, inserts, and other database operations, it is important to understand how InnoDB uses the clustered index to optimize ...If there is no logical unique and non-null column or set of columns to use a the primary key, add an auto-increment ...
https://dev.mysql.com/doc/refman/8.4/en/index-statistics.html
The SHOW INDEX statement displays a cardinality value based on N/S, where N is the number of rows in the table and S is the average value group size. When a given index value yields a large number of rows, the index is less useful and MySQL is less ... Storage engines collect statistics about tables for use by the ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-auto-indexing.html
Autopilot Indexing obtains workloads from the statement digest history stored in the Performance Schema, evaluates them, and identifies potential indexes that can help improve workload performance. Indexes can improve the query performance of ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-autopilot-index-advisor-report-table.html
When Autopilot Indexing runs, it sends detailed output to the autopilot_index_advisor_report table in the sys schema. The autopilot_index_advisor_report table is a temporary table that contains data from the last execution of Autopilot Indexing.
https://dev.mysql.com/doc/internals/en/optimizer-index-merge-join-type.html
7.2.2.5.1 Overview Index Merge is used when table condition can be converted to form: cond_1 OR cond_2 ... OR cond_N The conditions for conversion are that each cond_i can be used for a range scan, and no pair (cond_i, cond_j) uses the same index.