{"id":48575,"date":"2019-02-05T13:50:17","date_gmt":"2019-02-05T08:20:17","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=48575"},"modified":"2021-05-09T13:07:19","modified_gmt":"2021-05-09T07:37:19","slug":"mongodb-capped-collection","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/mongodb-capped-collection\/","title":{"rendered":"MongoDB Capped Collection – Create, Check, & Uncapping the Capped"},"content":{"rendered":"

Hope, you enjoyed our last tutorial of MongoDB Auto Increment Sequence. Now, we will be looking at MongoDB capped collection. These are fixed collection, which supports high throughput operations.<\/p>\n

On the basis of an insertion order, we can insert and retrieve a document. Moreover, we will learn how to create, convert, check and query a capped collection in MongoDB.<\/p>\n

At last, we will see what are the pros and cons with applications of MongoDB Capped Collection.<\/p>\n

\"What<\/a>

MongoDB Capped Collection – Create, Check, Convert, Uncapping the Capped<\/p><\/div>\n

What is MongoDB Capped Collections?<\/h2>\n

These are fixed collection, which supports high throughput operations. On the basis of an insertion order, we can insert and retrieve a document.<\/p>\n

They work similar to circular buffers: once a collection file is allocated space, it makes room for new documents by overwriting the oldest documents in the collection.<\/p>\n

It means that it starts deleting the oldest document in the collection without providing any explicit commands. Capped collection restrict updates if the updates result in increased document size.<\/p>\n

It stores documents in the order of disk storage, so it keeps a check on the document size as it should not increase the size allocated to disk. It is best for storing log information, cache data or any other high volume data.<\/p>\n

i. How to Create Capped Collection in MongoDB?<\/h3>\n

To create a MongoDB capped collection, we use the normal createCollection command with a capped option as true and specifying the maximum size of the collection in bytes.<\/p>\n

>db.createCollection(\"cappedLogCollection\",{capped:true,size:10000})<\/pre>\n
Along with is, we can limit the number of documents in the collection using max parameter-<\/p>\n
>db.createCollection(\"cappedLogCollection\",{capped:true,size:10000,max:1000})<\/pre>\n
ii. How to Check Collection is Capped or not?<\/h3>\n
If you want to check whether a collection is capped or not, then use the following command:<\/p>\n
>db.cappedLogCollection.isCapped()<\/pre>\n
iii. How to Convert a Collection to Capped?<\/h3>\n
If there is an existing collection which you want to change it to capped, you can do it by using the following command:<\/p>\n
>db.runCommand({\"convertToCapped\":\"posts\",size:10000})<\/pre>\n
iv. How to find Query on Capped Collection in MongoDB?<\/h3>\n
Generally, a find query on a capped collection will display results in insertion order. But if you want the documents in reverse order, use sort command as shown below:<\/p>\n
>db.cappedLogCollection.find().sort({$natural:-1}<\/pre>\n
Facts about MongoDB Capped Collection<\/h2>\n
Following are some points to remember about Capped Collections in MongoDB:<\/p>\n
    \n
  1. You cannot delete documents from a capped collection. It can only be deleted automatically upon insertion of new documents when the allocated size to the collection has been exhausted.<\/li>\n
  2. After reading the documents from a capped collection, MongoDB returns the same document in the order which they were present on disk. Because of this, it makes the read operations to execute very fast.<\/li>\n
  3. Update operation has one restriction with itself. If the update in collection results in the increase of the document\u2019s size, then it will not update that document in the collection as each document has it\u2019s fixed size during the first time insertion into the capped collection.<\/li>\n<\/ol>\n
     <\/p>\n
    How to Uncapped a MongoDB Capped Collection?<\/h2>\n
    Here we will be using two commands that are mongodump<\/strong> and mongorestore<\/strong>.<\/p>\n
    i. Dump the capped collection<\/h4>\n
    First of all, we will dump the capped collection.<\/p>\n
    PROD root@myhost:\/data\/uncap # mongodump -d mydb -c myexample\r\nconnected to: 127.0.0.1:27017\r\nSun Feb 5 00:02:28.879 DATABASE: mydb to dump\/mydb\r\nSun Feb 5 00:02:28.880 mydb.myexample to dump\/mydb\/myexample.bson\r\nSun Feb 5 00:02:31.004 Collection File Writing Progress: 868400\/67569879 1% (objects)\r\n...\r\nSun Feb 5 00:24:13.004 Collection File Writing Progress: 67480900\/67569879 99% (objects)\r\nSun Feb 5 00:24:14.203 67569879 objects\r\nSun Feb 5 00:24:14.203 Metadata for mydb.myexample to dump\/mydb\/myexample.metadata.json<\/pre>\n
    ii. Metafile in JSON format<\/h4>\n
    Now, dump also includes a metadata file in JSON format.<\/p>\n
    cat dump\/mydb\/myexample.metadata.json\r\n  {\r\n    \"options\": {\r\n    \"capped\": true,\r\n    \"size\": 107374182400\r\n   },\r\n    \"indexes\": [\r\n      {\r\n        \"v\": 1,\r\n        \"key\": {\r\n        \"_id\": 1\r\n      },\r\n      \"ns\": \"mydb.mycoll\",\r\n      \"name\": \"_id_\"\r\n    }\r\n  ]\r\n}<\/pre>\n
    iii. Remove “option” section<\/h4>\n
    Now after this remove the \u201coptions\u201d section that displays the capped collection<\/a> size.<\/p>\n
    PROD root@myhost:\/data\/uncap # mongorestore -d mydb -c myexample_tmp dump\/mydb\/myexample.bson\r\nconnected to: 127.0.0.1:27018\r\nSun Feb 5 00:29:41.473 dump\/mydb\/myexample.bson\r\nSun Feb 5 00:29:41.473 going into namespace [mydb.myexample_tmp]\r\nSun Feb 5 00:29:44.060 Progress: 51202216\/106169934834 0% (bytes)\r\nSun Feb 5 00:29:47.007 Progress: 106497873\/106169934834 0% (bytes)\r\nSun Feb 5 01:57:19.065 Progress: 106159626025\/106169934834 99% (bytes)\r\n67569879 objects found\r\nSun Feb 5 01:57:19.637 Creating index: { key: { _id: 1 }, ns: \"mydb.myexample_tmp\", name: \"_id_\" }<\/pre>\n
    iv. Creates indices for us<\/h4>\n
    After this it automatically creates indices for us. Check it after this.<\/p>\n
    rs-prod:PRIMARY> db.myexample.isCapped()\r\ntrue\r\nrs-prod:PRIMARY> db.myexample_tmp.isCapped()\r\nfalse\r\nrs-prod:PRIMARY> db.myexample.count()\r\n9876543210\r\nrs-prod:PRIMARY> db.myexample_tmp.count()\r\n9876543210<\/pre>\n
    v. Drop old collection and renaming<\/h4>\n
    After this drop the old collection and rename the new collection.<\/p>\n
    db.myexample.drop()\r\n\r\ndb.myexample_tmp.renameCollection('myexample')\r\ndb.myexample.count()\r\n9876543210<\/pre>\n
    Advantages of Capped Collections<\/h2>\n
    These are the some benefits:<\/p>\n
      \n
    • Queries don\u2019t need an index to return documents in insertion order due to which it provides higher insertion throughput.<\/li>\n
    • Capped collections allow updates that fit the original document size, which gives us assurance that the document does not change its location on disk.<\/li>\n
    • It is useful to keep log files.<\/li>\n<\/ul>\n
      Disadvantages of Capped Collections<\/h2>\n
      Following are the limitations of capped collections in MongoDB:<\/p>\n
        \n
      • If updating a document exceeds the original size of a collection, the update operation fails.<\/li>\n<\/ul>\n
          \n
        • It is not possible to delete documents from a capped collection. To remove all records from a capped collection, use the following command:<\/li>\n<\/ul>\n
          { emptycapped: nameOfCollection }<\/pre>\n
            \n
          • It is not possible to shard a capped collection.<\/li>\n<\/ul>\n
            Application of Capped Collection<\/h2>\n
            Some of the applications of a capped collection are as follows:<\/p>\n
              \n
            • Application logging<\/li>\n
            • History<\/li>\n
            • Audit information<\/li>\n<\/ul>\n
              Summary<\/h2>\n
              Hence, we have studied all about MongoDB capped collections – how to create, convert, check, advantages, disadvantages. At last we studied about\u00a0mongodump<\/strong> and mongorestore <\/strong>are the two commands use for uncapping the collection.<\/p>\n
              Hope. you find it useful. If you have any query, feel free to share with us. Surely, we will get back to you!
              Hope, you enjoyed our last tutorial of MongoDB Auto Increment Sequence. Now, we will be looking at MongoDB capped collection. These are fixed collection, which supports high throughput operations. On the basis of an...<\/p>\n","protected":false},"author":6,"featured_media":48583,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[38],"tags":[18693,18690,18692,18689,18691,18695,18696,18694],"class_list":["post-48575","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mongodb","tag-applications-of-capped-collection","tag-capped-collection-in-mongodb","tag-capped-collection-limitations","tag-mongodb-capped-collection","tag-mongodb-capped-collection-benefits","tag-mongodump","tag-mongorestore","tag-uncapped-a-capped-collection"],"yoast_head":"\nMongoDB Capped Collection - Create, Check, & Uncapping the Capped - DataFlair<\/title>\n<meta name=\"description\" content=\"MongoDB Capped Collection tutorial- how to create, convert, check, advantages, disadvantages of cap collection, How to uncapped the capped collection\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/data-flair.training\/blogs\/mongodb-capped-collection\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MongoDB Capped Collection - Create, Check, & Uncapping the Capped - DataFlair\" \/>\n<meta property=\"og:description\" content=\"MongoDB Capped Collection tutorial- how to create, convert, check, advantages, disadvantages of cap collection, How to uncapped the capped collection\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/mongodb-capped-collection\/\" \/>\n<meta property=\"og:site_name\" content=\"DataFlair\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataFlairWS\/\" \/>\n<meta property=\"article:published_time\" content=\"2019-02-05T08:20:17+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-05-09T07:37:19+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/02\/MongoDB-Capped-Collection-01.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"DataFlair Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:site\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"DataFlair Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"MongoDB Capped Collection - Create, Check, & Uncapping the Capped - DataFlair","description":"MongoDB Capped Collection tutorial- how to create, convert, check, advantages, disadvantages of cap collection, How to uncapped the capped collection","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/data-flair.training\/blogs\/mongodb-capped-collection\/","og_locale":"en_US","og_type":"article","og_title":"MongoDB Capped Collection - Create, Check, & Uncapping the Capped - DataFlair","og_description":"MongoDB Capped Collection tutorial- how to create, convert, check, advantages, disadvantages of cap collection, How to uncapped the capped collection","og_url":"https:\/\/data-flair.training\/blogs\/mongodb-capped-collection\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2019-02-05T08:20:17+00:00","article_modified_time":"2021-05-09T07:37:19+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/02\/MongoDB-Capped-Collection-01.jpg","type":"image\/jpeg"}],"author":"DataFlair Team","twitter_card":"summary_large_image","twitter_creator":"@DataFlairWS","twitter_site":"@DataFlairWS","twitter_misc":{"Written by":"DataFlair Team","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/data-flair.training\/blogs\/mongodb-capped-collection\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/mongodb-capped-collection\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/2c58ecb4f73a39f0ef993f1ddfcd7b89"},"headline":"MongoDB Capped Collection – Create, Check, & Uncapping the Capped","datePublished":"2019-02-05T08:20:17+00:00","dateModified":"2021-05-09T07:37:19+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/mongodb-capped-collection\/"},"wordCount":803,"commentCount":0,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/mongodb-capped-collection\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/02\/MongoDB-Capped-Collection-01.jpg","keywords":["Applications of Capped collection","Capped Collection in MongoDB","Capped Collection limitations","MongoDB Capped Collection","MongoDB Capped Collection benefits","mongodump","mongorestore","Uncapped a Capped Collection"],"articleSection":["MongoDB Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/mongodb-capped-collection\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/mongodb-capped-collection\/","url":"https:\/\/data-flair.training\/blogs\/mongodb-capped-collection\/","name":"MongoDB Capped Collection - Create, Check, & Uncapping the Capped - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/mongodb-capped-collection\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/mongodb-capped-collection\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/02\/MongoDB-Capped-Collection-01.jpg","datePublished":"2019-02-05T08:20:17+00:00","dateModified":"2021-05-09T07:37:19+00:00","description":"MongoDB Capped Collection tutorial- how to create, convert, check, advantages, disadvantages of cap collection, How to uncapped the capped collection","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/mongodb-capped-collection\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/mongodb-capped-collection\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/mongodb-capped-collection\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/02\/MongoDB-Capped-Collection-01.jpg","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/02\/MongoDB-Capped-Collection-01.jpg","width":1200,"height":628,"caption":"MongoDB Capped Collection - Create, Check, Convert, Uncapping the Capped"},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/mongodb-capped-collection\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog Home","item":"https:\/\/data-flair.training\/blogs\/"},{"@type":"ListItem","position":2,"name":"MongoDB Tutorials","item":"https:\/\/data-flair.training\/blogs\/category\/mongodb\/"},{"@type":"ListItem","position":3,"name":"MongoDB Capped Collection – Create, Check, & Uncapping the Capped"}]},{"@type":"WebSite","@id":"https:\/\/data-flair.training\/blogs\/#website","url":"https:\/\/data-flair.training\/blogs\/","name":"DataFlair","description":"Learn Today. Lead Tomorrow.","publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/data-flair.training\/blogs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/data-flair.training\/blogs\/#organization","name":"DataFlair","url":"https:\/\/data-flair.training\/blogs\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","width":106,"height":48,"caption":"DataFlair"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataFlairWS\/","https:\/\/x.com\/DataFlairWS","https:\/\/www.linkedin.com\/company\/dataflair-web-services-pvt-ltd\/","https:\/\/www.youtube.com\/user\/DataFlairWS"]},{"@type":"Person","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/2c58ecb4f73a39f0ef993f1ddfcd7b89","name":"DataFlair Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","caption":"DataFlair Team"},"description":"The DataFlair Team provides industry-driven content on programming, Java, Python, C++, DSA, AI, ML, data Science, Android, Flutter, MERN, Web Development, and technology. Our expert educators focus on delivering value-packed, easy-to-follow resources for tech enthusiasts and professionals.","url":"https:\/\/data-flair.training\/blogs\/author\/dfteam2\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/48575","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/comments?post=48575"}],"version-history":[{"count":4,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/48575\/revisions"}],"predecessor-version":[{"id":92762,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/48575\/revisions\/92762"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/48583"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=48575"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=48575"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=48575"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}