[MDEV-26369] Add Spider status variable to count usage of GROUP BY handler Created: 2021-08-15  Updated: 2023-11-28

Status: Open
Project: MariaDB Server
Component/s: Storage Engine - Spider
Fix Version/s: 10.11

Type: Task Priority: Major
Reporter: Nayuta Yanagisawa (Inactive) Assignee: Yuchen Pei
Resolution: Unresolved Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-26364 Add Spider server variable for disabl... Closed

 Description   

The Spider storage engine has status variables for counting the number of times direct UPDATE and direct DELETE. https://mariadb.com/kb/en/spider-status-variables/#spider_direct_delete

It would be convenient that there is a status variable to count the number of times the direct SELECT is performed (i.e., GROUP BY handler is used). Currently, a user can distinguish direct SELECT and non-direct SELECT by the result of EXPLAIN, but this is not consistent and makes it difficult to collect statistics about the direct SELECT.

From the consistency viewpoint, the name of the status variable would be Spider_direct_select or Spider_group_by_handler.


Generated at Thu Feb 08 09:44:46 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.