[MXS-2351] Cache prepared statement in readwritesplit Created: 2019-02-25 Updated: 2024-01-04 Resolved: 2024-01-04 |
|
| Status: | Closed |
| Project: | MariaDB MaxScale |
| Component/s: | readwritesplit |
| Affects Version/s: | None |
| Fix Version/s: | 6.0.0 |
| Type: | New Feature | Priority: | Major |
| Reporter: | markus makela | Assignee: | markus makela |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | Performance | ||
| Epic Link: | Router Improvements |
| Sprint: | MXS-SPRINT-119 |
| Description |
|
Some connectors do a prepare-execute-close cycle with the same prepared statement inside the connection. By caching the prepare and ignoring the close the performance is improved and the load on the backend server is reduced. This can be a niche use-case and the benefits of this feature are not universal. |