remove deleted databases from serverStatus.locks

XMLWordPrintableJSON

    • Type: Bug
    • Resolution: Duplicate
    • Priority: Minor - P4
    • None
    • Affects Version/s: None
    • Component/s: None
    • None
    • ALL
    • None
    • 3
    • None
    • None
    • None
    • None
    • None
    • None
    • None

      When a database is deleted, it is removed from the output of "show dbs"; however, it is not removed from serverStatus.locks until the server is restarted.

      The database is removed from serverStatus.recordStats when it is deleted.

      If I had a program that created a 1000 temp databases per hour and then deleted them, I could run into a situation where I have millions of deleted databases listed in serverStatus.locks until the server is restarted.

              Assignee:
              Unassigned
              Reporter:
              Ryan Nitz
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Created:
                Updated:
                Resolved: