[MCOL-4639] calsettrace(1) causes much journal logging Created: 2021-03-25  Updated: 2023-11-21  Resolved: 2023-11-03

Status: Closed
Project: MariaDB ColumnStore
Component/s: MDB Plugin
Affects Version/s: 5.5.1
Fix Version/s: Icebox

Type: Bug Priority: Major
Reporter: David Hall (Inactive) Assignee: Unassigned
Resolution: Won't Fix Votes: 0
Labels: None

Epic Link: ColumnStore Message & Logging Improvements

 Description   

We call calsettrace(1) whenever we want to get statistics on a query. We often forget to turn it back off, since the performance hit is not much.

This isn't really a problem except – when calsettrace is on, it triggers a massive amount of logging in journalctl, which is unnecessarily consuming disk and cluttering up the journal.

I propose we use calsettrace(2 or 3) to turn on journal logging with statistics. The function accepts an integer, so we ought to be able to make it not journal log unless a value > 1 is used.

I proposed 2 or 3 because 2 >1 gives us a unique number but alternatively, 3 could be used as a bitmask such that 1 = stats, 2 = logging and 3 = both.


Generated at Thu Feb 08 02:51:52 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.