1,083
edits
Changes
Jump to navigation
Jump to search
Line 466:
Line 466: − + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
→Product Opener: mongodb indexes
** chown -R off deleted* html index ingredients lang invalid lists products users tmp
** chown -R off deleted* html index ingredients lang invalid lists products users tmp
====== Product opener debug =====
===== MongoDB indexes =====
Some basic indexes, needs to be revisited.
https://github.com/openfoodfacts/openfoodfacts-server/issues/341
<pre>
mongo
use obf
db.products.createIndex( { code : 1 }, { background : true });
db.products.createIndex( { unique_scans_n : -1 }, { background : true });
db.products.createIndex( { sortkey : -1 }, { background : true });
db.products.createIndex( { sortkey : -1 }, { background : true });
db.products.createIndex( { last_modified_t : -1 }, { background : true });
db.products.createIndex( { _keywords : 1, last_modified_t : -1 }, { background : true });
db.products.createIndex( { _keywords : 1, sortkey : -1 }, { background : true });
db.products.createIndex( { countries_tags : 1 }, { background : true });
db.products.createIndex( { countries_tags : 1 , last_modified_t : -1 }, { background : true });
db.products.createIndex( { countries_tags : 1 , sortkey : -1 }, { background : true });
db.products.createIndex( { brands_tags : 1 }, { background : true });
db.products.createIndex( { categories_tags : 1 }, { background : true });
</pre>
===== Product opener debug =====
Once Apache starts:
Once Apache starts: