Yet Another Cycling Forum
Off Topic => The Pub => Topic started by: rogerzilla on 16 April, 2024, 02:02:12 pm
-
TA is now massive and the recent crashes have been space-related. Up to you.
-
Seems like a reasonable thing to do in itself, but I'm curious about how much space it (and the database in general) is taking up. Text is small and disks are big, so presumably there's either something really inefficient going on, or the hosting is stingy about storage...
-
Delete it, and then reboot on an annual or six-monthly basis.
-
I like TA, it's a bit of fun. There's no need to keep any more than say, 10 pages though (it's not The Chain (https://thechain.uk/)).
-
Whilst I was tempted by the Beefheart option it makes sense, probably closely followed by the “Random threads about…” whilst there may some wit and amusement there’s no real loss of knowledge.
How much space does Tune Association use? It probably has the shortest posts on average of the whole forum, or is it the sheer volume of them that’s causing the problem?
-
I also tend to the "text is small, disks are big view", even with some per-post overhead and the need for manual intervention in any expansion.
The stats say
Tune Association
81173 replies
A random thread for small things that don't really warrant a thread of their own
30780 replies
So, it's quite a lot. I think there's probably more interest in the random thread...
Also, would deleting it take Clarion off the top poster's spot?
Sent from my SM-S911B using Tapatalk
-
Also, given database overheads and disk blocks I'd guess 50 - 80% of posts across the forum have the same effective size on disk. But I've not actually checked.
Sent from my SM-S911B using Tapatalk
-
Delete it, and then reboot on an annual or six-monthly basis.
And I'd suggest the same with the Wordle (etc) threads.
But then I don't post in any of those so it's not for me to say...
-
I'd be strongly against deleting most of the random thread for small x things threads. Yes, there's lots of transient waffle (especially in original small things thread), but there are also some excellent posts whose only crime is not being easily categorised.
If there must be a cull, Tune Association and the other word games threads would be the place to start. And probably things like old classifieds, but they're not going to free much disk.
(Fair point about block size. I remember the days when install tools would ask if you were going to use a partition for a newsgroup server or similar in order to pick a smaller block size. Though presumably the SQL database abstracts all that onto a higher plane of allocation with its own minimum size...)
-
You could reduce it considerably by deleting the replies referring to Half Man Half Biscuit.
-
You could reduce it considerably by deleting the replies referring to Half Man Half Biscuit.
;D
-
I voted in favour of keeping it because I just wanted to see how the votes were going. Please ignore (not that you wouldn't anyway). I'm a relatively recent addict of TA but it is essentially ephemeral so, yes, reboot away. Ditto Wordle.
-
You could reduce it considerably by deleting the replies referring to Half Man Half Biscuit.
Split the thread - start one for HMHB only and call it "Eno Association"
-
You could reduce it considerably by deleting the replies referring to Half Man Half Biscuit.
Split the thread - start one for HMHB only and call it "Eno Association"
And have a Placebo thread called Emo Association?
-
You could reduce it considerably by deleting the replies referring to Half Man Half Biscuit.
Split the thread - start one for HMHB only and call it "Eno Association"
And have a Placebo thread called Emo Association?
And a Johnny Cash thread called I Shot A Man In Reno Association...
-
I suppose deleting everything a random poster , say Larrington, has ever posted would save shed loads. Would we miss his erudite raffle from the past? Undoubtedly. Would he soon generate a shed load more. Indisputably.
Cull Larrington I say. You know it makes sense.
:demon:
-
I suppose deleting everything a random poster , say Larrington, has ever posted would save shed loads. Would we miss his erudite raffle from the past? Undoubtedly. Would he soon generate a shed load more. Indisputably.
Cull Larrington I say. You know it makes sense.
:demon:
Larrington is only 6th in the Major League Table.
Don’t cull him, Please!
Because if you do, I’ll be 6th :o
-
It’s about time Bethany (13) had her own account…
-
You could reduce it considerably by deleting the replies referring to Half Man Half Biscuit.
And I belive the above may actually be a HMHB song
-
Yes, start again at regular intervals.
I'd just like to add that a squid eating dough in a Polyethylene bag is fast and bulbous, got me?
-
Also tapered.
-
Funnel of Love - Wanda Jackson
-
I suppose deleting everything a random poster , say Larrington, has ever posted would save shed loads. Would we miss his erudite raffle from the past? Undoubtedly. Would he soon generate a shed load more. Indisputably.
Cull Larrington I say. You know it makes sense.
:demon:
That would be unbearable.
-
Yes, I'm all in favour of the removal of a huge chunk of Tune Association. I've never heard of >90% of them anyway.
-
I'm going to purge it and start a new one. Thanks.
-
I suppose deleting everything a random poster , say Larrington, has ever posted would save shed loads. Would we miss his erudite raffle from the past? Undoubtedly. Would he soon generate a shed load more. Indisputably.
Cull Larrington I say. You know it makes sense.
:demon:
Larrington is only 6th in the Major League Table.
Don’t cull him, Please!
Because if you do, I’ll be 6th :o
Bad luck, Jaded - the removal of Tune Association 1 has led to a demotion of Mr. L, who clearly posts there far too frequently, and you are in 6th place anyway! :P
Also, Clarion, who hasn't logged in for over 3 years, is now only 500 posts ahead of Kim.
-
You could reduce it considerably by deleting the replies referring to Half Man Half Biscuit.
Petty Sessions - Half Man Half Biscuit 😉