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

INDEPENDENT ANALYZE - per database (or per table)

        Details

        • Type: Task
        • Status: Closed
        • Priority: Minor
        • Resolution: Won't Fix
        • Fix Version/s: None
        • Component/s: None
        • Labels:
          None

          Description

          hi guys, could MDEV-3806 be done in a per database tables?
          instead of creating only one table in mysql database
          could it be done in each schema?
          maybe puts this information at schema, something like:
          ALTER DATABASE xxxx
          INDEPENDENT_ANALYZE=global/local
          INDEPENDENT_PREFIX=mysql_analyze

          the prefix is used only for table names don't hit some user table

          —
          or maybe... if we could... save it in a per table? like a new file in filesystem...
          *.frm *.MAD *.MAI *.mariadb_stats

            Gliffy Diagrams

              Attachments

                Issue Links

                relates to

                Task - A task that needs to be done. MDEV-3806 Engine independent statistics

                • Major - Major loss of function.
                • Closed

                  Activity

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

                  technically it might be possible.
                  but we have no plans of implementing it, as far as I know.

                  Show
                  serg Sergei Golubchik added a comment - technically it might be possible. but we have no plans of implementing it, as far as I know.
                  Hide
                  Permalink
                  rspadim roberto spadim added a comment -

                  no problem, could we leave it open, or maybe stall it?

                  Show
                  rspadim roberto spadim added a comment - no problem, could we leave it open, or maybe stall it?

                    People

                    • Assignee:
                      Unassigned
                      Reporter:
                      rspadim roberto spadim
                    • Votes:
                      0 Vote for this issue
                      Watchers:
                      2 Start watching this issue

                      Dates

                      • Created:
                        Updated:
                        Resolved:

                        Time Tracking

                        Estimated:
                        Original Estimate - 1 week
                        1w
                        Remaining:
                        Remaining Estimate - 1 week
                        1w
                        Logged:
                        Time Spent - Not Specified
                        Not Specified