I'm using cassandra-driver with NodeJS application.. Table with two columns with one of them as primary key. Through application, Select columnA FROM table_name WHERE columnB="" is executed. Have configuration for Slow queries set... When the above query took more time than threshold... it is printing SELECT * FROM table_name WHERE columnB="__" instead. Is driver modifies query?? How the column name is coverted to asterisk (*)
This question was
closed
by
Erick Ramirez for the following reason: The question is answered, right answer was accepted
Does the driver modify queries so columns are converted to asterisk in slow query logs?
No, the driver does not modify the queries. The logging of the slow queries is what makes it look like the queries are different. Let me explain.
If a query is detected to be slow, the following entry will be logged in the system.log at INFO level (at most once every 5 minutes) by MonitoringTask.java:
INFO [ScheduledTasks:1] 2020-06-06 20:35:50,209 NoSpamLogger.java:91 - Some operations were slow, details available at debug level (debug.log)
The slow queries are logged in the debug.log every 5 seconds:
DEBUG [ScheduledTasks:1] 2020-06-06 20:35:50,211 MonitoringTask.java:173 - 3 operations were slow in the last 4998 msecs: <SELECT * FROM community.users LIMIT 5000>, time 3026 msec - slow timeout 500 msec <SELECT * FROM community.users WHERE user = "jack" LIMIT 5000>, was slow 2 times: avg/min/max 330/825/835 msec - slow timeout 500 msec <SELECT * FROM community.users WHERE token(id) > 0 LIMIT 5000>, time 1449 msec - slow timeout 500 msec
The implication is that slow queries are not immediately logged -- they are aggregated (counted) for a period of time (5 seconds in this example).
For troubleshooting purposes, the exact CQL string isn't logged. Just the operation ( SELECT, INSERT), the respective table, the filter (WHERE clause) and limits (default is 5000). In most cases, this is sufficient to pinpoint problematic tables and partitions accessed by the application. Cheers!
5 People are following this question.
