Data at Your Fingertips: Explore Our New Reporting and Statistical Capabilities By Ryan Ashbrook Tuesday at 01:29 PM
Apfelstrudel Posted May 11 Share Posted May 11 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.  Link to comment Share on other sites More sharing options...
Marc Stridgen Posted May 11 Share Posted May 11 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. Link to comment Share on other sites More sharing options...
Apfelstrudel Posted May 11 Author Share Posted May 11 In my case the task only deletes 1-5 pages depending if there are posts or topics. Link to comment Share on other sites More sharing options...
Marc Stridgen Posted May 11 Share Posted May 11 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 Link to comment Share on other sites More sharing options...
Apfelstrudel Posted May 11 Author Share Posted May 11 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. Link to comment Share on other sites More sharing options...
Marc Stridgen Posted May 11 Share Posted May 11 No, they are done in batches of what the mysql instance will allow Link to comment Share on other sites More sharing options...
Recommended Posts