Providing connection details with username for real time connection monitoring.
Currently, mongd.log provides connection details like remote IP, source port with authentication information but doesn't provide the connection is in active state or not.
serverStatus() only provides number of current and active connections.
Example:
10.0.0.100:12345 - username active
10.0.0.101:12346 - username idle
Hyung
shared this idea
-
Wei
commented
$currentOp does not print all connections info but mysql's 'show processlist' does.
-
AdminMark
(Admin, MongoDB)
commented
https://dev.mysql.com/doc/refman/8.4/en/show-processlist.html
$currentOp with effectiveUser is this
https://www.mongodb.com/docs/manual/reference/operator/aggregation/currentOp/
mongodb.com/docs/manual/reference/command/currentop/#mongodb-data-currentOp.effectiveUsers -
Wei
commented
It's better to provide a command which could report remote ip, source port, user info, database info, connection status, detailed operation if connection is active. The output from mysql 'show processlist' command could be a good example.