[ 
https://issues.apache.org/jira/browse/CASSANDRA-20885?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Dmitry Konstantinov updated CASSANDRA-20885:
--------------------------------------------
    Description: 
When we have an audit enabled for DDL/LOGIN events (and it is disabled for DML) 
we have an overhead for BATCH operations (0.75% of CPU usage in a real business 
workload), when we build a BATCH audit event to check that it is not in scope 
of audit and throw it away

!image-2025-09-04-13-52-19-490.png|width=600!

 
{code:java}
UUID batchId = UUID.randomUUID();
String queryString = String.format("BatchId:[%s] - BATCH of [%d] statements", 
batchId, statements.size()); {code}

  was:
When we have an audit enabled for DDL/LOGIN events (and it is disabled for DML) 
we have an overhead for BATCH operations (0.75% of CPU usage in a real business 
workload), when we build an audit event for them to throw it away after it.

!image-2025-09-04-13-52-19-490.png|width=600!

 
{code:java}
UUID batchId = UUID.randomUUID();
String queryString = String.format("BatchId:[%s] - BATCH of [%d] statements", 
batchId, statements.size()); {code}


> Optimize org.apache.cassandra.audit.AuditLogManager#batchSuccess
> ----------------------------------------------------------------
>
>                 Key: CASSANDRA-20885
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-20885
>             Project: Apache Cassandra
>          Issue Type: Improvement
>          Components: CQL/Interpreter
>            Reporter: Dmitry Konstantinov
>            Assignee: Dmitry Konstantinov
>            Priority: Normal
>         Attachments: audit_batch_perf.patch, image-2025-09-04-13-52-19-490.png
>
>
> When we have an audit enabled for DDL/LOGIN events (and it is disabled for 
> DML) we have an overhead for BATCH operations (0.75% of CPU usage in a real 
> business workload), when we build a BATCH audit event to check that it is not 
> in scope of audit and throw it away
> !image-2025-09-04-13-52-19-490.png|width=600!
>  
> {code:java}
> UUID batchId = UUID.randomUUID();
> String queryString = String.format("BatchId:[%s] - BATCH of [%d] statements", 
> batchId, statements.size()); {code}



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@cassandra.apache.org
For additional commands, e-mail: commits-h...@cassandra.apache.org

Reply via email to