Deprecate Spider plugin variables that result in excessive tweak
(MDEV-27228)
|
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Storage Engine - Spider |
| Affects Version/s: | None |
| Fix Version/s: | 10.7.4, 10.8.3 |
| Type: | Technical task | Priority: | Major |
| Reporter: | Nayuta Yanagisawa (Inactive) | Assignee: | Nayuta Yanagisawa (Inactive) |
| Resolution: | Done | Votes: | 0 |
| Labels: | None | ||
| Issue Links: |
|
||||||||
| Description |
|
Passing a Handler statement to backend data nodes without converting it to SQL sometimes improves the performance. However, only a few people use Handler statements and the performance gain seems not to be very significant. Further, setting spider_use_handler > 0 disables the GROUP BY handler. |
| Comments |
| Comment by Nayuta Yanagisawa (Inactive) [ 2022-03-02 ] |
|
https://github.com/MariaDB/server/commit/b034b416b2cfebe649db787de0f5a14da8091b12 |
| Comment by Nayuta Yanagisawa (Inactive) [ 2022-03-02 ] |
|
I should have taken care of the table value "uhd". |
| Comment by Nayuta Yanagisawa (Inactive) [ 2022-03-02 ] |
|
|
| Comment by Nayuta Yanagisawa (Inactive) [ 2022-03-02 ] |
|
Please review the patch below. The variable and the related code will be deleted in 10.9 or at least 10.10. https://github.com/MariaDB/server/commit/531e4395c3ccf68a77ceab4d19138a85809254d6 |
| Comment by Alexey Botchkov [ 2022-03-13 ] |
|
ok to push. |
[MDEV-27923]