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

Cache VIEW definitions in the TDC

        Details

        • Type: Task
        • Status: Closed
        • Priority: Critical
        • Resolution: Fixed
        • Fix Version/s: 10.1.4
        • Component/s: Views
        • Labels:
          None

          Description

          Table definitions, once opened, are cached in the table definition cache.
          View definitions aren't, views are reopened and re-parsed every time.

          Let's cache views too.

            Gliffy Diagrams

              Attachments

                Issue Links

                links to

                Web Link MySQL Bug#13819275 - Huge performance bottleneck because views

                  Activity

                  Ascending order - Click to sort in descending order
                  Hide
                  Permalink
                  sanja Oleksandr Byelkin added a comment -

                  revision-id: 84d4d3f44db6da8c072f21ca983b6fd4e8754022
                  parent(s): f7d196bb2e605766668895027c48728f03803734
                  committer: Oleksandr Byelkin
                  branch nick: server
                  timestamp: 2015-03-10 10:24:20 +0100
                  message:

                  MDEV-7671: Cache VIEW definitions in the TDC

                  (changes of backported patch are very small: strlen removed, error processing fixed, view open statistics added)

                  Show
                  sanja Oleksandr Byelkin added a comment - revision-id: 84d4d3f44db6da8c072f21ca983b6fd4e8754022 parent(s): f7d196bb2e605766668895027c48728f03803734 committer: Oleksandr Byelkin branch nick: server timestamp: 2015-03-10 10:24:20 +0100 message: MDEV-7671 : Cache VIEW definitions in the TDC (changes of backported patch are very small: strlen removed, error processing fixed, view open statistics added)
                  Hide
                  Permalink
                  sanja Oleksandr Byelkin added a comment -

                  revision-id: f954bb7fdc527cf816253fe0e7adb4239c368624
                  parent(s): f7d196bb2e605766668895027c48728f03803734
                  committer: Oleksandr Byelkin
                  branch nick: server
                  timestamp: 2015-03-10 12:52:45 +0100
                  message:

                  MDEV-7671: Cache VIEW definitions in the TDC

                  (changes of backported patch are very small: strlen removed, error processing fixed, view open statistics added)

                  Show
                  sanja Oleksandr Byelkin added a comment - revision-id: f954bb7fdc527cf816253fe0e7adb4239c368624 parent(s): f7d196bb2e605766668895027c48728f03803734 committer: Oleksandr Byelkin branch nick: server timestamp: 2015-03-10 12:52:45 +0100 message: MDEV-7671 : Cache VIEW definitions in the TDC (changes of backported patch are very small: strlen removed, error processing fixed, view open statistics added)

                    People

                    • Assignee:
                      sanja Oleksandr Byelkin
                      Reporter:
                      serg Sergei Golubchik
                    • Votes:
                      0 Vote for this issue
                      Watchers:
                      3 Start watching this issue

                      Dates

                      • Created:
                        Updated:
                        Resolved:

                        Time Tracking

                        Estimated:
                        Original Estimate - Not Specified
                        Not Specified
                        Remaining:
                        Remaining Estimate - 0 minutes
                        0m
                        Logged:
                        Time Spent - 1 hour
                        1h