• More options to select which db to compact

    By Jean-Baptiste ROBERT 1 decade ago

    Hello,

    DominoDefrag is great, But I think it could be even better if we could tell it to compact Db that have more than X MB that can be recovered as freespace instead of percent of total db Size. And if that parameter wasn't used to generate freespace.


    Let me explain :

    I manage a lot of domino servers. Some of them are quiet busy providing mailDbs for more than 3000 users.

    The mail DBs are very differents. They range from 20MB up to 6GB.

    If I set up compact to start from 10% and domino defrag to generate 20MB max freespace, It means that my 6GB DBs will only be compacted by Domino Defrag if there is more than 600MB of garbage to recover. On the other Side, for a 50 MB Dbs, it means that DominoDefrag will compact the Db if 2MB can be recovered. But in that case, it will generate only 2MB of freespace. 2MB Might be just one mail.

    So, with a parameter set to 10%, Big DBs while be rarely Compacted. Which means a lot of GB are wasted on the server.

    Small DBs got very few freespace, making it nearly useless.


    If I decide to set the compact to start from 1%, it will solve my problem with Big DBs, but increase it with small ones.

    It would be great if we could have two independent params for compact and for freespace, and to allow both of them to be set as percent or MB.

    exemple :

    DominoDefrag_CompactStart=1MB <= would mean to compact any database in which there is more than 1MB to recover

    DominoDefrag_CompactStart=1% <= would mean to compact any database in which there is more than 1% of the db Size to recover (Not sure it is needed since we can specify -S 1 at the command line level)

    DominoDefrag_FreeSpace=10% <= would tell dominodefrag to generate 10% of freespace

    DominoDefrag_FreeSpace=10MB <= would tell dominoDefrag to generate 10MB of freespace

    Optionnaly, you could keep DominoDefrag_FreespaceMaxMB to specify an upper limit if percents have been specified in DominoDefrag_FreeSpace


    Let me know your feeling about this.


    Regards,

    • I agree with your ideas (please send email address)

      By Andrew Luder 1 decade ago

      Hi Jean-Baptiste,

      I agree with your ideas below. Please me send your email address to andrewluder@notestools.com so I can send you a test version 3.3 before next weekend. Wont be releasing production version till early Jan.

      • DominoDefrag_CompactStart=1MB <= would mean to compact any database in which there is more than 1MB to recover
      • DominoDefrag_CompactStart=1% <= would mean to compact any database in which there is more than 1% of the db Size to recover (Not sure it is needed since we can specify -S 1 at the command line level)
      • DominoDefrag_FreeSpace=10% <= would tell dominodefrag to generate 10% of freespace
      • DominoDefrag_FreeSpace=10MB <= would tell dominoDefrag to generate 10MB of freespace


      Also will change DominoDefrag_FreespaceMaxMB functionality to regulate the total DominoDefrag_FreeSpace generated for all databases. For example, ensures that when either DominoDefrag_FreeSpace=20MB or DominoDefrag_FreeSpace=20% that wont exceed the 20000MB disk space left on the data volume when there's mail databases of existing quantity and size of 997 x 100MB and 3 x 1000MB. If exceeds DominoDefrag_FreespaceMaxMB=20000 then no more freespace will be generated for any database.

      Regards