We experienced wasted disk IO from the MySQL query optimizer a
few years back and fixed it via FORCE INDEX hints. I think I am experiencing
wasted disk IO from the MongoDB optimizer during recent tests
with the insert benchmark.
The problem with MySQL requires a query for which more than one index can be used. The problem query was a single table SELECT statement. The optimizer must figure out the best index and calls the …