[CASSANDRA-12403] Slow query detecting

• Type: Improvement
• Status: Resolved
• Priority: Normal
• Resolution: Fixed
• Fix Version/s: 3.10
• Component/s: Legacy/Observability
• Labels: doc-impacting
• Assignee: Shogo Hoshii
• Reporter: Shogo Hoshii

Authors

Shogo Hoshii

Reviewers

Stefania Alborghetti

• Created: 07/Aug/16 11:42
• Updated: 14/Jan/20 23:28
• Resolved: 17/Aug/16 02:55

Description

Hello,

In cassandra production environment, users sometimes build anti-pattern tables and throw queries in inefficient manners.
So I would like to suggest a feature that enables to log slow query.
The feature can help cassandra operators to identify bad query patterns.
Then operators can give advices about queries and data model to users who don't know cassandra so much.

This ticket is related to CASSANDRA-6226, and I focus on detecting bad query patterns, not aborting them.

Issue Links

• duplicates: CASSANDRA-6226 Slow query log
• is a parent of: CASSANDRA-15047 Slow Query Logger in Cassandra 3.11.4
• is related to: CASSANDRA-15503 Slow query log indicates opposite LTE when GTE operator