Details
-
Task
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
None
-
None
-
None
Description
[Affected version: at least 5.5.28a-MariaDB-log]
When a user performs queries handled by query-cache theses are not taken into account by USER_STATISTICS (and probably neither by HOST_STATISTICS).
They should properly increment COMMAND_SELECT, SENT_ROWS and when appropriate EMPTY_QUERIES.
Without updating those a user that performs the same SELECT over and over, each time hitting query cache will appear as performing no queries, just burning CPU time and exchanging bytes.
Attachments
Issue Links
- relates to
-
MDEV-7216 COM_Select goes up together with Qcache_hits
-
- Closed
-
Activity
Transition | Time In Source Status | Execution Times |
---|
|
27d 7h 6m | 1 |
|
14d 21h 23m | 3 |
|
1d 2h 12m | 4 |
|
22d 2h 34m | 1 |