Details
-
Task
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
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.
Attachments
Issue Links
Activity
| Field | Original Value | New Value |
|---|---|---|
| Remote Link | This issue links to "MySQL Bug#13819275 - Huge performance bottleneck because views (Web Link)" [ 22703 ] |
| Status | Open [ 1 ] | In Progress [ 3 ] |
| Assignee | Oleksandr Byelkin [ sanja ] | Sergei Golubchik [ serg ] |
| Status | In Progress [ 3 ] | In Review [ 10002 ] |
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)
| Status | In Review [ 10002 ] | Stalled [ 10000 ] |
| Assignee | Sergei Golubchik [ serg ] | Oleksandr Byelkin [ sanja ] |
| Status | Stalled [ 10000 ] | In Progress [ 3 ] |
| Status | In Progress [ 3 ] | Stalled [ 10000 ] |
| Fix Version/s | 10.1.4 [ 18400 ] | |
| Fix Version/s | 10.1 [ 16100 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | Stalled [ 10000 ] | Closed [ 6 ] |
| Workflow | MariaDB v2 [ 59939 ] | MariaDB v3 [ 65572 ] |
| Workflow | MariaDB v3 [ 65572 ] | MariaDB v4 [ 132530 ] |
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)