Databases
StackOverflow2013
Postsdbo
POIncreased in number commands in MongoDB
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POIncreased in number commands in MongoDB
    text
    copied!<p>An increase in the number of visitors generates an increase in the number of commands issued on MongoDB. This makes the database slow and whole system unusable. Mongostat looks like so during those peak times:</p> <pre><code>insert query update delete getmore command flushes mapped vsize res faults locked % idx miss % qr|qw ar|aw netIn netOut conn time 0 266 0 0 3 19 0 58.7g 119g 13g 2 0 0 0|0 0|0 47k 1m 167 14:24:30 0 308 4 0 0 8 0 58.7g 119g 13g 5 0.7 0 0|0 0|0 54k 880k 167 14:24:31 0 177 3 0 0 34 0 58.7g 119g 13g 0 0.5 0 0|0 0|0 49k 559k 173 14:24:32 0 73 2 0 0 8 0 58.7g 119g 13g 0 0.3 0 0|0 0|0 21k 288k 174 14:24:33 0 201 5 0 0 27 0 58.7g 119g 13g 2 0.5 0 0|0 1|0 51k 639k 167 14:24:34 0 232 4 0 0 9 0 58.7g 119g 13g 1 0.3 0 0|0 0|0 44k 456k 167 14:24:35 0 102 2 0 0 109 0 58.7g 119g 13.1g 0 0.3 0 0|0 0|0 33k 269k 193 14:24:36 0 265 3 0 0 103 0 58.7g 119g 13.1g 0 0.5 0 0|0 0|0 76k 714k 178 14:24:37 1 277 4 0 0 16 0 58.7g 119g 13.1g 2 0.5 0 0|0 0|0 71k 501k 180 14:24:38 0 237 3 0 0 92 0 58.7g 119g 13.1g 0 0.4 0 0|0 0|0 54k 670k 201 14:24:39 </code></pre> <p>The problem is: I can't find out the source of those commands in my code. I've tried turning on full profiling (logging ALL the queries), but couldn't find any of those commands. I see some, but only few per second, usual stuff. Sometimes there are 100-200 commands per second for few minutes, but all I see in logs and profiler is authentication commands (this is php scripts reconnecting back after they have died out with time out).</p> <p>How can I debug this issue and find the source of too many commands?</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload