Home Discord Chat
Go Back   ChiefsPlanet > Nzoner's Game Room
Reload this Page ChiefsPlanet (Welcome to the) NEW Chiefsplanet SERVER!!!!
Register FAQDonate Members List Calendar

Reply
Page 13 of 32 « First 39101112 13 1415161723 Last »
 
Thread Tools Display Modes
Old 11-23-2010, 06:36 PM  
AustinChief AustinChief is offline
Administrator
 
AustinChief's Avatar
 
Join Date: Aug 2000
Location: Austin
(Welcome to the) NEW Chiefsplanet SERVER!!!!
OK, the time has finally come... we have a new server!

I will be spending tonight and all day tomorrow transitioning to the new digs... I don't expect it to affect us until late tomorrow afternoon.

I will make give everybody a warning then take us offline for (hopefully!) 3-4 hours...

When we are done, we will have a new home with 6 TIMES the power and RAM as before... I expect to see some MAJOR upgrades in performance... once we have settled into the new server, I will start to prep us for a major upgrade to our Vbulletin software... but that may wait until the post season...

I know it's been a long time coming, but bear with me for a little longer and it will all be worth it!
Posts: 19,505
AustinChief is obviously part of the inner Circle.AustinChief is obviously part of the inner Circle.AustinChief is obviously part of the inner Circle.AustinChief is obviously part of the inner Circle.AustinChief is obviously part of the inner Circle.AustinChief is obviously part of the inner Circle.AustinChief is obviously part of the inner Circle.AustinChief is obviously part of the inner Circle.AustinChief is obviously part of the inner Circle.AustinChief is obviously part of the inner Circle.AustinChief is obviously part of the inner Circle.
   Reply With Quote
Old 08-13-2019, 06:54 PM   #181
DaFace DaFace is offline
Kind of a mod
 
DaFace's Avatar
 
Join Date: Aug 2005
Location: Donkey Land
Quote:
Originally Posted by Easy 6 View Post
So would another fundraiser help or not?



I have no idea how it all works, but are we somehow limited in what can be done at this point, sharing bandwidth with other boards etc?
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: 51,772
DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.
     Reply With Quote
Old 08-13-2019, 06:58 PM   #182
DaFace DaFace is offline
Kind of a mod
 
DaFace's Avatar
 
Join Date: Aug 2005
Location: Donkey Land
Quote:
Originally Posted by Superturtle View Post
This site is going to be damn near unreadable during game time, and that makes me a sad turtle.
Thus, the push to move chat onto an external site. It's pretty much guaranteed that it will be up and running fine.
Posts: 51,772
DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.
     Reply With Quote
Old 08-13-2019, 09:15 PM   #183
AustinChief AustinChief is offline
Administrator
 
AustinChief's Avatar
 
Join Date: Aug 2000
Location: Austin
Quote:
Originally Posted by DaFace View Post
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.
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,505
AustinChief is obviously part of the inner Circle.AustinChief is obviously part of the inner Circle.AustinChief is obviously part of the inner Circle.AustinChief is obviously part of the inner Circle.AustinChief is obviously part of the inner Circle.AustinChief is obviously part of the inner Circle.AustinChief is obviously part of the inner Circle.AustinChief is obviously part of the inner Circle.AustinChief is obviously part of the inner Circle.AustinChief is obviously part of the inner Circle.AustinChief is obviously part of the inner Circle.
 Thumbs Up 3 Thumbs Down 0     Reply With Quote
Old 08-13-2019, 09:29 PM   #184
007 007 is offline
Shaken. Not stirred.
 
007's Avatar
 
Join Date: Sep 2002
Location: London
Quote:
Originally Posted by AustinChief View Post
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.
I vote to change to the more efficient software. No, I don't know how to do it.
Posts: 65,554
007 is obviously part of the inner Circle.007 is obviously part of the inner Circle.007 is obviously part of the inner Circle.007 is obviously part of the inner Circle.007 is obviously part of the inner Circle.007 is obviously part of the inner Circle.007 is obviously part of the inner Circle.007 is obviously part of the inner Circle.007 is obviously part of the inner Circle.007 is obviously part of the inner Circle.007 is obviously part of the inner Circle.
     Reply With Quote
Old 08-13-2019, 09:41 PM   #185
scho63 scho63 is offline
Politically Incorrect
 
scho63's Avatar
 
Join Date: Feb 2009
Location: Scottsdale, AZ
Quote:
Originally Posted by AustinChief View Post
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.
What DB is this is using?
Posts: 50,509
scho63 is obviously part of the inner Circle.scho63 is obviously part of the inner Circle.scho63 is obviously part of the inner Circle.scho63 is obviously part of the inner Circle.scho63 is obviously part of the inner Circle.scho63 is obviously part of the inner Circle.scho63 is obviously part of the inner Circle.scho63 is obviously part of the inner Circle.scho63 is obviously part of the inner Circle.scho63 is obviously part of the inner Circle.scho63 is obviously part of the inner Circle.
     Reply With Quote
Old 08-13-2019, 10:13 PM   #186
DaFace DaFace is offline
Kind of a mod
 
DaFace's Avatar
 
Join Date: Aug 2005
Location: Donkey Land
Quote:
Originally Posted by scho63 View Post
What DB is this is using?
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:
  • Live with what we have. Possibly try a few things that probably won't help much. The end.
  • Try a hardware upgrade (new server with SSDs for storage maybe). Might not really help much. Tough to say. But could work. Very time intensive for AC.
  • Prune the database. Some loss of functionality (couldn't bump a 15-year old thread, which can be fun sometimes). Moderate amount of time for AC.
  • Move to completely different software. We'd gain a lot of features in "modern" software, but we'd lose some functionality people are used to here for sure. Rep would work differently. Thumbs would work differently. Categories and prefixes would work differently. Mod options like thread bans might not work. It would almost certainly fix the lag issues, but there are plenty of sites out there that have gone under due to major functionality changes, so it's not a decision to make lightly. Would be an insane amount of work for AC and high amount of work for others like me and Bearcat to try and tweak all of the settings to make things as familiar as possible.
Last edited by DaFace; 08-13-2019 at 10:37 PM..
Posts: 51,772
DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.
 Thumbs Up 3 Thumbs Down 0     Reply With Quote
Old 08-13-2019, 10:24 PM   #187
TribalElder TribalElder is offline
Arrowhead Trail of Tears
 
TribalElder's Avatar
 
Join Date: Oct 2012
Location: KansasCity
Percona >
Posts: 29,156
TribalElder is obviously part of the inner Circle.TribalElder is obviously part of the inner Circle.TribalElder is obviously part of the inner Circle.TribalElder is obviously part of the inner Circle.TribalElder is obviously part of the inner Circle.TribalElder is obviously part of the inner Circle.TribalElder is obviously part of the inner Circle.TribalElder is obviously part of the inner Circle.TribalElder is obviously part of the inner Circle.TribalElder is obviously part of the inner Circle.TribalElder is obviously part of the inner Circle.
     Reply With Quote
Old 08-13-2019, 10:29 PM   #188
scho63 scho63 is offline
Politically Incorrect
 
scho63's Avatar
 
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: 50,509
scho63 is obviously part of the inner Circle.scho63 is obviously part of the inner Circle.scho63 is obviously part of the inner Circle.scho63 is obviously part of the inner Circle.scho63 is obviously part of the inner Circle.scho63 is obviously part of the inner Circle.scho63 is obviously part of the inner Circle.scho63 is obviously part of the inner Circle.scho63 is obviously part of the inner Circle.scho63 is obviously part of the inner Circle.scho63 is obviously part of the inner Circle.
     Reply With Quote
Old 08-13-2019, 10:41 PM   #189
DaFace DaFace is offline
Kind of a mod
 
DaFace's Avatar
 
Join Date: Aug 2005
Location: Donkey Land
Quote:
Originally Posted by scho63 View Post
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.
If you're asking if there's a function in vBulletin to put things in a different table than the POST table, the answer is no. If the posts exist on ChiefsPlanet, they exist in the POST table.

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: 51,772
DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.
     Reply With Quote
Old 08-13-2019, 10:49 PM   #190
007 007 is offline
Shaken. Not stirred.
 
007's Avatar
 
Join Date: Sep 2002
Location: London
Quote:
Originally Posted by DaFace View Post
If you're asking if there's a function in vBulletin to put things in a different table than the POST table, the answer is no. If the posts exist on ChiefsPlanet, they exist in the POST table.

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.
To be honest, do we really need access to everything ever said here? I get wanting to leave this place intact for as long as possible but thats a lot of posts to track. Seems like it would be better to archive at least once per decade, maybe even every 5 years. I'm sure its not just that simple though.
Posts: 65,554
007 is obviously part of the inner Circle.007 is obviously part of the inner Circle.007 is obviously part of the inner Circle.007 is obviously part of the inner Circle.007 is obviously part of the inner Circle.007 is obviously part of the inner Circle.007 is obviously part of the inner Circle.007 is obviously part of the inner Circle.007 is obviously part of the inner Circle.007 is obviously part of the inner Circle.007 is obviously part of the inner Circle.
     Reply With Quote
Old 08-13-2019, 11:01 PM   #191
DaFace DaFace is offline
Kind of a mod
 
DaFace's Avatar
 
Join Date: Aug 2005
Location: Donkey Land
Quote:
Originally Posted by 007 View Post
To be honest, do we really need access to everything ever said here? I get wanting to leave this place intact for as long as possible but thats a lot of posts to track. Seems like it would be better to archive at least once per decade, maybe even every 5 years. I'm sure its not just that simple though.
Yeah, if it helps, I'm sure people will live with it. You could still theoretically go back and find stuff on the "archive" site. You just couldn't bump threads. So if someone wanted to say "what was my first post" or whatever, you could still do it.
Posts: 51,772
DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.
 Thumbs Up 1 Thumbs Down 0     Reply With Quote
Old 08-13-2019, 11:23 PM   #192
Kellerfox Kellerfox is offline
Starter
 
Kellerfox's Avatar
 
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: 786
Kellerfox must have mowed badgirl's lawn.Kellerfox must have mowed badgirl's lawn.Kellerfox must have mowed badgirl's lawn.Kellerfox must have mowed badgirl's lawn.Kellerfox must have mowed badgirl's lawn.Kellerfox must have mowed badgirl's lawn.Kellerfox must have mowed badgirl's lawn.Kellerfox must have mowed badgirl's lawn.Kellerfox must have mowed badgirl's lawn.Kellerfox must have mowed badgirl's lawn.Kellerfox must have mowed badgirl's lawn.
     Reply With Quote
Old 08-13-2019, 11:35 PM   #193
Dante84 Dante84 is offline
Tossed Salad & Scrambled Eggs
 
Dante84's Avatar
 
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,737
Dante84 is obviously part of the inner Circle.Dante84 is obviously part of the inner Circle.Dante84 is obviously part of the inner Circle.Dante84 is obviously part of the inner Circle.Dante84 is obviously part of the inner Circle.Dante84 is obviously part of the inner Circle.Dante84 is obviously part of the inner Circle.Dante84 is obviously part of the inner Circle.Dante84 is obviously part of the inner Circle.Dante84 is obviously part of the inner Circle.Dante84 is obviously part of the inner Circle.
 Thumbs Up 5 Thumbs Down 1     Reply With Quote
Old 08-13-2019, 11:37 PM   #194
007 007 is offline
Shaken. Not stirred.
 
007's Avatar
 
Join Date: Sep 2002
Location: London
Quote:
Originally Posted by Dante84 View Post
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.
One could argue the picture forum is an incredible strain. Just sayin.
Posts: 65,554
007 is obviously part of the inner Circle.007 is obviously part of the inner Circle.007 is obviously part of the inner Circle.007 is obviously part of the inner Circle.007 is obviously part of the inner Circle.007 is obviously part of the inner Circle.007 is obviously part of the inner Circle.007 is obviously part of the inner Circle.007 is obviously part of the inner Circle.007 is obviously part of the inner Circle.007 is obviously part of the inner Circle.
     Reply With Quote
Old 08-13-2019, 11:40 PM   #195
Dante84 Dante84 is offline
Tossed Salad & Scrambled Eggs
 
Dante84's Avatar
 
Join Date: Jan 2009
Location: ATX & OPKS
Quote:
Originally Posted by Dante84 View Post
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.
Just looked, 12 million posts on CP, 11k members

- 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,737
Dante84 is obviously part of the inner Circle.Dante84 is obviously part of the inner Circle.Dante84 is obviously part of the inner Circle.Dante84 is obviously part of the inner Circle.Dante84 is obviously part of the inner Circle.Dante84 is obviously part of the inner Circle.Dante84 is obviously part of the inner Circle.Dante84 is obviously part of the inner Circle.Dante84 is obviously part of the inner Circle.Dante84 is obviously part of the inner Circle.Dante84 is obviously part of the inner Circle.
 Thumbs Up 1 Thumbs Down 0     Reply With Quote
Reply
Page 13 of 32 « First 39101112 13 1415161723 Last »

« Previous Thread | > Nzoner's Game Room < | Next Thread »

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is On
Forum Jump




All times are GMT -6. The time now is 10:51 PM.

Contact Us - ChiefsPlanet - Archive - Top

Powered by vBulletin® Version 3.8.8
Copyright ©2000 - 2024, vBulletin Solutions, Inc.