DB file growing fast

XMLWordPrintableJSON

    • Type: Question
    • Resolution: Done
    • Priority: Blocker - P1
    • None
    • Affects Version/s: 2.2.0
    • Component/s: Sharding
    • None
    • Environment:
      production environment - Linux prd-mcms-db02 2.6.18-274.el5 x86_64 x86_64 GNU/Linux, 4 CPU 12GB memory; 60GB raid 10 disk * 2 VM server (shard server implementation), 8 app server running mongos connect to them
    • None
    • 0
    • None
    • None
    • None
    • None
    • None
    • None

      the file size grows fast that doesn't as our expect. data and index size under 20GB but is create over 60GB data files ever I purger old data from database day by day.
      and also found 2 shard server are unavailable. right now.

      [root@prd-mcms-db01 ~]# df -k
      Filesystem 1K-blocks Used Available Use% Mounted on
      /dev/sda8 988088 602524 334560 65% /

      /dev/vx/dsk/prd-mcms-db0102_dg01/mongo01vol
      62809702 29998500 30760744 50% /laxino/mongodb-vdb01

      /dev/vx/dsk/prd-mcms-db0102_dg02/mongo02vol
      62809702 47496155 14356697 77% /laxino/mongodb-vdb02

      mongos> show dbs
      admin (empty)
      config 0.1875GB
      fryatt_logms_production 0.203125GB
      fryatt_mcms_production 67.783203125GB
      test 0.203125GB
      mongos> sh.status()
      — Sharding Status —
      sharding version:

      { "_id" : 1, "version" : 3 }

      shards:

      { "_id" : "shard0000", "host" : "prd-mcms-vdb01.prod.laxigames.com:27020" } { "_id" : "shard0001", "host" : "prd-mcms-vdb01.prod.laxigames.com:27021" } { "_id" : "shard0002", "host" : "prd-mcms-vdb02.prod.laxigames.com:27023" } { "_id" : "shard0003", "host" : "prd-mcms-vdb02.prod.laxigames.com:27022" }

      databases:

      { "_id" : "admin", "partitioned" : false, "primary" : "config" } { "_id" : "fryatt_mcms_production", "partitioned" : true, "primary" : "shard0000" }

      fryatt_mcms_production.counter_data chunks:
      shard0001 136
      shard0003 133
      shard0000 134
      shard0002 211
      too many chunks to print, use verbose if you want to force print

      { "_id" : "test", "partitioned" : false, "primary" : "shard0001" } { "_id" : "admin --username admin --password XXXXXXXX", "partitioned" : false, "primary" : "shard0000" } { "_id" : "fryatt_logms_production", "partitioned" : false, "primary" : "shard0003" }

            Assignee:
            Ian Daniel (Inactive)
            Reporter:
            larry.loi
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated:
              Resolved: