Details
-
Task
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
Description
Optimizer trace doesn't show much information about Rowid Filtering. The only thing one can see is the chosen ref access method in best_access_path:
+ "chosen_access_method": {
|
+ "type": "ref",
|
+ "records": 138,
|
+ "cost": 91,
|
+ "uses_join_buffering": false,
|
+ "filter_used": true
|
+ }
|
Note that if one looks above, it is not even shown for the considered methods:
+ {
|
+ "access_type": "ref",
|
+ "index": "ux_pk1_fd5",
|
+ "used_range_estimates": true,
|
+ "rows": 138,
|
+ "cost": 91,
|
+ "chosen": true
|
+ },
|
This task is about fixing this.
Attachments
Activity
| Field | Original Value | New Value |
|---|---|---|
| Summary | Rowid Filtering is not displayed well by the optimizer trace. | Rowid Filtering is not displayed well in the optimizer trace |
| Labels | optimizer_trace rowid_filtering |
| Assignee | Sergei Petrunia [ psergey ] |
| Fix Version/s | 10.4 [ 22408 ] | |
| Fix Version/s | 10.5 [ 23123 ] |
| Fix Version/s | 10.4.13 [ 24223 ] | |
| Fix Version/s | 10.5.3 [ 24263 ] | |
| Fix Version/s | 10.4 [ 22408 ] | |
| Fix Version/s | 10.5 [ 23123 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | Open [ 1 ] | Closed [ 6 ] |
| Workflow | MariaDB v3 [ 105958 ] | MariaDB v4 [ 134222 ] |
psergey please make sure to push the patch into 10.4, rowid filtering was there in 10.4. Currently the patch is based on 10.5