[MDEV-27785] Stored Routine overhead is high in benchmarks Created: 2022-02-09 Updated: 2023-03-03 |
|
| Status: | Open |
| Project: | MariaDB Server |
| Component/s: | Stored routines |
| Fix Version/s: | 10.5, 10.6 |
| Type: | Epic | Priority: | Major |
| Reporter: | Axel Schwenke | Assignee: | Sergei Golubchik |
| Resolution: | Unresolved | Votes: | 1 |
| Labels: | performance | ||
| Attachments: |
hammerdb.png
mariadb.svg
sysbench-tpcc.nonprepared.svg
sysbench-tpcc.prepared.svg
|
| Epic Name: | Stored Routine Performance |
| Description |
|
The benchmark decribed here has been locally reproduced with similar results.
A flamegraph for the server (taken at 40 client TPROC-C workload) shows high activity for table open/close and parser/lexer operations. See attached mariadb.svg |
| Comments |
| Comment by Axel Schwenke [ 2022-02-09 ] |
|
Attached two more flame graphs:
in numbers: ~6800 tps prepared and ~6200 tps non-prepared. The default is prepared. |
