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

Query log per database or table

        Details

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

          Description

          Hi,

          It would be extremely useful to have query logs per database or table, especially when debugging projects on servers with multiple projects. For example, our development server has over 50 databases and it is nearly impossible to debug the general log file when so many queries from so many databases are being written to the same log file.

          We would like each database to have it's own query log, or even better each table to have it's own log file.

          Cheers,
          Michael Mussulis

            Gliffy Diagrams

              Attachments

                Activity

                Ascending order - Click to sort in descending order
                Hide
                Permalink
                serg Sergei Golubchik added a comment -

                Also, it'd make sense to have binary log per, say, per database. With multiple projects in the same MariaDB instance, one doing a huge LOAD DATA will effectively block replication for all other projects as no binlog events can be logged (or read by the slave) in the middle of the big load data event.

                Show
                serg Sergei Golubchik added a comment - Also, it'd make sense to have binary log per, say, per database. With multiple projects in the same MariaDB instance, one doing a huge LOAD DATA will effectively block replication for all other projects as no binlog events can be logged (or read by the slave) in the middle of the big load data event.
                Hide
                Permalink
                serg Sergei Golubchik added a comment -

                This can be easily done with an audit plugin with no changes to the server

                Show
                serg Sergei Golubchik added a comment - This can be easily done with an audit plugin with no changes to the server

                  People

                  • Assignee:
                    Unassigned
                    Reporter:
                    mpgjunky Michael Mussulis
                  • Votes:
                    1 Vote for this issue
                    Watchers:
                    3 Start watching this issue

                    Dates

                    • Created:
                      Updated: