Previous Thread
Next Thread
Print Thread
Rate Thread
looking to streamline my threads 6.5 database #312606
01/11/2007 1:14 AM
01/11/2007 1:14 AM
Joined: Nov 2000
Posts: 1,251
rob's pad -- where it takes sk...
drkknght Offline OP
Kahuna
drkknght  Offline OP
Kahuna
Joined: Nov 2000
Posts: 1,251
rob's pad -- where it takes sk...
my forum has grown overtly bulky and huge. 2500 uniques a day and a 600 mb mysql database with 6+ years o'stuff. problem is, my web hosts don't like it all that much, and yelled at me to clean up my act. according to them, i use 3% of the shared server's CPU and 1.5% of the mysql database -- all from my heavy-traffic forum.

bigger problem is, i don't really know how to streamline / update / whatever the database or forums.

any general tips?

Sponsored Links
Re: looking to streamline my threads 6.5 database [Re: drkknght] #312613
01/11/2007 2:18 AM
01/11/2007 2:18 AM
Joined: Jan 2000
Posts: 5,938
Portland, OR, USA
Gizmo Offline

UBB.Dev / UBB.Wiki Owner
Time Lord
Gizmo  Offline

UBB.Dev / UBB.Wiki Owner
Time Lord
Joined: Jan 2000
Posts: 5,938
Portland, OR, USA
If youre that large, you should really think about using a Dedicated Server or VPS; its completely understandable that you utilize those resources with a large forum.

If youre getting that much TRAFFIC theres not much you can do besides move to a VPS or a Dedicated Server (if funding permits I recommend the dedicated option).

If it was simply boggy scripts id say to police your webspace, but with that kind of traffic it's likely just standard browsing.


UBB.Dev - Putting Dev into UBB.threads
Company: VNC Web Services - UBB.threads Scripts and Scripting, Install and Upgrade Services, Site and Server Maintenance.
Forums: A Gardeners Forum, Scouters World, and UGN Security
UBB.Threads: My UBB Themes, UBB.Sitemaps
Re: looking to streamline my threads 6.5 database [Re: Gizmo] #312615
01/11/2007 3:30 AM
01/11/2007 3:30 AM
Joined: Nov 2000
Posts: 1,251
rob's pad -- where it takes sk...
drkknght Offline OP
Kahuna
drkknght  Offline OP
Kahuna
Joined: Nov 2000
Posts: 1,251
rob's pad -- where it takes sk...
heya gizmo

thats more or less my host's (lunarpages) suggestion, as well. the problem being the current package i'm in is roughly 10 / month, and the next level up (VPS) is 40+.

and, in order to make a smooth transition, i'd have to have them install cpanel, which is another 35 / month, yadda yadda. just seems like a nightmarish kinda scenario.

i have trimmed down some aspects -- cutting a lot of my IIP frontpage and sidebar, making it 10 topics per page instead of 20, last 6 active months instead of all, etc. hopefully that will pull back the dent i'm making in the overall processor for them.

but, the general bit of feedback i'm getting is that, odds are, its just time to move on/up.

Re: looking to streamline my threads 6.5 database [Re: drkknght] #312616
01/11/2007 5:17 AM
01/11/2007 5:17 AM
Joined: Jan 2000
Posts: 5,938
Portland, OR, USA
Gizmo Offline

UBB.Dev / UBB.Wiki Owner
Time Lord
Gizmo  Offline

UBB.Dev / UBB.Wiki Owner
Time Lord
Joined: Jan 2000
Posts: 5,938
Portland, OR, USA
cpanel isn't needed, have them install webmin, it's free; granted it's a little more advanced, but if you have webmin/usermin/virtualmin installed you can do just about everything that cpanel can do.

And larger sites need more resources, it's a given, and theres not much to get around that; you should think of doing some advertising to help subsidize costs.

I'd be willing to help you with setup/consulting for a fee; it'd be well cheaper than paying for cpanel indefinately lol, i run a VPS with CentOS for my site, all of the current software (PHP/MySQL) and webmin, no need for any fancy overpriced control panel, webmin lets me add domains, add emails, edit users, etc etc etc; it just takes some getting used to...


UBB.Dev - Putting Dev into UBB.threads
Company: VNC Web Services - UBB.threads Scripts and Scripting, Install and Upgrade Services, Site and Server Maintenance.
Forums: A Gardeners Forum, Scouters World, and UGN Security
UBB.Threads: My UBB Themes, UBB.Sitemaps
Re: looking to streamline my threads 6.5 database [Re: Gizmo] #312624
01/11/2007 4:24 PM
01/11/2007 4:24 PM
Joined: Nov 2000
Posts: 1,251
rob's pad -- where it takes sk...
drkknght Offline OP
Kahuna
drkknght  Offline OP
Kahuna
Joined: Nov 2000
Posts: 1,251
rob's pad -- where it takes sk...
the cpanel issue was not so much about my frontend using, but their backend installation. the shared plan i have now uses it, and they said in order to move everything over smoothly and quickly, the new plan would have to have it. if i didn't install it, the transition would be mostly my moving everything over and re-setting up the database n'such ... which is not exactly my specialty smile

i've tried streamlining what i can on the site, but based on the latest reports i've seen, i'm still too far away to go back. looks like i have to go up to the VPS, so i'll probably take you up on your offer!

if you'd like to talk turkey, give me an email:

[email protected]

Sponsored Links
Re: looking to streamline my threads 6.5 database [Re: Gizmo] #312625
01/11/2007 4:26 PM
01/11/2007 4:26 PM
Joined: Mar 2000
Posts: 25,587
Texas
AllenAyres Offline
I type Like navaho
AllenAyres  Offline
I type Like navaho
Joined: Mar 2000
Posts: 25,587
Texas
For a large forum there's not much you can do, besides pruning (which I hate to do, I still have stuff from 1999 wink ). It sounds like it's time to upgrade hosting, and/or move to threads 7 - the caching is bound to make it easier on the server. Keep in mind the mysql(4+)/php(4.3+) requirements for threads 7 if you upgrade, your older server probably doesn't run current software.


- Allen wavey
- What Drives You?
Re: looking to streamline my threads 6.5 database [Re: AllenAyres] #312630
01/11/2007 7:59 PM
01/11/2007 7:59 PM
Joined: Nov 2000
Posts: 1,251
rob's pad -- where it takes sk...
drkknght Offline OP
Kahuna
drkknght  Offline OP
Kahuna
Joined: Nov 2000
Posts: 1,251
rob's pad -- where it takes sk...
whats up, double a!

i've contemplated upgrading, but... i have my current forum customized just so nicely at this point. i'd have to tour around 7 for awhile, first -- make sure it can do everything i want i to do.

this move is a much more immediate thing

Re: looking to streamline my threads 6.5 database [Re: drkknght] #312632
01/11/2007 8:30 PM
01/11/2007 8:30 PM
Joined: Jan 2000
Posts: 5,938
Portland, OR, USA
Gizmo Offline

UBB.Dev / UBB.Wiki Owner
Time Lord
Gizmo  Offline

UBB.Dev / UBB.Wiki Owner
Time Lord
Joined: Jan 2000
Posts: 5,938
Portland, OR, USA
They're full of crap and just want you to pay $35/mo indefinately for cpanel; Trust me, it is NOT hard to re-configure things... I moved my 12 sites off of an Ensim server to a webmin server and it would be the exact same thing.

Simply setup your email addresses manually (no big deal) then tar your old website data and dump your sql database; then import the database on the new machine and untar the data on the new machine and you're done...

As i said, I'd be more than willing to assist for a fee; I did allen's server with full configuration and updates of system services and even undercharged myself for the time spent on it wink...

I'll ship you off an email in a bit wink


UBB.Dev - Putting Dev into UBB.threads
Company: VNC Web Services - UBB.threads Scripts and Scripting, Install and Upgrade Services, Site and Server Maintenance.
Forums: A Gardeners Forum, Scouters World, and UGN Security
UBB.Threads: My UBB Themes, UBB.Sitemaps
Re: looking to streamline my threads 6.5 database [Re: Gizmo] #312639
01/12/2007 12:35 AM
01/12/2007 12:35 AM
Joined: Nov 2000
Posts: 1,251
rob's pad -- where it takes sk...
drkknght Offline OP
Kahuna
drkknght  Offline OP
Kahuna
Joined: Nov 2000
Posts: 1,251
rob's pad -- where it takes sk...
not hard for you! thats why you're hired! smile

i honestly don't use cpanel or any admin controls that much. once in a very rare while, when i have to add an email address or ftp account or whatever, and... typically, once that stuff is set, it stays set. so, i have no preference whether its cpanel or anything else.

i'll start making backups of stuff. just shoot me an email and lemme know prices or prep-issues or whatever.

Re: looking to streamline my threads 6.5 database [Re: drkknght] #312640
01/12/2007 1:09 AM
01/12/2007 1:09 AM
Joined: Jan 2000
Posts: 5,938
Portland, OR, USA
Gizmo Offline

UBB.Dev / UBB.Wiki Owner
Time Lord
Gizmo  Offline

UBB.Dev / UBB.Wiki Owner
Time Lord
Joined: Jan 2000
Posts: 5,938
Portland, OR, USA
It's also wise for me to point out that most cpanels can also be intensive on your server wink...

Simply put, tell them you want a vps (or dedicated server) with CentOS (if it's available, if not Fedora) and that you'll have someone else do your migrations and configuration. Also ask if they'll install Webmin for you, if not I can do it, it's nothing that big...

You should try out a webmin demo, it's fairly easy to use wink... Ive been using it for a while; it dumbs down most linux tasks.


UBB.Dev - Putting Dev into UBB.threads
Company: VNC Web Services - UBB.threads Scripts and Scripting, Install and Upgrade Services, Site and Server Maintenance.
Forums: A Gardeners Forum, Scouters World, and UGN Security
UBB.Threads: My UBB Themes, UBB.Sitemaps
Sponsored Links
Re: looking to streamline my threads 6.5 database [Re: Gizmo] #312641
01/12/2007 1:52 AM
01/12/2007 1:52 AM
Joined: Nov 2000
Posts: 1,251
rob's pad -- where it takes sk...
drkknght Offline OP
Kahuna
drkknght  Offline OP
Kahuna
Joined: Nov 2000
Posts: 1,251
rob's pad -- where it takes sk...
this is all the stuff their VPS offers:

http://www.lunarpages.com/virtual-private-server/

seems pretty all-encompassing, and includes that centOS

Re: looking to streamline my threads 6.5 database [Re: drkknght] #312642
01/12/2007 2:02 AM
01/12/2007 2:02 AM
Joined: Jan 2000
Posts: 5,938
Portland, OR, USA
Gizmo Offline

UBB.Dev / UBB.Wiki Owner
Time Lord
Gizmo  Offline

UBB.Dev / UBB.Wiki Owner
Time Lord
Joined: Jan 2000
Posts: 5,938
Portland, OR, USA
Heh, that's actually not that bad; pricing is standard, but the space is better than what several others do for the same price... bw is decent as well.

The onlything that bothers me on that is that they don't specify how much guarenteed memory you're allotted, nor do they show how much is burstable...


UBB.Dev - Putting Dev into UBB.threads
Company: VNC Web Services - UBB.threads Scripts and Scripting, Install and Upgrade Services, Site and Server Maintenance.
Forums: A Gardeners Forum, Scouters World, and UGN Security
UBB.Threads: My UBB Themes, UBB.Sitemaps
Re: looking to streamline my threads 6.5 database [Re: Gizmo] #314416
06/16/2007 1:42 AM
06/16/2007 1:42 AM
Joined: Nov 2003
Posts: 491
SoCal
S
sirdude Offline
Enthusiast
sirdude  Offline
Enthusiast
S
Joined: Nov 2003
Posts: 491
SoCal
VPS's get 512mb (i had a vps with them). the machine that they share the VPS's on are 8gig Ram and 25 users (i think). duallie xeons.

worked fine for me, but i decided to go for broke with a dedicated.


Donate Today!
Donate via PayPal

Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.

Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
Recommended Hosts
We have personally worked with, and recommend, the following Web Hosts:
· Stable Host
· Blue Host
· Interserver.net
Visit Us on Facebook
Member Spotlight
Gizmo
Gizmo
Portland, OR, USA
Posts: 5,938
Joined: January 2000
Show All Member Profiles 
Forum Statistics
Forums64
Topics37,448
Posts293,484
Members13,793
Most Online1,498
Mar 17th, 2017
Top Posters(All Time)
AllenAyres 25,587
JoshPet 11,330
Rick 8,373
LK 7,396
Lord Dexter 6,503
Gizmo 5,938
Greg Hard 5,533
Top Posters(30 Days)
isaac 4
Today's Statistics
Currently Online 685
Topics Created 0
Posts Made 0
Users Online 0
Birthdays 18
The UBB.Developers Network (UBB.Dev/Threads.Dev) is ©2000-2018 VNC Web Services

 
Powered by UBB.threads™ PHP Forum Software 7.6.2
(Preview build 20180611.dev)
Page Time: 0.084s Queries: 15 (0.052s) Memory: 3.3309 MB (Peak: 3.5421 MB) Zlib enabled. Server Time: 2018-06-19 01:18:45 UTC