Auto-delete documents when expired on MongoDB
I'm developing a PHP application that stores a historical log in a MongoDB collection.
After 1 hour, these data are not important and are deleted by a CRON process that runs every hour.
The question is, is there any other solution to remove these documents automatically after a period of time since its insertion?
Thank you very much!
php mongodb
asked Feb 10 '14 at 23:44
HermetiCHermetiC
183
add a comment |
I'm developing a PHP application that stores a historical log in a MongoDB collection.
After 1 hour, these data are not important and are deleted by a CRON process that runs every hour.
The question is, is there any other solution to remove these documents automatically after a period of time since its insertion?
Thank you very much!
php mongodb
asked Feb 10 '14 at 23:44
HermetiCHermetiC
183
That's a very nice question +1
– CesarTrigo
Nov 15 '14 at 16:39
add a comment |
I'm developing a PHP application that stores a historical log in a MongoDB collection.
After 1 hour, these data are not important and are deleted by a CRON process that runs every hour.
The question is, is there any other solution to remove these documents automatically after a period of time since its insertion?
Thank you very much!
php mongodb
asked Feb 10 '14 at 23:44
HermetiCHermetiC
183
I'm developing a PHP application that stores a historical log in a MongoDB collection.
After 1 hour, these data are not important and are deleted by a CRON process that runs every hour.
The question is, is there any other solution to remove these documents automatically after a period of time since its insertion?
Thank you very much!
php mongodb
php mongodb
asked Feb 10 '14 at 23:44
HermetiCHermetiC
183
asked Feb 10 '14 at 23:44
HermetiCHermetiC
183
asked Feb 10 '14 at 23:44
HermetiCHermetiC
183
asked Feb 10 '14 at 23:44
HermetiCHermetiC
183
asked Feb 10 '14 at 23:44
HermetiCHermetiC
183
183
That's a very nice question +1
– CesarTrigo
Nov 15 '14 at 16:39
add a comment |
That's a very nice question +1
– CesarTrigo
Nov 15 '14 at 16:39
That's a very nice question +1
– CesarTrigo
Nov 15 '14 at 16:39
That's a very nice question +1
– CesarTrigo
Nov 15 '14 at 16:39
add a comment |
1 Answer
1
active
oldest
votes
To expire documents after a certain number of seconds, you can create a TTL index that is a special index property that relies on a background thread in mongod that reads the target index date values and performs delete operations on those who have expired.
To do this you will need a createdAt field that stores the insertion date in your log collection, for example you can use "new Date()”
To enable TTL for a collection use ensureIndex() method to create an index with the expireAfterSeconds additional property.
db.log.ensureIndex( { "createdAt": 1 }, { expireAfterSeconds: 3600 } )
This statement will create a TTL index and MongoDB will automatically delete documents from log collections when the createdAt value is older than the createdAt value + expireAfterSeconds value (3600 = 60secs * 60 mins).
The background task that removes expired documents runs every 60 seconds
I also recommend you to take a look to the following article that explains exactly the full process: http://mongodbspain.com/en/2014/02/08/expire-data-from-collections-using-ttl/
Regards.
answered Feb 10 '14 at 23:44
CesarTrigoCesarTrigo
26729
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f21690254%2fauto-delete-documents-when-expired-on-mongodb%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
To expire documents after a certain number of seconds, you can create a TTL index that is a special index property that relies on a background thread in mongod that reads the target index date values and performs delete operations on those who have expired.
To do this you will need a createdAt field that stores the insertion date in your log collection, for example you can use "new Date()”
To enable TTL for a collection use ensureIndex() method to create an index with the expireAfterSeconds additional property.
db.log.ensureIndex( { "createdAt": 1 }, { expireAfterSeconds: 3600 } )
This statement will create a TTL index and MongoDB will automatically delete documents from log collections when the createdAt value is older than the createdAt value + expireAfterSeconds value (3600 = 60secs * 60 mins).
The background task that removes expired documents runs every 60 seconds
I also recommend you to take a look to the following article that explains exactly the full process: http://mongodbspain.com/en/2014/02/08/expire-data-from-collections-using-ttl/
Regards.
answered Feb 10 '14 at 23:44
CesarTrigoCesarTrigo
26729
add a comment |
To expire documents after a certain number of seconds, you can create a TTL index that is a special index property that relies on a background thread in mongod that reads the target index date values and performs delete operations on those who have expired.
To do this you will need a createdAt field that stores the insertion date in your log collection, for example you can use "new Date()”
To enable TTL for a collection use ensureIndex() method to create an index with the expireAfterSeconds additional property.
db.log.ensureIndex( { "createdAt": 1 }, { expireAfterSeconds: 3600 } )
This statement will create a TTL index and MongoDB will automatically delete documents from log collections when the createdAt value is older than the createdAt value + expireAfterSeconds value (3600 = 60secs * 60 mins).
The background task that removes expired documents runs every 60 seconds
I also recommend you to take a look to the following article that explains exactly the full process: http://mongodbspain.com/en/2014/02/08/expire-data-from-collections-using-ttl/
Regards.
answered Feb 10 '14 at 23:44
CesarTrigoCesarTrigo
26729
add a comment |
To expire documents after a certain number of seconds, you can create a TTL index that is a special index property that relies on a background thread in mongod that reads the target index date values and performs delete operations on those who have expired.
To do this you will need a createdAt field that stores the insertion date in your log collection, for example you can use "new Date()”
To enable TTL for a collection use ensureIndex() method to create an index with the expireAfterSeconds additional property.
db.log.ensureIndex( { "createdAt": 1 }, { expireAfterSeconds: 3600 } )
This statement will create a TTL index and MongoDB will automatically delete documents from log collections when the createdAt value is older than the createdAt value + expireAfterSeconds value (3600 = 60secs * 60 mins).
The background task that removes expired documents runs every 60 seconds
I also recommend you to take a look to the following article that explains exactly the full process: http://mongodbspain.com/en/2014/02/08/expire-data-from-collections-using-ttl/
Regards.
answered Feb 10 '14 at 23:44
CesarTrigoCesarTrigo
26729
To expire documents after a certain number of seconds, you can create a TTL index that is a special index property that relies on a background thread in mongod that reads the target index date values and performs delete operations on those who have expired.
To do this you will need a createdAt field that stores the insertion date in your log collection, for example you can use "new Date()”
To enable TTL for a collection use ensureIndex() method to create an index with the expireAfterSeconds additional property.
db.log.ensureIndex( { "createdAt": 1 }, { expireAfterSeconds: 3600 } )
This statement will create a TTL index and MongoDB will automatically delete documents from log collections when the createdAt value is older than the createdAt value + expireAfterSeconds value (3600 = 60secs * 60 mins).
The background task that removes expired documents runs every 60 seconds
I also recommend you to take a look to the following article that explains exactly the full process: http://mongodbspain.com/en/2014/02/08/expire-data-from-collections-using-ttl/
Regards.
answered Feb 10 '14 at 23:44
CesarTrigoCesarTrigo
26729
answered Feb 10 '14 at 23:44
CesarTrigoCesarTrigo
26729
answered Feb 10 '14 at 23:44
CesarTrigoCesarTrigo
26729
answered Feb 10 '14 at 23:44
CesarTrigoCesarTrigo
26729
26729
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f21690254%2fauto-delete-documents-when-expired-on-mongodb%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
That's a very nice question +1
– CesarTrigo
Nov 15 '14 at 16:39