PLANNED MAINTENANCE

Hello, DataStax Community!

We want to make you aware of a few operational updates which will be carried out on the site. We are working hard to streamline the login process to integrate with other DataStax resources. As such, you will soon be prompted to update your password. Please note that your username will remain the same.

As we work to improve your user experience, please be aware that login to the DataStax Community will be unavailable for a few hours on:

  • Wednesday, July 15 16:00 PDT | 19:00 EDT | 20:00 BRT
  • Thursday, July 16 00:00 BST | 01:00 CEST | 04:30 IST | 07:00 CST | 09:00 AEST

For more info, check out the FAQ page. Thank you for being a valued member of our community.

question

vkayanala_42513 avatar image
vkayanala_42513 asked ·

How can I check which tables app requests are hitting?

Hello DS Community,

I'm facing hard to find which keyspace/table being hit more while cluster is under load.

Is there any tool or logging which can give numbers of read and write requests going to? and how Opscenter get the stats of application requests in Cassandra?

We are using OpsCenter, and added dashboard of TBL: Local Read requests to a specific keyspace.table but it's not showing any number on it. It would be grate if we have straight forward commands that will give all these numbers for specific timeline.

Please help me.

-Varun

cassandra
10 |1000 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.

1 Answer

Erick Ramirez avatar image
Erick Ramirez answered ·

@vkayanala_42513 You won’t be able to see the queries coming through to the cluster unless you have audit logging enabled.

If you are collecting slow queries, it might give you some idea on which tables are problematic but it’s not a direct correlation to the most accessed tables. It’s more a side-effect since queries start to slow down when nodes are under load.

As a last resort, you can monitor the local read count in the output of nodetool tablestats. There isn’t an out-of-the-box solution for it so you’ll need to write a script of some sort to make it easier to track it over a certain period. Cheers!

Share
10 |1000 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.