[jira] [Comment Edited] (CASSANDRA-6487) Log WARN on large batch sizes

["Martin Grotzke (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CASSANDRA-6487?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15059781#comment-15059781 ] 

Martin Grotzke edited comment on CASSANDRA-6487 at 12/16/15 10:11 AM:
----------------------------------------------------------------------

Thanks [~pmcfadin] for the clarification! I saw you created CASSANDRA-10876 and also the related CASSANDRA-8825 - I wasn't aware of this ticket, good to see.

Would you say the cost of a single partition single statement batch is exactly the same as a "normal" single statement?
And how would you compare a single partition batch with multiple insert statements to just multiple insert statements in terms of server load / throughput - is executing multiple single partition statements as a batch a valid approach to increase throughput?


was (Author: martin.grotzke):
Thanks [~pmcfadin] for the clarification! I saw you created CASSANDRA-10876 and also the related CASSANDRA-8825 - I wasn't aware of this ticket, good to see.

> Log WARN on large batch sizes
> -----------------------------
>
>                 Key: CASSANDRA-6487
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-6487
>             Project: Cassandra
>          Issue Type: Improvement
>            Reporter: Patrick McFadin
>            Assignee: Lyuben Todorov
>            Priority: Minor
>             Fix For: 2.0.8, 2.1 beta2
>
>         Attachments: 6487-cassandra-2.0.patch, 6487-cassandra-2.0_v2.patch
>
>
> Large batches on a coordinator can cause a lot of node stress. I propose adding a WARN log entry if batch sizes go beyond a configurable size. This will give more visibility to operators on something that can happen on the developer side. 
> New yaml setting with 5k default.
> {{# Log WARN on any batch size exceeding this value. 5k by default.}}
> {{# Caution should be taken on increasing the size of this threshold as it can lead to node instability.}}
> {{batch_size_warn_threshold: 5k}}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)