Get the App
SLTechnology News&Howtos  ›  Database  › 

Realization of currentOp timing acquisition by MongoDB

Shulou Source: shulou.com Published: 2022-06-01 18:40:23 11月17日 Update

Problem description:

When analyzing the performance problems in the production environment, it is often impossible to start because there is no real-time basis. Then the author captures db.currentOp () to the file and serves as a scheduled task for subsequent analysis.

Solution:

Step 1: Shell script records db.currentOp ()

1. Create a folder

Mkdir currentOp

two。 Create currentOp.sh

#! / bin/shMONGO=/usr/bin/mongoDATE=$ (date +% Y%m%d%H%M) CURRENTOPFILE=/home/xucy/currentOp/$DATE$MONGO admin-uxucy-pPassw0rd-- eval "rs.slaveOk (); printjson (db.currentOp ());" > $CURRENTOPFILE 2 > & 1LOCATION=/home/xucy/currentOp/find $LOCATION-mtime + 1-type f | xargs rm-f

Step 2: join the Crontab scheduled task

Crontab-eBay home/xucy/currentOp.sh 5 * / bin/sh / home/xucy/currentOp.sh > / dev/null 2 > & 1

Tags: Tasks files steps problems analysis real-time performance folders methods nowhere to start environment author script production Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno vpn Huawei Shulou Technology Microsoft Apple