Uploaded image for project: 'Core Server'
  1. Core Server
  2. SERVER-6847

one file per table (or files per table)

    XMLWordPrintableJSON

Details

    • Icon: New Feature New Feature
    • Resolution: Done
    • Icon: Major - P3 Major - P3
    • None
    • None
    • Internal Code
    • None
    • any
    • Storage Execution
    • Fully Compatible

    Description

      Currently, we have one set of files for a database.
      Doing a database repair on 1 TB of data can take a long time, as well as double diskspace required.

      Operations on one table should not affect the other in a database.
      Locking a small table up because a big table needs repaired hurts.
      Also, there may be times where a big table becomes emptied and you would like to reclaim the space of TableA without locking TableB.
      Corrupted data might only affect one table, and repairing one table should not affect other tables ideally.

      So, a little history. For MySQL, one-file-per-table was resisted a lot until it finally got pushed in, and it made a BIG difference. You could reclaim diskspace for a specific table without having to reload your entire database to free up the diskspace. one-file-per-table as a huge benefit to operations.

      Something like this for Mongo would be great.

      The other solution is to do one table per database, but practically that just isn't going to happen and programmers don't think like that.

      Attachments

        Activity

          People

            backlog-server-execution Backlog - Storage Execution Team
            mark.nielsen@reputation.com mark nielsen
            Votes:
            2 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: