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
注: 「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;