[MDEV-22324] Benchmark parts of query-processing Created: 2020-04-21 Updated: 2021-09-16 |
|
| Status: | Open |
| Project: | MariaDB Server |
| Component/s: | OTHER |
| Fix Version/s: | None |
| Type: | Task | Priority: | Critical |
| Reporter: | Oleksandr Byelkin | Assignee: | Michael Widenius |
| Resolution: | Unresolved | Votes: | 2 |
| Labels: | benchmarking | ||
| Issue Links: |
|
||||||||
| Description |
|
For optimization of query processing in general, as well as for MDEV-16670 particularly we need to know how much time took each part of query processing for simple queries (no optimisation and no big joins). I think we can split processing on such phases: 1) parsing It would be nice to check c) simple delete e) (lower priority) multi delete and multi-update which are specific SELECTs (interesting to see how it compared to simple UPDATE and usual SELECT. Also it is interesting to compare 5.5 and 10.5 to see if we have much regress for simple queries at all (and find it if we really have it a lot). |