查找mongo卡的原因

来源：互联网发布：php 前台框架编辑：程序博客网时间：2024/06/05 23:38

查看内存是否充足，io有没问题
vmstat 2
procs -----------memory---------- ---swap-- -----io---- --system-- -----cpu-----
r b   swpd   free   buff cache   si   so    bi    bo   in   cs us sy id wa st
3 1 93176 806176 970336 41895128    0    0   105    74    0    0 21 8 70 2 0
2 1 93176 790228 970336 41913288    0    0 6546    38 15604 6079 9 6 79 6 0

本主机为16和只要r值不超16都不会考虑cpu的瓶颈，si和so都为0证明也不是内存不足。b不为0证明有进程或线程在等待io，在这bi和bo的值相加大于1000考虑为io遇到瓶颈。

#sudo iotop
Total DISK READ: 9.66 M/s | Total DISK WRITE: 4.79 K/s
TID PRIO USER     DISK READ DISK WRITE SWAPIN     IO>    COMMAND
15673 be/4 mongodb     9.59 M/s    0.00 B/s 0.00 % 97.71 % mongod --config /mnt/raid5/server/env/m~aid5/server/env/mongodb/mongodb-keyfile
找出占io最多的程序为mongodb

查看mongo正在运行哪些命令
#mongo
rs01:PRIMARY> db.currentOp()
{
        "inprog" : [
                {
                        "desc" : "conn18039437",
                        "threadId" : "0xd17a340",
                        "connectionId" : 18039437,
                        "opid" : 214860931,
                        "active" : true,
                        "secs_running" : 112,
                        "microsecs_running" : NumberLong(112100983),
                        "op" : "query",
                        "ns" : "wechat.article",
                        "query" : {
                                "count" : "article",
                                "query" : {
                                        "body.content" : {
                                                "$ne" : ""
                                        },
                                        "idx" : {
                                                "$exists" : 1
                                        },
                                        "read" : {
                                                "$exists" : 1
                                        },
                                        "body.title" : {
                                                "$ne" : ""
                                        },
                                        "body.subtitle" : {
                                                "$ne" : ""
                                        },
                                        "likes" : {
                                                "$exists" : 1
                                        },
                                        "popTime" : {
                                                "$exists" : 1
                                        },
                                        "body.publishTime" : {
                                                "$lte" : 1470585600,
                                                "$gte" : 1462723200
                                        },
                                        "subscribeRobotId" : {
                                                "$ne" : ""
                                        }
                                },
                                "fields" : {
                                        "body.content" : 1,
                                        "idx" : 1,
                                        "read" : 1,
                                        "body.title" : 1,
                                        "body.subtitle" : 1,
                                        "likes" : 1,
                                        "popTime" : 1,
                                        "body.publishTime" : 1,
                                        "subscribeRobotId" : 1
                                }
                        },
                        "planSummary" : "IXSCAN { body.publishTime: 1.0 }",
                        "client" : "192.168.10.110:59570",
                        "numYields" : 10354,
                        "locks" : {

                        },
                        "waitingForLock" : false,
                        "lockStats" : {
                                "Global" : {
                                        "acquireCount" : {
                                                "r" : NumberLong(20708)
                                        }
                                },
                                "MMAPV1Journal" : {
                                        "acquireCount" : {
                                                "r" : NumberLong(10354)
                                        },
                                        "acquireWaitCount" : {
                                                "r" : NumberLong(1)
                                        },
                                        "timeAcquiringMicros" : {
                                                "r" : NumberLong(2012)
                                        }
                                },
                                "Database" : {
                                        "acquireCount" : {
                                                "r" : NumberLong(10354)
                                        }
                                },
                                "Collection" : {
                                        "acquireCount" : {
                                                "R" : NumberLong(10354)
                                        }
                                }
                        }
                },
                {
                        "desc" : "conn18039063",
                        "threadId" : "0xd17c080",
                        "connectionId" : 18039063,
                        "opid" : 214861952,
                        "active" : true,
                        "secs_running" : 1,
                        "microsecs_running" : NumberLong(1607931),
                        "op" : "getmore",
                        "ns" : "local.oplog.rs",
                        "query" : {
                                "ts" : {
                                        "$gte" : Timestamp(1470899100, 1)
                                }
                        },
                        "client" : "192.168.10.116:43553",
                        "numYields" : 0,
                        "locks" : {

                        },
                        "waitingForLock" : false,
                        "lockStats" : {
                                "Global" : {
                                        "acquireCount" : {
                                                "r" : NumberLong(4)
                                        }
                                },
                                "MMAPV1Journal" : {
                                        "acquireCount" : {
                                                "r" : NumberLong(2)
                                        }
                                },
                                "Database" : {
                                        "acquireCount" : {
                                                "r" : NumberLong(2)
                                        }
                                },
                                "oplog" : {
                                        "acquireCount" : {
                                                "R" : NumberLong(2)
                                        }
                                }
                        }
                },
                {
                        "desc" : "conn18039061",
                        "threadId" : "0xd17b520",
                        "connectionId" : 18039061,
                        "opid" : 214861953,
                        "active" : true,
                        "secs_running" : 1,
                        "microsecs_running" : NumberLong(1607875),
                        "op" : "getmore",
                        "ns" : "local.oplog.rs",
                        "query" : {
                                "ts" : {
                                        "$gte" : Timestamp(1470899100, 1)
                                }
                        },
                        "client" : "192.168.10.112:47002",
                        "numYields" : 0,
                        "locks" : {

                        },
                        "waitingForLock" : false,
                        "lockStats" : {
                                "Global" : {
                                        "acquireCount" : {
                                                "r" : NumberLong(4)
                                        }
                                },
                                "MMAPV1Journal" : {
                                        "acquireCount" : {
                                                "r" : NumberLong(2)
                                        }
                                },
                                "Database" : {
                                        "acquireCount" : {
                                                "r" : NumberLong(2)
                                        }
                                },
                                "oplog" : {
                                        "acquireCount" : {
                                                "R" : NumberLong(2)
                                        }
                                }
                        }
                }
        ]
}

说明：
"secs_running" : 112 表示操作运行的时间
"op" : "query"   为查询操作
"ns" : "wechat.article" 操作的数据库和表
"client" : "192.168.10.110:59570" 建立的连接netstat可查询
"opid" : 214860931 该命令操作的id，可通过killOp(214860931 )把该操作关闭

rs01:PRIMARY> db.killOp(214860931) 关闭 opid为214860931的操作

阅读全文

0 0