For some reason my MySQL server tends to die once there are about 10,000,000 entries in the post table. What I'm going to try to do is cut all the past entries up into years and place them into separate tables. I could actually make them bumpable that way.
Brother, have you thought about serving semi-static pages that are re-generated every time there is a post? You'd be accessing the database only whenever a post is made. Otherwise you could serve plain old HTML.
Pages would look exactly the same, but it'd lighten the mysql server load dramatically.
Note: I am assuming you haven't done this already. Also I've never worked on a DB this big, so I may not know what I"m talking about.
Date: January 26th, 2012 11:10 PM Author: rachmiel
No, that's not a bad idea. In fact, I was doing that a while ago, but it didn't seem to make a difference at the time. Writing to the database seems to be the real bottleneck. It's probably worth exploring again, though.
Date: January 27th, 2012 12:11 AM Author: confused house
What's the current memory usage on this server?
MSSQL express has a10gb/database limit and no row limit. If we're well under 10gbs, might be worth considering switching.
In any case, splitting up the tables by year seems like a decent idea if a row limit is the issue. Dont know your table structure but the only obstacles i see are
Making sure search queries hit all tables
Also, you'd need to somehow code a thread to move to the newest table if someone bumps a thread from '09, '10, etc
Date: January 26th, 2012 8:34 PM Author: Frozen misunderstood school cafeteria trust fund
will we be able to bump those old threads at some point or get the "you lose" message?
sadly, half the old threads are junk that no one cares about. but then there's the half that are funny and epic and could use an occassional resurfacing.
Date: January 26th, 2012 8:32 PM Author: Wonderful canary macaca
no, seriously, i dont get it. hes friends with a bunch of posters. if he doesnt want to run it just make earl the admin. someone he knows who can at least ban spammers and shit.
Date: January 26th, 2012 8:35 PM Author: racy codepig therapy
thank you. aside from the database issue, we also have a mentally-ill spammer who uses a script to stuff threads with so much garbage so quickly that they shut down. if you could ban that guy, i think it would actually benefit his own mental health, which is teetering at best.
He knew all about the site, too, and thought I was cool for not ratting people out when times got tough. Apparently he knew about the lawsuits. I told him I didn't want to do anything to jeopardize his son's career, but that I would have to take action if it doesn't stop. You denied everything to him. So I told him I had logs.
Date: January 26th, 2012 8:56 PM Author: Khaki kitchen milk
Seriously though, at the time I could never figure this out. You know my IP, and in my case that tells you a lot about me. Doobs would have loved to see me outed - why did you never give him any details?
Date: January 26th, 2012 9:12 PM Author: Khaki kitchen milk
all right rach, I get that the whole point of this "I called your dad" meme is to get me to quit the board. still, do you even know what city he lives in?
Date: January 26th, 2012 9:41 PM Author: Khaki kitchen milk
lol bro you're fuckin pathetic, but keep lying about getting laid and being a tough guy online. seriously I'm like 10 years younger than you and even i can see what a huge fucking joke you are
I disagree with this assessment. Pharmacy is perfect for anyone, especially a woman who wants to be involved in her family. 40 hr weeks, six figure salary...And if she wants to be a mom, she can just be per diem.
Do you really think it's in the best interest of the site to publicize how its security works? I think by now you've seen that I don't compromise people's privacy, so however I track people down is immaterial.
Date: January 26th, 2012 9:03 PM Author: Passionate private investor
I agree that it isn't. So can you de-mod the person who plastered all over XO screen caps of your text conversation with him in which you detail precisely how you figured out who the spammer is and linked him to Alia, i.e., Doobs?
Date: January 26th, 2012 9:09 PM Author: Passionate private investor
He did post screen caps of an IM conversation in which you claimed that Peter North was Alia. He also claimed that you told him that they share a password. At any rate, there are a million reasons to de-mod Doobs. Just throwing it out there.
Date: January 26th, 2012 9:54 PM Author: Passionate private investor
That's a negative good buddy. It was introduced in a post Doobs made linking Alia to Peter North, by Doobs himself, saying that rachmiel had told him so.
Date: January 27th, 2012 10:33 AM Author: high-end arousing selfie giraffe
Dont post his first name, his last name or part of it in thread titles OR threads. Don't post derivatives of his nake or anyone elses name. Why the fuck are you doing that? Does it make you feel good to break the rules and harass other people?
There is so many other ways to feed your mental illness and trolling fixation.