Dex 0.5: Weighted Index Recommendations for MongoDB

Greetings, adventurers!

I am happy to announce the latest version of Dex, MongoLab's Index Bot. With version 0.5, we're declaring Dex halfway-there in terms of major features. The most important and convenient improvements in this version are Weighted Index Recommendations and support for MongoDB 2.2 log files.

If you haven't given Dex a try yet, check out the README and sudo pip install dex to get started. Even if you are already a Dex user, I highly recommend you revisit the readme, as Dex's output has changed.

Now when you run Dex, Dex compiles statistics for its recommendations, and provides those in its output. In contrast to prior versions, this gives a weight to each suggested index, clearly identifying the worst offenders.

Here's a rundown of major changes:

  • Weighted Recommendations - For each recommendation, Dex tallies the number of affected queries, the total time consumed by those queries, and the average time for a single query. Note that Dex keeps subtotal statistics for each unique query pattern that prompted a given recommendation. Subtotals are available in -verbose/-v mode only.
  • Output changes - We've modified Dex's output for the purposes of readability and convenience, in the following ways:
    • By default (i.e., not in --watch/-w mode), Dex no longer provides runtime output. Dex reads the entire profile collection or log file and then outputs one set of full results.
    • In --watch/-w mode, Dex still provides runtime output, periodically printing all recommendations with up-to-date statistics.
    • The shell command suggestion is removed from default output in favor of concise, weighted index recommendations. The shell command is still available in -verbose/-v output, but is no longer included by default.
  • Support for MongoDB 2.2 log files - While Dex has supported MongoDB 2.2 in --profile/-p mode, updates to Dex's log file regexes now support recent updates to the MongoDB log file line format.

For more information about Dex, check out Introducing Dex. As always, good luck out there!

Sincerely,
Eric@MongoLab

18 Responses to Dex 0.5: Weighted Index Recommendations for MongoDB

  1. best restaurants in oceanside 2017/03/26 at 4:30 pm #

    Other places new volcanic activity, in Southern California has created lots and lots of new basalt thus youthful that it’s scarcely begun to weather.

  2. what is motor club of america 2017/04/01 at 1:47 pm #

    468263 296380Extremely man or woman speeches require to seat giving observe into couples. Brand new sound system just before unnecessary individuals ought to always be mindful of usually senior general rule from public speaking, which is to be the mini. greatest man speaches 282957

  3. Best News Website in World 2017/04/06 at 2:58 pm #

    819458 698321Music began playing anytime I opened this web site, so irritating! 388564

  4. Best Best Online News in the World 2017/04/07 at 6:24 pm #

    571343 785122Im not that a lot of a internet reader to be honest but your blogs truly nice, keep it up! Ill go ahead and bookmark your website to come back in the future. All the greatest 1964

  5. Best Best Online News in the World 2017/04/07 at 10:16 pm #

    343577 940110Thanks for all your efforts that you have put in this. extremely interesting info . 100601

  6. Best Best Online News in the World 2017/04/07 at 10:44 pm #

    557532 988224My wife style of bogus body art were being quite unsafe. Mother worked with gun initial, following which they your lover snuck totally free upon an tattoo ink ink. I was certain the fact just about every ought to not be epidermal, due to the tattoo ink could be attracted from the entire body. make an own temporary tattoo 656051

  7. Best Best Online News in the World 2017/04/08 at 11:37 am #

    75654 680416Outstanding post, I think people should learn a lot from this web site its rattling user genial . 799172

  8. GVK Biosciences 2017/04/09 at 12:53 am #

    543409 379843Spot up for this write-up, I seriously believe this web site needs a whole lot a lot more consideration. Ill apt to be once a lot more to learn additional, appreciate your that information. 375718

  9. UK Chat Rooms 2017/04/09 at 12:57 am #

    893489 291800Cool post thanks! We believe your articles are fantastic and hope much more soon. We adore anything to do with word games/word play. 52232

  10. VideoJelly 2017/04/11 at 6:28 pm #

    836169 876050The site loading speed is incredible. 322015

  11. 45503 589135You made some first rate factors there. I seemed on the internet for the difficulty and located most people will go along with together with your website. 545782

  12. Lisette 2017/04/18 at 4:51 pm #

    hi!,I like your writing so a lot! percentage we communicate more about your post
    on AOL? I require a specialist on this space to solve my problem.
    May be that’s you! Taking a look ahead to see you.

  13. Dubai Escorts 2017/04/19 at 8:16 am #

    383502 695325Great task! 132990

  14. Switch Energy Supplier 2017/04/20 at 12:27 pm #

    30658 231855Possible need all types of led tourdates with some other fancy car applications. Numerous also offer historic packs and other requires to order take into your lending center, and for a holiday in upstate New York. ??? 947947

  15. garcinia cambogia liver 2017/04/22 at 2:36 pm #

    I’m gone to say to my little brother, that he should also visit this weblog on regular basis to get updated from
    latest information.

  16. chinese webwinkel 2017/04/23 at 1:46 pm #

    230987 83332quite very good put up, i in fact really like this internet internet site, maintain on it 862085

Trackbacks/Pingbacks

  1. Introducing Dex: the Index Bot for MongoDB queries recommendations | MongoLab - MongoDB Hosting - 2012/10/09

    […] Introducing Dex: the Index BotBy eric on 2012/06/19 in announcement, general, indexes, JSON, MongoDB, open source Tweet Share(update 2012-07-19: A new remote feature detailed here.) (update 2012-10-09: Version 0.5 detailed here.) […]

  2. Video presentation on Dex: the Index Bot for MongoDB | MongoLab - MongoDB Hosting - 2012/12/19

    […] Here’s Dex’s github page, and the latest version (0.5) announcement […]

Leave a Reply