MongoDB连接数修改

àì夳堔傛蜴生んèń 2024-02-18 19:51 16阅读 0赞

查看最大连接数

mongos> db.serverStatus().connections;

\{ "current" : 704, "available" : 51724, "totalCreated" : 172824 \}

**或**

**mongos> db.serverStatus().connections  
\{ "current" : 1, "available" : 818, "totalCreated" : 39 \}  
mongos>**

途中available显示818少了一个，表示空闲的。current表示已经占用了的连接数，两数一加就等于819，如果我现在在连接一个，那么available就是817，current就是2。819个连接数对于一般的站点我认为已经够用，并且都是现连现取现断。

但这个连接数也可以修改，只要在启动的时候加入–maxConns=2000即可。如果再次查询最大连接数发现没有增加到2000，那么其实是Linux默认进程能打开最大文件数有关，可以通过ulimit解决。

再查看最大连接数：

<table style="font-size:12px;margin-left:-20px;border:none;padding:0px;margin-right:0px;margin-bottom:0px;margin-top:0px;width:auto;background:none;border-spacing:0px;table-layout:auto;"> 
 <tbody> 
  <tr style="background:0px center;padding:0px;border-style:none;vertical-align:top;margin:0px;"> 
   <td style="border-bottom:0px;border-top:0px;border-left:0px;font-family:'Courier New', monospace;vertical-align:top;padding:0px;margin:0px;background:rgb(0,0,0);color:rgb(137,137,137);"> 
    <div style="background:0px center;border:0px;padding:0px;margin:0px;white-space:nowrap;line-height:20px;"> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;">
       1 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;text-align:center;height:inherit;">
       2 
     </div> 
    </div></td> 
   <td style="border-width:0px;background:0px center;width:815px;font-family:'Courier New', monospace;vertical-align:top;padding:0px;margin:0px;"> 
    <div style="padding:0px;margin:0px;white-space:pre;background:none;border:none;color:rgb(255,255,255);line-height:20px;"> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;height:inherit;"> 
      <span style="font-family:inherit;height:inherit;color:rgb(255,215,0);">&gt;</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);"> </span> 
      <span style="font-family:inherit;height:inherit;color:rgb(171,252,4);">db</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(194,151,52);">.serverStatus</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(201,210,209);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(201,210,209);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(194,151,52);">.connections</span> 
     </div> 
     <div style="font-family:inherit;background:0px center;border:0px;padding:0px 5px;margin:0px;height:inherit;"> 
      <span style="font-family:inherit;height:inherit;color:rgb(201,210,209);">{ </span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);"> </span> 
      <span style="font-family:inherit;height:inherit;color:rgb(178,175,117);">"current"</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);"> </span> 
      <span style="font-family:inherit;height:inherit;color:rgb(255,215,0);">:</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);"> </span> 
      <span style="font-family:inherit;height:inherit;color:rgb(235,91,4);">1</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(201,210,209);">,</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);"> </span> 
      <span style="font-family:inherit;height:inherit;color:rgb(178,175,117);">"available"</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);"> </span> 
      <span style="font-family:inherit;height:inherit;color:rgb(255,215,0);">:</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);"> </span> 
      <span style="font-family:inherit;height:inherit;color:rgb(235,91,4);">1999</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(201,210,209);">,</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);"> </span> 
      <span style="font-family:inherit;height:inherit;color:rgb(178,175,117);">"totalCreated"</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);"> </span> 
      <span style="font-family:inherit;height:inherit;color:rgb(255,215,0);">:</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);"> </span> 
      <span style="font-family:inherit;height:inherit;color:rgb(194,151,52);">NumberLong</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(201,210,209);">(</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(235,91,4);">1</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(201,210,209);">)</span> 
      <span style="font-family:inherit;height:inherit;color:rgb(0,111,224);"> </span> 
      <span style="font-family:inherit;height:inherit;color:rgb(201,210,209);">}</span> 
     </div> 
    </div></td> 
  </tr> 
 </tbody> 
</table>

查看当前进程及执行语句

杀掉进程

先执行db.currentOp()获取进程号，类似ps -ef。

查看最近错误