Lists the Optimizer configuration metrics and provides a brief description of each.
Table 5.20 Optimizer Configuration Metrics
| Name | Description |
|---|---|
| End Markers In Json Enabled (Total) | Whether optimizer JSON output should add end markers. |
| Eq Range Index Dive Limit (Total) | Indicates the number of equality ranges in an equality comparison condition when the optimizer should switch from using index dives to index statistics in estimating the number of qualifying rows. |
| Max Length For Sort Data (Total) | The maximum size of parameter values that can be sent with the mysql_stmt_send_long_data() C API function. |
| Max Seeks For Key (Total) | Limit the assumed maximum number of seeks when looking up rows based on a key. |
| Max Sort Length (Total) | The number of bytes to use when sorting data values. Only the first max_sort_length bytes of each value are used; the rest are ignored. |
| Prune Level Enabled (Total) | Controls the heuristics applied during query optimization to prune less-promising partial plans from the optimizer search space. |
| Range Alloc Block Size (Total) | The size of blocks (in bytes) that are allocated when doing range optimization. |
| Search Depth (Total) | The maximum depth of search performed by the query optimizer. |
| Switch Value (Total) | The optimizer_switch system variable enables control over optimizer behavior. |
| Trace (Total) | Controls how to enable optimizer tracing. |
| Trace Features (Total) | Enables or disables selected optimizer tracing features. |
| Trace Limit (Total) | The maximum cumulative size of stored optimizer traces. |
| Trace Max Mem Size (Total) | The maximum cumulative size of stored optimizer traces. |
| Trace Offset (Total) | The offset of optimizer traces to display. |