If you guys don't mind sharing. What exact HW and Software is CP currently using?

I believe we have a lot of IT people myself included on this website that might be able to give some advise on a good path forward.

Trying to read from a 16 million row table should be milliseconds on a ten year old think pad using an off the shelf database (sqlite) with a few GB of ram (assuming your drives aren't 10 years old). I could load up an ancient version of Postgres and get the same results. 16 million records in a database is jack and shit for even database systems developed thirty years ago. You aren't making any sense. If you're telling me that your hardware is too old to expect that level of performance, well then we're in violent agreement.

I don't know shit about ****, but if we can make this place run better by letting the political forum break off like California in an earthquake movie, I move we kick it out to sea.

Advice on systems isn't really the roadblock here.

Mmmk.

Understand. Deciding on the best upgrade path is usually the hardest part.

Personally I work with enterprise servers for a living. But can't tell you if any of my knowledge would be applicable.

On a side note you would be amazed by some of the old code that is still out there. Hell all Pizzs Hut base code is still from the 70s. 😆

Oh, the wayback machine. That thing is fun. I can still look up my old band's webpage on that.

And the CP threads on that link really take you back. Lot of good discussion. I wish some of those folks were still around.

I’m just glad there are soooo many IT folks on CP.

Seems to be really helping this specific situation a lot

Hey I love CP. Can't fault people for wanting to try to help out if they can.

I developed a piece of software that uses Sqlite to sync data between multiple different parties for offline replication (this was over two years ago). I load tested this on older hardware knowing that my potential customers might be running on trash. I can tell you that 16 million records worked fine. Shit, you can add up to a billion rows in SQLite if you really know what you're doing...
MySql was a state of the art database with a good query analyzer\engine...Not being able to query or insert into a table that small leads me to believe you've got a problem that's deeper than just COTS. But you've got it all figured out and are king snake here so that's up to you to solve. But if I were in your position (which I don't envy) I wouldn't turn my nose up and act like a prick because somebody said something as simple as "are we solving a hardware problem with more software?".

I'm a software engineer, would absolutely be willing to help out or assist if anything is needed.

Why the sarcasm for people trying to help? :hmmm:

I can call the number for one of those four month IT certification programs. Would that help?

I went to one of them and got a software engineer job right out of school and have been doing it for years now. Best decision I made was a 4 month IT boot camp.

This wouldn't have been a problem if we nuked DC.

/ducks

That’s cool. I’ve always wondered how legitimate those are. I was just going to call them though I’m not tech savvy enough to do it. Hoping they could walk me through how to fix the issue since DaFace is looking for help and suggestions on this.

That's a great idea until a bunch of trolls sign up with other member's usernames for the lols. Because you KNOW that will happen.

Well, yeah. Obviously.

Just to be clear, I'm just here to answer questions. I'm happy to provide a little insight into the issues, but there are no decisions that I'll be making. I'm happy to pontificate about my views on the best new software, but I have no desire to get into it any further than I already am. :)

The barrier here is largely just Kyle finding time to deal with it, not Kyle figuring out how to do things.

Never gonna happen, ever

Kyle would - especially in the offseason - lose so many clicks it would make his head spin... like it or not, DC drives a ton of traffic

Comparing Sqlite performance and ancient, or even modern, MySQL is no comparison.

Big issue with these types of community softwares is that table indexes do not get set. Especially when you start adding in mods.

A good indexing could speed things up considerably but you are still running antiquated software. Both the bb software and the backend services.

vBulletin 3.8 is also just horrifically bad at query efficiency. I just checked for fun, and loading this page executed 39 queries just to give you an idea. Multiply that by 1000 people all mashing the reload button on game days, and it's just a mess. Plus it does all sorts of joins instead of utilizing indexes efficiently.

They've improved a lot of it on newer versions, which, again is why my personal preference would be to rip the bandaid off so we could get on software that's actually designed to work in 2024.

Considering that the latest version of vBulletin is 6.0.2, that makes perfect sense and should be the goal. :thumb:

I've found an accurate representation of everyone in this thread weighing in with their IT expertise:

https://pansci.asia/wp-content/uploa...e05fe3ed15.jpg

I coded a dungeons and dragons ripoff in BASIC back in the early 80’s, and I’m retired on disability, if you need anything from me.
sec

Well, I'd think your opinion matters quite a bit since you seem to do quite a bit of the front-end tweaking. $200 isn't bad, would we need a whole new server to slowly migrate too?

I'm not sure how the hosting works but maybe some others could help work on the themes are look of the new forum software if they only needed access to the new server. I know AC would probably have to migrate the data.

Let us know if we should cancel our next trips to Belize in order to donate

edit: I just caught up with the rest of the posts now and it doesn't seem like there is much to be done for now.

So, I'm assuming we got hacked?
I doubt Austin was pondering the revenue gained from becoming a pr0n site...

So when I clicked on the ChiefsplanetDowntime link and it...well, had an international flavor, I assume that wasn't just database issues.

I'm no IT specialist but I don't think that's how things work...

I'd say switching to SSD or NVMe drives would net the biggest bang for the buck, assuming the server hardware supports them. That would likely at least cut down on the amount of time things would be offline.

I think I asked this a long time ago, but what about moving to a cloud solution like Xenforo cloud and increasing revenue via donations or ads to pay for the costs? It sounds like AC is busy with his day-to-day job and his time is limited a bit. That would shift these outages to being someone else's problem to solve.

I've wondered about Xenforo cloud as well. Our traffic levels would likely be in their Enterprise tier that would require custom pricing (so more than $250/month). Whether our ad revenues would cover it, I don't know.

Please do not put my personal pics online or I will hire a lawyer that's simply unbeliezable.

Since this was bumped again, outside of the in memorandum section (which can be re-created easily) why exactly is a merger needed? Are there weirdos coming back and looking up old posts on the regular? And if so, should you care?

This place will fill up so fast just because of the novelty of recreating it new.

And Xenforo pro cloud guys are absolute professionals and Austin would be taking the headache of having to play EMS off his hands.

Cool, we can play Adopt-a-Monkey.

I'm the one on the table on the far right with his head inches from the screen.

And Kyle's thoughts on all of it.

https://media4.giphy.com/media/2EUUNySXEZoVq/giphy.gif

Again, I can only speak for myself and my limited understanding. I'd hate to lose the history, but it's not an absolute deal-breaker if we had to. But that said, I don't THINK that it's insurmountable to have both (a new system and migrate threads).

I know you play mediator whether it be a welcome or unwelcome role. Thank you.

I've always wanted to ask if you had a favorite, among your family's products? It's not a popular choice, but I have always liked Little Orphan Orange and Sir Isaac Lime. I tell people that, and they're all, "But...but...what about Strawberry Short Kook or Poncho Punch?" To which I'll respond, "What about the,?"

I probably shouldn't put you on the spot with a question like that. I mean, what are you supposed to say, right?

Also, it's probably not my business. But it seems like there would be some room for expansion in the family - might I suggest Leo Lemon?

temu.com

Have we tried deleting history, defragging the hard drive, and restarting?

Do you even IT, bro?

What we need to do is leave the server submerged in a giant bowl of rice overnight.

There is a little insider tech tip I learned several years ago that has gotten me out of some hairy situations. There are three keys on your keyboard that most people wouldn't know even exist. I'm pretty sure I'm about to make the heads of some Microsoft people explode.

DO NOT try this, unless you are, like, really good with computers. This only works if you hold all three of them down AT THE SAME TIME.

Honestly, it might be slightly irresponsible for me to even share this. But I gave you a warning.

The three keys are Ctrl, Alt, and Delete.

Can totally tell we're dealing with an IT god.

While we are on the topic, I would truly regret it if I didn't use this opportunity to at least mention something I always knew would completely change the Otter Pop trajectory - to the point where it would be broken up as before this moment, and after this moment.

Two words: Gladys Garlic!

I know!

Dude, this is serious big time tech stuff we're dealing with here, not my daughter's iPhone8. Can we please just be serious for like three seconds, here???

https://media.tenor.co/images/057f13...5261d7d471/raw

Bowser in the mod lounge. I'll let you all guess which role he plays.

It's true. But I never realized Bugeater was such a large sumbitch.

Guys, I'm in desperate need of information about technology.

Are their any gurus that can help a guy out??

LMAO

LMAO LMAO give me ten years.....

Let me figure out how to undelete my computer and I'll be right with you!

I interviewed someone the other day who had a 7 page resume and 2 additional pages of skills and technologies.... I could reach out to him.

Oh man he must be the king of IT. Please fax me his contact info post haste!

Did he hint at all about the Ctrl-Alt-Del insider tip I mentioned earlier? I bet he doesn't even know about it.

7 pages, that is a bold move
My career counselor would rip it up and tell him to start over

(i was going to say bold type, but that was too easy)

I get resumes for engineers and people who blew things up in other countries.

We sell weed.

I love you deface man. Just keep this place running cause this place got all my chiefs news.

That's nothing. My portfolio has like a million rows in a SQLite database.

I have an extra VBulletin 5 license if you need it, was going to use it on a Huskers board. Not sure if I can transfer it.

I might upgrade my server to 6 sometime soon if I can stop being lazy.

I know how ta' blow stuff up.

You hiring?..

Yeah, I can see how that would be awkward.

❤️ DeFace man.

I got one for you, be careful with this one, to Speed up your computer, wait for it, Alt+f4... keep this on the down low...

Not sure what your traffic is like, but have you looked into vBulletin Cloud? I've been pleased with it.

That's not really something you should be sharing in an open environment like this. Certain knowledge comes with great responsibility.

If nothing else, think of the children.

If you can't handle a FREELY ACCESSABLE entertainment website like ChiefsPlanet going down for a few hours or a day for server maintenance without losing your shit...I hate to break it to you, but that's a 'you problem'.

Maybe find a hobby? Or be with your family, God forbid?

I am NOT a HATER! I LOVE planned downtimes but, reality is reality. We are down supported versions of software, left late to optimize the database and we are NOT scoring with the search tool. I do not understand what is going on with our SQL as well as what the hell is going on with the SERVER! Will we post during the playoffs, YES! Will we be able to find that random opinion we posted 6 months ago? NO! THIS SUCKS!!

I get a lot of former teachers.
They're the most excited.

I WANT MY MTV!

ROFL never gets old

This is better anyways. Your dirty college stories and constant porn obsession made me uncomfortable.

We need an Incident Manager and a blast mail setup...

:)

Pager rotation... on call pay...

Nothing like here, maybe 50 users at max in a day in and out. I'll check into it and their pricing.

Well, if they get around to legalizing psilocybe mushrooms or DMT hold a part time spot for me. I'll need a retirement job...

You can just grow it personally and still be an old man Walmart greeter at my store.

What a great job…
I’d sweep the cig butts off the parking lot, and threaten the bastards I caught flipping them for minimum if I could find my way over there.
sec

Has the server run out of RAMs, get plugged into 120v instead of 220v, or forget the stepping process?

I leave for a couple of weeks and DeFace's shit goes to shit.. LMAO...

issues here. may be resolved.

Same:spock:

These days, the issues are usually caused by the server getting hammered by bots. We currently have around 32k "guests" on here to give you the idea. Every once in a while I go in and try and figure out a set of IPs to ban, but it's kind of like banning Clay's IP and assuming he'll never come back.

My theory is that everyone and their dog is out there training AIs on just about everything they can grab on the internet.

It could probably be solved by moving to different server infrastructure, but that's above my pay grade.