|
08-13-2019, 06:54 PM | #181 |
Kind of a mod
Join Date: Aug 2005
Location: Donkey Land
|
I honestly don't know if it's a matter of money or just AC's time. Theoretically we could do a fundraiser for professional help or something, but it all comes down to what AC wants to do.
|
Posts: 52,306
|
08-13-2019, 06:58 PM | #182 |
Kind of a mod
Join Date: Aug 2005
Location: Donkey Land
|
|
Posts: 52,306
|
08-13-2019, 09:15 PM | #183 |
Administrator
Join Date: Aug 2000
Location: Austin
|
It's a bit of both but honestly throwing money at the server and getting better hardware won't do as much as people think. I will take some time to do some clean up and hopefully get things in better shape but it mostly boils down to what you said... old software(that people prefer) and a HUGE database.
|
Posts: 19,786
|
3 0 |
08-13-2019, 09:29 PM | #184 | |
Shaken. Not stirred.
Join Date: Sep 2002
Location: London
|
Quote:
|
|
Posts: 65,617
|
08-13-2019, 09:41 PM | #185 | |
Politically Incorrect
Join Date: Feb 2009
Location: Scottsdale, AZ
|
Quote:
|
|
Posts: 51,938
|
08-13-2019, 10:13 PM | #186 |
Kind of a mod
Join Date: Aug 2005
Location: Donkey Land
|
MariaDB 10.0.38. Most of the tables are MyISAM. I've debated messing around and seeing what would happen if I changed the POST table (which is the problem) to InnoDB, but it would likely take hours to change it and hours to change back if it still sucks. Plus, it could also royally break stuff. So I've decided I'm probably not the best one to do it.
At some point, if we decide we're just going to live with this software forever, we may need to consider pruning the database down. I've mulled over something like cloning the site and DB, then putting it at a different URL as a pure archive (no new posts), then pruning the active CP site down to just threads/posts from the past 5 years or something. Constantly sorting a 13 GB table almost has to be the biggest issue. There are better ways of doing the query in newer versions of vBulletin, but the queries in this version suck donkey balls. The one hardware upgrade that I wonder might help would be to move to a server where we could throw the entire database onto SSDs rather than HDDs. I could be wrong, but it seems like IO is probably the issue, so moving the DB onto a drive that would respond a lot faster might help. Maybe. So for what it's worth, here are the options as I see them:
Last edited by DaFace; 08-13-2019 at 10:37 PM.. |
Posts: 52,306
|
3 0 |
08-13-2019, 10:24 PM | #187 |
Arrowhead Trail of Tears
Join Date: Oct 2012
Location: KansasCity
|
Percona >
|
Posts: 29,281
|
08-13-2019, 10:29 PM | #188 |
Politically Incorrect
Join Date: Feb 2009
Location: Scottsdale, AZ
|
Thank you for such a thorough and we'll explained answer.
When you take nearly 20 years of data and allow it to be searchable and accessible to reuse, it chews up CPU for sure. This site also has an enormous amount of graphics, gifs and videos that add to the crush. Could an archive DB be setup to house a lot of older stuff that is still accessable but not always indexed and updated? I recall a large medical company like Merck or someone similar had an issue like this. |
Posts: 51,938
|
08-13-2019, 10:41 PM | #189 | |
Kind of a mod
Join Date: Aug 2005
Location: Donkey Land
|
Quote:
The version that I was suggesting would literally mean cloning the entire thing into a new installation like archive.chiefsplanet.com. There would be no interaction between the two, so if you wanted to "bump a post" from 2005, you'd just have to start a thread and link to it. |
|
Posts: 52,306
|
08-13-2019, 10:49 PM | #190 | |
Shaken. Not stirred.
Join Date: Sep 2002
Location: London
|
Quote:
|
|
Posts: 65,617
|
08-13-2019, 11:01 PM | #191 | |
Kind of a mod
Join Date: Aug 2005
Location: Donkey Land
|
Quote:
|
|
Posts: 52,306
|
1 0 |
08-13-2019, 11:23 PM | #192 |
Starter
Join Date: Feb 2018
Location: Phoenix, AZ
|
Sorry guys, it’s all of us Texas Tech fans who are now Chiefs fans. I rarely post, but I load the site probably 40-50 times a day (usually as a guest because, well, you guys know, doing activities that require me to clear browsing history and cookies on the regular so that the wife doesn’t see, and I forget to sign back in...).
I know it’s not much, but if there is a fundraiser, I’m in for a few bucks. I plan to be here for the next 50 or so years until I kick the bucket (at which point I’m sure we will all be able to upload our consciousnesses into a virtual ChiefsPlanet anywase - **** can these servers support that?). |
Posts: 811
|
08-13-2019, 11:35 PM | #193 |
Tossed Salad & Scrambled Eggs
Join Date: Jan 2009
Location: ATX & OPKS
|
Just Nuke DC and ban political talk in the lounge, if they want to start a spin-off circle jerk on something like Discord, sweet. 2+ million posts of ****ing garbage.
|
Posts: 19,967
|
5 1 |
08-13-2019, 11:37 PM | #194 |
Shaken. Not stirred.
Join Date: Sep 2002
Location: London
|
|
Posts: 65,617
|
08-13-2019, 11:40 PM | #195 | |
Tossed Salad & Scrambled Eggs
Join Date: Jan 2009
Location: ATX & OPKS
|
Quote:
- nuke 2 million posts in DC - nuke accounts with 0 posts that haven’t logged in in say, 2 years - nuke all threads (and posts) with 10 or fewer posts (is that a thing?) |
|
Posts: 19,967
|
1 0 |
|
|