[MDEV-9092] Removing element from MDL map takes 2% in OLTP PS Created: 2015-11-06 Updated: 2022-05-06 |
|
| Status: | Open |
| Project: | MariaDB Server |
| Component/s: | Locking |
| Affects Version/s: | 10.1 |
| Fix Version/s: | None |
| Type: | Bug | Priority: | Major |
| Reporter: | Sergey Vojtovich | Assignee: | Unassigned |
| Resolution: | Unresolved | Votes: | 0 |
| Labels: | None | ||
| Epic Link: | Performance: micro optimizations |
| Description |
|
For a single threaded benchmark that issues in a loop "SELECT c FROM sbtest1 WHERE id=<id>" we insert/remove element to/from MDL hash once per query. This involves memory allocation and takes ~2% of execution time. It should be possible to avoid this by caching elements. |
| Comments |
| Comment by Elena Stepanova [ 2015-12-05 ] |
|
svoj, please either specify the target fix version, or assign it to somebody (or both). |