Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-5192

Feature suggestion: last access time for database, table, user

        Details

        • Type: Task
        • Status: Open
        • Priority: Trivial
        • Resolution: Unresolved
        • Fix Version/s: None
        • Component/s: None
        • Labels:
          None

          Description

          When you run hosting customers create a lot of databases and mysql users over time and never delete them (as they like to limit themselfs to deleting only files via ftp). For cleanup purposes It would be nice if you could on-demand enable/disable gathering statistics like last access time for database and last access time for mysql user. Last access time for tables is less important here but might be usefull in other scenarios. It might be enought just to make general query log without queries (only connections, inits).

            Gliffy Diagrams

              Attachments

                Activity

                Hide
                Permalink
                serg Sergei Golubchik added a comment -

                This can be easily done with an audit plugin.

                Show
                serg Sergei Golubchik added a comment - This can be easily done with an audit plugin.

                  People

                  • Assignee:
                    Unassigned
                    Reporter:
                    naox naox
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    2 Start watching this issue

                    Dates

                    • Created:
                      Updated: