T289249: flaggedtemplates table should not keep the whole history of all revisions is done now but still flaggedtemplates table in arwiki (for example) is bigger than revision table of enwiki or wikidatawiki.
Two (mutually inclusive) actions that can be taken:
- The current pruning script, deletes data on revisions that have 50 newer revision in a page (and are older than an hour). That is not the case for most revisions because they are spread among a lot of pages.
- Make the script reduce that number to five revisions (instead of 50) for revisions older than a year.
- Drop ft_namespace and ft_title columns.
- the table mirrors templatelinks table (by picking up its worst parts), for templatelinks it makes sense to keep title instead of page_id or rev_id but for flaggedtemplates, we are keeping track of stable revisions of transcluded templates. That concept is useless here as a non-existent template doesn't have a stable version.
- Fully truncate this table in ruwikisource (not needed after T226054)