I found a solution where i configure rsyslog to pick up that file and forward it to my target server.
# RSyslog Configuration for MongoDB /etc/rsyslog.d/mongod.conf
local3.* action(type="omfwd" ...
The below query will join both the tables and return the sum based on order date,
As per MongoDB documentation here Changed in version 3.2: $sum is available in the $group and $project stages. In previous versions of MongoDB, $sum is available in the $group stage only.
When used in the $group stage, $sum has the following syntax and returns the collective sum of all the numeric values that result from applying a specified expression to ...
As per MongoDB Blog documentation here By checking CPU, memory, and disk space metrics you make sure your MongoDB processes have sufficient resources available.
CPU - MongoDB will deliver better performance on faster CPUs. When
monitoring virtual machines, also monitor the virtual host that the
machines run on. Numbers like CPU ready time are of particular