I knew hackforums was big, but wow, two servers for SQL. Impressive.
~A
maybe we should have a thing if your not active for a year or something your account gets deleted or something
(Oct 13, 2010 11:30 AM)BuyOMC Wrote: maybe we should have a thing if your not active for a year or something your account gets deleted or something
I'm pretty sure that Omni already has a member pruning thing in place.
Thank you for keeping us all up to date.
Well if it makes it better I'm happy.
How long will the server be down? And when?
(Oct 13, 2010 11:59 AM)Omniscient Wrote: We may not be a private forum but there is a ton of private message discussion here.
Exactly, I used to get more than 100 PM's each day alone.😝
(Oct 13, 2010 11:59 AM)Omniscient Wrote: We've had 5.7 million PMs go through HF. Compared to the 7 million post we've had. So as you can see PMs are huge here. For every 7 posts there are 5.5 PMs basically.
We may not be a private forum but there is a ton of private message discussion here.
And I have great pruning tools already. Like I said the recent issue is the threads table which is about 800,000 records. I just deleted 1.1k PM's. 🤝
You should get people to moderate a little heavier and get rid of all the shit posts, begging for free shit, etc.... theres a ton of those posts
Why not ban that user hfbud or w/e, the error says hes the one causing it!
Kidding, but yeah this site is growing to be huge as fuck, cant do no harm.
Exactly maybe if we limited the HF sig size to 600x150 and reduce the avatar size and stuff and delete all of the junked threads and posts and delete all the inactive users with under 200 posts and aint been active for a year it would speed HF up :).
that sounds pretty nice You need cloud hosting but that cost some money :x
(Oct 13, 2010 12:45 PM)Faith™ Wrote: I have a solution to all of this. Delete The Lounge. The Lounge causes around 50% of my reports, probably the same with others too. It's rare that I see a meaningful thread in there too. It wouldn't affect the forum a lot, apart from the Lounge count would disappear from profiles, and we'd loose 1 million posts from the total Hack Forums post count, but that doesn't really matter.
People will think I'm messing around, but I'm really not. This is a valid solution.
The lounge is HF. Lounge is what HF gets there name from. So I agree. All the trolls and the fags are in this section. Gives HF a real bad name.
/Agree
(Oct 13, 2010 11:24 AM)Omniscient Wrote: I think it's about time I got a second database server from my datacenter. We've tapped out this one I'm pretty sure. MyBB allows for master/slave replication where the slave will get all the SELECT queries which for this site is plenty.
I'll see how the next week or two goes but a new setup shouldn't be too hard as I only run MySQL on it and it's on the local loop.
Sorry that I'm turning off the site but I'm trying to adjust MySQL and clear up these locks. Ahhh sweet. So you'll have two servers mirroring each other. mybb writes to the master server and reads from the slave?
Tbh a salve server would be better maybe we could tighten the security on the MYSQL servers?
|
