Apologies for the 6.5 hours of downtime today. This was required to prune some posts from the Trek BBS.
I said back in December I would chop some data from the system... for stability mostly. However the issue became more prominent as we were running out of disk space.
We weren't 'out' as such, but the database system requires extra space when backing up in the morning for example (which was when we were running out). Disk space running out on the server is problematic because all the sites will stop working properly, email will stop working etc. The disk space issue was even a problem when finalising maintenance today.
However, in line with the announcement back then TNZ has felt the brunt of the post cull. 484,918 posts have been deleted with 9055 threads (a bit less than the estimated 500,000). The thread had to be at least 765 days old, with no reply for at least 365 days; so these really were quiet old threads, and shows you how with no culls now for three years how things build up. TNZ is left with about ~8500 threads... the total on the front page is wrong, it seems.
It represents approximately 10% of the Trek BBS database, and saves us a pretty measly 280 MiB which (I don't understand this MiB crap) is somewhere around 300MB I guess? But that is shaven off the database, and makes backups more lean.
There will be a further cull, either on Sunday or in a week or two's time, but it won't be quite as severe. It will also follow the previous announcement in terms of where things are cut.
Thanks for your patience.
I said back in December I would chop some data from the system... for stability mostly. However the issue became more prominent as we were running out of disk space.
We weren't 'out' as such, but the database system requires extra space when backing up in the morning for example (which was when we were running out). Disk space running out on the server is problematic because all the sites will stop working properly, email will stop working etc. The disk space issue was even a problem when finalising maintenance today.
However, in line with the announcement back then TNZ has felt the brunt of the post cull. 484,918 posts have been deleted with 9055 threads (a bit less than the estimated 500,000). The thread had to be at least 765 days old, with no reply for at least 365 days; so these really were quiet old threads, and shows you how with no culls now for three years how things build up. TNZ is left with about ~8500 threads... the total on the front page is wrong, it seems.
It represents approximately 10% of the Trek BBS database, and saves us a pretty measly 280 MiB which (I don't understand this MiB crap) is somewhere around 300MB I guess? But that is shaven off the database, and makes backups more lean.
There will be a further cull, either on Sunday or in a week or two's time, but it won't be quite as severe. It will also follow the previous announcement in terms of where things are cut.
Thanks for your patience.