Page MenuHomePhabricator
Differential D18687

Add a garbage collector for common ngrams
ClosedPublic
Actions

Authored by epriestley on Oct 5 2017, 12:27 AM.
Tags
None
Referenced Files
F18509139: D18687.id.diff
Fri, Sep 5, 3:14 AM
F18501712: D18687.diff
Thu, Sep 4, 9:55 PM
F18324185: D18687.id.diff
Sun, Aug 24, 7:12 PM
F18303952: D18687.diff
Sat, Aug 23, 10:16 PM
F18091672: D18687.diff
Aug 7 2025, 12:06 AM
F17746892: D18687.diff
Jul 21 2025, 9:03 PM
F17711920: D18687.diff
Jul 17 2025, 9:19 AM
Unknown Object (File)
Apr 20 2025, 10:22 PM
View All Files
Subscribers
None

Details

Reviewers
amckinley
Maniphest Tasks
T13000: Sustained MySQL I/O overwhelmed db009 / huge Ferret engine ngrams table
Commits
rP66df5b149309: Add a garbage collector for common ngrams
Summary

Ref T13000. After an ngram is marked as "common", we can delete it from the storage table.

Currently, the only way to get ngrams marked as "common" is to manually run bin/search ngrams, so this has no impact on normal installs.

Test Plan

Ran bin/garbage collect, saw it start chewing through my local Maniphest ngrams table and removing common ngrams.

Diff Detail

Repository
rP Phabricator
Lint
Lint Not Applicable
Unit
Tests Not Applicable

Event Timeline

epriestley created this revision.Oct 5 2017, 12:27 AM
Harbormaster completed remote builds in B18640: Diff 44862.Oct 5 2017, 12:28 AM
epriestley updated this revision to Diff 44864.Oct 5 2017, 12:41 AM
  • Also add a little warning text to bin/search ngrams.
Harbormaster completed remote builds in B18641: Diff 44864.Oct 5 2017, 12:42 AM
amckinley accepted this revision.Oct 5 2017, 6:01 PM
This revision is now accepted and ready to land.Oct 5 2017, 6:01 PM
Closed by commit rP66df5b149309: Add a garbage collector for common ngrams (authored by epriestley). · Explain WhyOct 5 2017, 6:41 PM
This revision was automatically updated to reflect the committed changes.

Revision Contents
Changeset List

PathSize
src/
2 lines
applications/
search/
garbagecollector/
55 lines
management/
5 lines

Diff 44868

View Options

src/__phutil_library_map__.php

Loading...
View Options

src/applications/search/garbagecollector/PhabricatorSearchFerretNgramGarbageCollector.php

Loading...
View Options

src/applications/search/management/PhabricatorSearchManagementNgramsWorkflow.php

Loading...
Phabricator · Built by Phacility