Skip to content

Atlas Info and loginfo

Jump to bottom
Ken Chen edited this page Nov 3, 2020 · 5 revisions

Atlas Info and loginfo

Keyhole can retrieve MongoDB Atlas summaries and analyze mongo logs of a user.

Print Atlas Clusters Summary

$ export ATLAS_AUTH="username:066077bd-8e77-6b88-be88-8a3b88a50835"
$ keyhole --info "atlas://${ATLAS_AUTH}"
- Group: 5b75e8da0bd66b7ea13217a1
  - cluster name: keyhole
    - 4.0.6, REPLICASET, mongodb+srv://keyhole-jgtm2.mongodb.net
    - Hosts:
      - keyhole-shard-00-00-jgtm2.mongodb.net (REPLICA_SECONDARY)
      - keyhole-shard-00-01-jgtm2.mongodb.net (REPLICA_SECONDARY)
      - keyhole-shard-00-02-jgtm2.mongodb.net (REPLICA_PRIMARY)


- Group: 5b5f3d10c0c6e37993839baf
  - cluster name: Cluster0
    - 4.0.6, REPLICASET, mongodb+srv://cluster0-v7due.gcp.mongodb.net
    - Hosts:
      - cluster0-shard-00-00-v7due.gcp.mongodb.net (REPLICA_PRIMARY)
      - cluster0-shard-00-01-v7due.gcp.mongodb.net (REPLICA_SECONDARY)
      - cluster0-shard-00-02-v7due.gcp.mongodb.net (REPLICA_SECONDARY)


- Group: 5b1577584e6581749a476b96
  - cluster name: Cluster0
    - 4.0.6, REPLICASET, mongodb+srv://cluster0-grbtr.mongodb.net
    - Hosts:
      - cluster0-shard-00-00-grbtr.mongodb.net (REPLICA_SECONDARY)
      - cluster0-shard-00-01-grbtr.mongodb.net (REPLICA_SECONDARY)
      - cluster0-shard-00-02-grbtr.mongodb.net (REPLICA_PRIMARY)


Usage: keyhole --loginfo atlas://{public_key}:{private_key}@{group_id}/{cluster_name}"

Analyze Atlas Clusters Logs

Usage: keyhole --loginfo "atlas://{ATLAS_AUTH}@{ATLAS_GROUP}/{CLUSTER_NAME}[?startDate=yyyy-mm-dd&endDate=yyyy-mm-dd]"

    where yyyy-mm-dd is optional and default is up to latest 48 hours from now.

$ export ATLAS_GROUP="5b75e8da0bd66b7ea13217a1"
$ export CLUSTER_NAME="keyhole"
$ keyhole --loginfo "atlas://${ATLAS_AUTH}@${ATLAS_GROUP}/${CLUSTER_NAME}"
=> processing ./mongodb.log.keyhole-shard-00-00-jgtm2.mongodb.net.gz
+---------+--------+------+--------+------+---------------------------------+--------------------------------------------------------------+
| Command |COLLSCAN|avg ms| max ms | Count| Namespace                       | Query Pattern                                                |
|---------+--------+------+--------+------+---------------------------------+--------------------------------------------------------------|
+---------+--------+------+--------+------+---------------------------------+--------------------------------------------------------------+

=> processing ./mongodb.log.keyhole-shard-00-01-jgtm2.mongodb.net.gz
+---------+--------+------+--------+------+---------------------------------+--------------------------------------------------------------+
| Command |COLLSCAN|avg ms| max ms | Count| Namespace                       | Query Pattern                                                |
|---------+--------+------+--------+------+---------------------------------+--------------------------------------------------------------|
+---------+--------+------+--------+------+---------------------------------+--------------------------------------------------------------+

=> processing ./mongodb.log.keyhole-shard-00-02-jgtm2.mongodb.net.gz
+---------+--------+------+--------+------+---------------------------------+--------------------------------------------------------------+
| Command |COLLSCAN|avg ms| max ms | Count| Namespace                       | Query Pattern                                                |
|---------+--------+------+--------+------+---------------------------------+--------------------------------------------------------------|
|aggregate COLLSCAN    363      363      1 keyhole.favorites                 {}                                                            |
|aggregate COLLSCAN    125      125      1 keyhole.cars                      {color:1, style:1, year: {$lt:1, $gt:1}}                      |
+---------+--------+------+--------+------+---------------------------------+--------------------------------------------------------------+
Clone this wiki locally