Invision Community 4: SEO, prepare for v5 and dormant account notifications By Matt Monday at 02:04 PM
Apfelstrudel Posted May 11, 2023 Posted May 11, 2023 Hello, in the last couple of days we deleted a lot of old and hidden posts/topics. The list of deleted content in modcp is 200 pages long. 😉 We set the permanent deletion period to 1 day. Due to the fact that the "delete content" task runs only once a day and everytime it deletes only approximately 1 page of deleted posts it would theoretically need 200 days to delete all 200 pages. 😉 Is it possible to run the deletion task more often a day automatically? (I know that I can start it manually as often as I want) Another solution would be to use modcp to permanently delete the content, but this would also take a very long time, since only a few pages can be marked for deletion (due to a possible timeout). Thanks in advance for your help. Â
Marc Posted May 11, 2023 Posted May 11, 2023 Im not sure where you get the impression there that it would only delete 1 page of content. It would delete any content that is past that expiry, not just one page.
Apfelstrudel Posted May 11, 2023 Author Posted May 11, 2023 In my case the task only deletes 1-5 pages depending if there are posts or topics.
Marc Posted May 11, 2023 Posted May 11, 2023 Ah, it will probably run until timeout on your mysql instance, so increasing the length of time a query can be run for would likely resolve that issue, if its causing you a problem. There is no way in which to increase the times it runs
Apfelstrudel Posted May 11, 2023 Author Posted May 11, 2023 So you think multiplying the mysql timeout by 200 solves the problem 😉. Normally these big tasks are done step by step, like rebuilding the search index. I suspect that you are not doing the entire delete task in one command.
Marc Posted May 11, 2023 Posted May 11, 2023 No, they are done in batches of what the mysql instance will allow
Recommended Posts