System resource exceeded: Difference between revisions
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) |
||
| Line 90: | Line 90: | ||
== Solution approach: Purging some old data from centralized == | == Solution approach: Purging some old data from centralized == | ||
I made a copy and deleted all child records before 2015-01-01 (ie kept L_Log complete, but deleted corresponding records in L_TmpV2 etc). | I made a copy and deleted all child records before 2015-01-01 (ie kept L_Log complete, but deleted corresponding records in L_TmpV2 etc). This shrunk centralized from 1GB to 618MB. | ||
== Solution approach: Query size limiting == | == Solution approach: Query size limiting == | ||