[MDEV-33043] Possible performance optimization when using spider_internal_sql_log_off=0/1 Created: 2023-12-16  Updated: 2023-12-16

Status: Open
Project: MariaDB Server
Component/s: Storage Engine - Spider
Fix Version/s: 10.4, 10.5, 10.6, 10.11, 11.0, 11.1, 11.2, 11.3

Type: Task Priority: Major
Reporter: Roel Van de Paar Assignee: Yuchen Pei
Resolution: Unresolved Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-29659 Got error 1227 when reading table and... Closed
relates to MDEV-33041 Improved documentation for spider_int... Confirmed

 Description   

MDEV-29659 and more specifically discussions around the manual update in MDEV-33041 highlighted a possible Spider performance optimization. It would be reflected in this manual update we were considering:

Please note that not granting SUPER and setting spider_internal_sql_log_off to 0 or 1 [may/will] lead to
slowdowns as SET SQL_LOG_OFF statements will be executed for each query on the data node.

The first step would be to clarify if this is the case. If so, it can likely be optimized as in some cases these statements may not be needed (for example if it was in the correct on/off state already), or possibly grouping of statements, etc.


Generated at Thu Feb 08 10:35:57 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.