[CASSANDRA-13000] slow query log analysis tool

• Type: New Feature
• Status: Patch Available
• Priority: Normal
• Resolution: Unresolved
• Fix Version/s: 5.x
• Component/s: Legacy/Observability
• Assignee: Murukesh Mohanan
• Reporter: Jon Haddad

Authors

Murukesh Mohanan

• Created: 05/Dec/16 22:18
• Updated: 07/Mar/23 10:54

Description

As a follow up to CASSANDRA-12403, it would be very helpful to have a tool to process the slow queries that are logged. In the MySQL world, there's a tool called mysqldumpslow, which processes a slow query log, abstracts the parameters to prepared statements, and shows the queries which are causing problems based on frequency. The mysqldumpslow utillity shows an aggregated count & time statistics spent on slow queries. For instance:

shell> mysqldumpslow

Reading mysql slow query log from /usr/local/mysql/data/mysqld51-apple-slow.log
Count: 1  Time=4.32s (4s)  Lock=0.00s (0s)  Rows=0.0 (0), root[root]@localhost
 insert into t2 select * from t1

Count: 3  Time=2.53s (7s)  Lock=0.00s (0s)  Rows=0.0 (0), root[root]@localhost
 insert into t2 select * from t1 limit N

Count: 3  Time=2.13s (6s)  Lock=0.00s (0s)  Rows=0.0 (0), root[root]@localhost
 insert into t1 select * from t1