“select * from …” without a predicate from a user table would be very expensive, yes.
A query from a small, node-local system table such as “select * from system.peers” would make a better health check. 👍 - Scott > On Aug 25, 2023, at 10:58 AM, Raphael Mazelier <r...@futomaki.net> wrote: > > > Mind that a new connection is really costly for C*. > So at startup it's fine. but not in a liveness or readiness check imo. For > the query why not select 1; ? > > -- > > Raphael Mazelier > > > > On 25/08/2023 19:38, Shaurya Gupta wrote: >> Hi community >> >> We want to validate cassandra connectivity from the application container >> when it starts up and before it reports as healthy to K8s. Is doing >>> select * from our_keyspace.table limit 1 >> fine Or is it an inefficient query and should not be fired on a prod cluster >> ? >> >> Any other suggestions ? >> >> -- >> Shaurya Gupta >> >>