[
https://issues.apache.org/jira/browse/CASSANDRA-21539?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18112258#comment-18112258
]
Stefan Miklosovic commented on CASSANDRA-21539:
-----------------------------------------------
[~dcapwell] [~frankgh] are you guys +1 with new set of patches, especially
{{getHostString()}}?
> Querying system_views.clients causes a DNS lookup for each unique connected
> client address
> ------------------------------------------------------------------------------------------
>
> Key: CASSANDRA-21539
> URL: https://issues.apache.org/jira/browse/CASSANDRA-21539
> Project: Apache Cassandra
> Issue Type: Bug
> Components: Feature/Virtual Tables
> Reporter: Nivy Kani
> Assignee: Nivy Kani
> Priority: Normal
> Fix For: 4.0.22, 4.1.13, 5.0.10, 6.0-alpha3, 7.0
>
> Attachments: 4.0 v2 ci_summary.html, 4.0-ci_summary.html,
> 4.0-result_details.tar.gz.zip, 4.1 v2 ci_summary-1.html, 4.1 v2
> ci_summary.html, 5.0 v2 ci_summary.html, 5.0 v2 result_details.tar.gz,
> 5.0-ci_summary.html, 5.0-result_details.tar.gz, 6.0 v2 ci_summary.html, 6.0
> v2 result_details.tar.gz, 6.0-ci_summary.html, 6.0-result_details.tar.gz,
> ci_summary-1.html, result_details.tar-1.gz, trunk v2 ci_summary.html, trunk
> v2 result_details.tar.gz
>
> Time Spent: 2.5h
> Remaining Estimate: 0h
>
> It looks like queries to the system_views.clients table does a DNS lookup for
> each unique address:
> https://github.com/apache/cassandra/blob/trunk/src/java/org/apache/cassandra/db/virtual/ClientsTable.java#L91
>
> Given Java's internal DNS caches, this is really only potentially slow on the
> first query, but we should avoid doing DNS lookups here as a workflow that
> queries this table on each node to collect client information could
> potentially overwhelm DNS this way.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
