Minor help on disk & remove minor annoyance
Description
Status | Subtype | Assigned | Task | ||
---|---|---|---|---|---|
Open | None | T241083 Epic: fundraising database scalability | |||
Resolved | Eileenmcnaughton | T243870 Decide what to do about the increasing civi crm db size | |||
Resolved | Eileenmcnaughton | T245577 Remove 'quick autoreviewed' entity tag |
Event Timeline
IN digging into this I found that of the old 'system' for tagging for review we have the following tags in our system:
`SELECT tag.id, tag.name, count(et.id) as c FROM civicrm_entity_tag et RIGHT JOIN civicrm_tag tag ON tag.id=tag_id WHERE tag.name LIKE '%reviewed%' AND tag.id < 30 GROUP BY tag.id ORDER BY c DESC;
id | name | count |
17 | Quick autoreviewed | 10610860 |
16 | Autoreviewed - Unique | 0 |
22 | Manually reviewed - Revert address | 0 |
21 | Manually reviewed - Revert name | 0 |
20 | Manually reviewed - Revert email | 0 |
19 | Manually reviewed - Perform action | 0 |
23 | Manually reviewed - Revert language | 0 |
7 rows in set (2.62 sec)
In other words the 6 manual tags are not being used while around 10million contacts are tagged with Quick autoreviewed
I checked our codebase and we are not still assigning these tags & only 4 have been added since we turned logging on (presumably by user accident)
select * from log_civicrm_entity_tag WHERE tag_id =17 AND log_action = 'Insert' ORDER by log_date DESC LIMIT 10\G
ERGO I feel pretty confident doing the following
- untagging all contacts tagged with Quick autoreviewed
- deleting all references to the above from our audit log
- removing the 7 tags listed above