Details
-
Task
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Done
Description
We need to benchmark how much slowdown we experience when we add the optimizer trace to the
server.
We would need the comparision for:
1) server without the optimizer trace (current 10.4)
2) server with optimizer trace disabled here. (currently in branch 10.4-mdev6111)
The optimizer trace is currently disabled by default.
Please run sysbench.
Attachments
Issue Links
- is part of
-
-
- Closed
-
- relates to
-
-
- Stalled
-
Activity
| Field | Original Value | New Value |
|---|---|---|
| Description |
We need to benchmark how much slowdown we experience when we add the optimizer trace to the
server. We would need the comparision for: 1) server without the optimizer trace (current 10.4) 2) server with optimizer trace disabled here. (currently in branch 10.4-mdev6111) {code:sql} set optimizer_trace='enabled=off'; {code} |
| Description |
We need to benchmark how much slowdown we experience when we add the optimizer trace to the
server. We would need the comparision for: 1) server without the optimizer trace (current 10.4) 2) server with optimizer trace disabled here. (currently in branch 10.4-mdev6111) {code:sql} set optimizer_trace='enabled=off'; {code} |
We need to benchmark how much slowdown we experience when we add the optimizer trace to the
server. We would need the comparision for: 1) server without the optimizer trace (current 10.4) 2) server with optimizer trace disabled here. (currently in branch 10.4-mdev6111) The optimizer trace is currently disabled by default. Please run sysbench. |
| Assignee | Axel Schwenke [ axel ] |
| Affects Version/s | 10.4 [ 22408 ] | |
| Issue Type | Bug [ 1 ] | Task [ 3 ] |
| Attachment | image-2019-01-29-17-02-28-197.png [ 47186 ] |
| Attachment | screenshot-1.png [ 47187 ] |
| Attachment | mdev18182-analysis.ods [ 47188 ] |
| Assignee | Axel Schwenke [ axel ] | Varun Gupta [ varun ] |
| Status | Open [ 1 ] | In Progress [ 3 ] |
| Labels | benchmarking |
| Link | This issue relates to MDEV-18822 [ MDEV-18822 ] |
| Attachment | mdev18172-optimizer-trace-benchmark-jun14.ods [ 48214 ] |
| Attachment | Screenshot from 2019-06-17 11-34-59.png [ 48215 ] |
| Attachment | Screenshot from 2019-06-17 11-34-59.png [ 48215 ] |
| Attachment | benchmarks.png [ 48216 ] |
| Fix Version/s | N/A [ 14700 ] | |
| Fix Version/s | 10.4 [ 22408 ] | |
| Summary | Benchmarking for optimizer trace | Benchmarking 10.4 for optimizer trace |
| Resolution | Done [ 10200 ] | |
| Status | In Progress [ 3 ] | Closed [ 6 ] |
| Workflow | MariaDB v3 [ 91576 ] | MariaDB v4 [ 133811 ] |