Uploaded image for project: 'WiredTiger'
  1. WiredTiger
  2. WT-7362

Allow batching multiple table alterations for the same config change

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Open
    • Priority: Major - P3
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: Backlog
    • Component/s: None
    • Labels:
      None
    • Case:

      Description

      On startup recovery in MDB, there are times when we need to modify the table log settings. It's known that this is an expensive operation as WT will fsync after a WT_SESSION::alter() call on each table.

      We've had complaints from users that have a large number of WT files about long startup times when the table log changes need to take place.

      In hopes of improving this, I was wondering how feasible it would be to have WT allow batching multiple table alterations for the same config change. Right now we can only alter one table at a time in WT_SESSION::alter(). But I'm hoping that allowing batching of these changes will improve things and allow us to fsync less often.

        Attachments

          Activity

            People

            Assignee:
            backlog-server-storage-engines Backlog - Storage Engines Team
            Reporter:
            gregory.wlodarek Gregory Wlodarek
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Dates

              Created:
              Updated: