DSE Cassandra でのクエリキャプチャの設定

dse.yaml ファイルで、次のパラメータを設定します（またはコメント解除して編集します）。

cql_slow_log_options:
    enabled: true
    #  When t > 1, log queries taking longer than t milliseconds.
    #      0 <= t <= 1,  log queries above t percentile
    threshold: 2000
    # Initial number of queries before percentile filter becomes active
    minimum_samples: 100
    ttl_seconds: 259200
     # Keeps slow queries in-memory only and doesn't write data to the database.
    # WARNING - if this is set to 'false' then set threshold >= 2000, otherwise there will be a
    # high load on the database.
    skip_writing_to_db: false
    # The number of slow queries to keep in-memory
    num_slowest_queries: 5

CODE

「enabled」と「skip_writing_to_db」を除くこれらのパラメータはすべて、モニタリング要件に従って調整できます。

DSE Cassandra のユーザ権限

CREATE ROLE appdynamics_role;
GRANT SELECT ON KEYSPACE system_traces TO appdynamics_role;
GRANT SELECT ON TABLE dse_perf.node_slow_log TO appdynamics_role;
GRANT appdynamics_role TO appdynamics;

CODE