Find and kill slow running queries in MongoDB

Posted by in DevOps, NoSQL

In Mongo, or more generally in any data storage engine, queries or updates that take longer than expected to run can be caused by many reasons: – Slow network – Wrong schema design (we all have seen the famous all-in-one table…) – Wrong database design (“let’s store 100To of data in a standalone mongod!”) – Bad partitioning (Hbase table with 200 regions with 2MB of data) – Lack of useful indexes – No statistics – Incorrect hardware sizing (in 99.999%, the memory…) – Missing or wrong configuration (aka the default…read more