If this is your first visit, check our documentation. To post, register or login.
Forums / Choosing Designers, Hosts, and Programmers / Host, Shared Servers, Load Question(s)

Host, Shared Servers, Load Question(s)

Started by joejoejoe on 25 Apr 2012, 7:03 AM · Views: 291

Results 1 to 15 of 15
25 Apr 2012, 7:03 AM
#1
joejoejoe avatar

joejoejoe

Zen Follower

Join Date:
Oct 2011
Location:
AZ
Posts:
383
Plugin Contributions:
0

Host, Shared Servers, Load Question(s)

It's a long buildup before the actual question. Please bear with me here.
My little store (under 225 items, 1 of each) is on a shared server with "unlimited" bandwidth. I moved to this host about 6 months ago. In six month my traffic has pretty much stayed the same, or even dropped - traffic for today looks like it did for last Tuesday, traffic for the week is about the same as last week, and so on. My bandwidth stats for the first 24 days of April:

HTTP 846.06 Meg IMAP 1.14 Meg POP3 0 Meg SMTP 0 Meg FTP 5.35 Meg Total 852.56 Meg (all of March was about 1.09 gig)

I know that for some of you pros running stores with a bajillion products and an advertising budget the size of the national debt, that this represents about 30 minutes of traffic - but I'm happy where I'm at. Or I was until I got an email from my host saying they were moving me to another server because, and I'm copy/paste from the email - "the server is experiencing some load issues that are tied to your account"
I went through my stats again - no spike in traffic, no massive calls to the server (I'm not under attack) nothing. Chat and phone to the host didn't get me any answer (they suggested I reply to the email, which I did - waiting on a reply). Googling my host and this issue it looks like a prelude to "we suggest you try a dedicated server."

So the questions (finally) - are those the numbers of a bandwidth hog? Do I need to bail on this host quickly or hear them out? If so, where do I go for a shared server with real unlimited bandwidth? (I guess that's a private PM to answer that one.) I can't see paying for a dedicated server - it's a hobby that pays for another hobby and the price of a dedicated server would, on a slow month, wipe out half a months profits. If it came to that I'll just shut up shop and find another way to pay for my 2nd hobby.

25 Apr 2012, 9:16 AM
#2
gilby avatar

gilby

Totally Zenned

Join Date:
Aug 2005
Location:
Vic, Oz
Posts:
1,816
Plugin Contributions:
0

Re: Host, Shared Servers, Load Question(s)

Who is your website host?

It doesn't seem a lot to me!

Ulimited bandwidth is a marketing ploy and not a real life expectation.
You are probably on an overloaded server and using a lot more resources (not bandwidth) than others that are not ecommerce sites on that server.
They probably want to move you so that they put another 200 non ecommerce sites on that server that won't use as many resources as you.

iow: get a web host that is setup for ecommerce.

25 Apr 2012, 9:48 AM
#3
joejoejoe avatar

joejoejoe

Zen Follower

Join Date:
Oct 2011
Location:
AZ
Posts:
383
Plugin Contributions:
0

Re: Host, Shared Servers, Load Question(s)

My host is inmotion.
I did a google search of my server name (biz112) and found a dozen commercial sites in the first two pages that are on my shared server. Two are stores running on php and look to be about the same size as mine - small to tiny. I found a ton of sites that had given up the ghost and if you click on them you get the generic "welcome to inmotion, this website died, go away, nothing to see." So I guess turnover is a bit high. I didn't find my site - which is good, I didn't mess up with Google this time.

The problem I'm having in finding a new host is that everyone, inmotion included, pretends that they are set up for ecommerce. And to prove it they all advertise how they have nice one-click installs of all the best ecommerce software - like zencart. And they all have the same glowing reviews on the same websites. Even that one everyone on this forum talks smack about (starts with a G, rhymes with fatty). Of course this seems to be one big game of scratch my back, I'll scratch yours. CNET refers to my host as "The #1 Business Host online." (It's a coincidence that my host advertises heavily on that site, I'm sure.)
And while I'm sure there are hosts that can reliably manage small ecommerce sites on shared servers - I find it hard to trust a single review that says their host is the greatest thing since the dawn of the internet, because for all I know they are sitting on a shared server with nobody else except two defunct blogs and a store that only specializes in selling drier lint.

25 Apr 2012, 1:36 PM
#4
rodg avatar

rodg

Deceased

Join Date:
Jan 2007
Location:
Australia
Posts:
6,263
Plugin Contributions:
4

Re: Host, Shared Servers, Load Question(s)

First thing, I agree with all gilby said, including the fact that your bandwidth usage doesn't appear excessive.

joejoejoe:

And while I'm sure there are hosts that can reliably manage small ecommerce sites on shared servers

There are, but even if I were allowed to recommend any, I probably wouldn't. The main reason is that many of them seem to be 'moving targets'. They can start out exceptional good, but over time just get worse and worse.

joejoejoe:

  • I find it hard to trust a single review that says their host is the greatest thing since the dawn of the internet, because for all I know they are sitting on a shared server with nobody else except two defunct blogs and a store that only specializes in selling drier lint.

Not to mention sites that get lots of good reviews, but still end up unsuitable for the purpose.

Sadly, you can't judge a server based on price either. One of the cheapest places we host with have turned out be be far more reliable and robust than I could ever have imagined. Another of our hosts cost us 3 times as much, is slower and suffers at least 2 or 3 outages each week (thankfully rarely more than a few minutes at a time).

In spite of this I couldn't recommend one over the other, because the more expensive one gives us full control over the DNS, and their tech support (on the rare times I've needed it) has been above and beyond what I could expect (as long as I get past the initial help desk droids first).
The cheap host limits what we can do with DNS (a serious drawback for our needs), but the tech support is non existent, they feed me nothing but ignorant billshot regardless of what I ask them.

We also have yet another host, also with very good prices, but it is a bare boned system in that it doesn't provide cPanel, Plesk or any other 'user friendly' interface.. its strictly SSH and FTP access only, which isn't suitable for the typical user. Perfect for our needs though.

Back to my 1st comment that a good host tends to be a moving target, to that end, about a month or so before any of our renewals are due, I tend to scour the 'net to see who is offering what, and if/when I find something that seems more appealing (for whatever reason) I have no qualms about taking up a months subscription (especially if they offer money back satisfaction guarantee), and loading it up to check performance/reliability. I also try to find some kind of 'fault' or have some kind of request to the support team to see what kind of responses I get. I don't mind bad support, if the price is right, but if the price is of 'commercial' grade then I expect a knowleable support team to back it up.

Occasionally I've asked for my money back within a few days (and surprisingly, I've not yet had an issue getting it), othertimes I've opted to stay with them and take out a hosting for a much longer period, migrating all of our sites over from the ones that have degraded over time, which then get dropped.

Basically what I'm saying here is that finding a good host is not only hard to find, they are even harder to recommend.

Oh, and don't let anyone ever tell you that you need a dedicated server. This is a performance trap for many people. Given the choice between a shared server with 100 users and 16gig of ram, and a dedicated server with <1gig Ram (and all else being equal), the shared server will outperform the dedicated server in almost every way.
This isn't to say that dedicated servers don't have their place. Just don't let yourself get talked into one because your shared host give the impression that your site it doing so well and is impacting on others.

Sorry about the rant... that's just the way I am :)

Cheers
Rod

NOTE: We are sorry that Rod is no longer with us.
We are grateful for all his contributions to the Zen Cart community.

Ozpost - The Ultimate Shipping module for Australian Merchants. Click these links for its Homepage, or Download from Zen-Cart.com.

25 Apr 2012, 2:50 PM
#5
joejoejoe avatar

joejoejoe

Zen Follower

Join Date:
Oct 2011
Location:
AZ
Posts:
383
Plugin Contributions:
0

Re: Host, Shared Servers, Load Question(s)

Thanks Rod, that's all good to know.

I went into phpmyadmin this morning (still waiting on a response from my host) and it looks like they rebooted the server Monday morning. Since then these are the numbers:

Server traffic: These tables show the network traffic statistics of this MySQL server since its startup.Traffic ø per hour
Received 28.0 GiB 0.6 GiB
Sent 0.6 TiB 12.0 GiB
Total 0.6 TiB 12.6 GiB
Connections ø per hour %
max. concurrent connections 501 --- ---
Failed attempts 11 k 236.68 0.39%
Aborted 5,311 111.20 0.19%
Total 2,866 k 60.02 k 100.00%

That seems like a lot. Since this is a shared server, am I right in assuming that those numbers are for every website on my shared server that is using an SQL database? Or is that all me up there? The database for my store is less than 3 meg, and the one for my blog (which is a page in my store) is barely over 1 meg.

25 Apr 2012, 3:59 PM
#6
rodg avatar

rodg

Deceased

Join Date:
Jan 2007
Location:
Australia
Posts:
6,263
Plugin Contributions:
4

Re: Host, Shared Servers, Load Question(s)

joejoejoe:

Thanks Rod, that's all good to know.

I went into phpmyadmin this morning (still waiting on a response from my host) and it looks like they rebooted the server Monday morning. Since then these are the numbers:

Server traffic: These tables show the network traffic statistics of this MySQL server since its startup.Traffic ø per hour
Received 28.0 GiB 0.6 GiB
Sent 0.6 TiB 12.0 GiB
Total 0.6 TiB 12.6 GiB
Connections ø per hour %
max. concurrent connections 501 --- ---
Failed attempts 11 k 236.68 0.39%
Aborted 5,311 111.20 0.19%
Total 2,866 k 60.02 k 100.00%

That seems like a lot.

It doesn't look too bad for a shared server.

joejoejoe:

Since this is a shared server, am I right in assuming that those numbers are for every website on my shared server that is using an SQL database?

Correct.

Here's some figures from two of our shared servers.

-----------Site A ---------------------------------
Traffic ø per hour
Received 41.5 GiB 88.3 MiB
Sent 0.9 TiB 2.0 GiB
Total 1.0 TiB 2.1 GiB
Connections ø per hour %
max. concurrent connections 241 --- ---
Failed attempts 24 k 50.08 0.33%
Aborted 1,008 2.10 0.01%
Total 7,228 k 15.03 k 100.00%

------------Site B ----------------------------
Traffic ø per hour
Received 18.3 GiB 0.3 GiB
Sent 0.4 TiB 6.5 GiB
Total 0.4 TiB 6.8 GiB
Connections ø per hour %
max. concurrent connections 93 --- ---
Failed attempts 4,076 73.30 0.21%
Aborted 2,082 37.44 0.11%
Total 1,932 k 34.74 k 100.00%

Site A was rebooted 20 days ago. Site B was rebooted 2 days ago.
The traffic from your server is somewhere in between these two.

There are a couple of interesting things about the figures from our servers.
1st, keep in mind that these stats are based on a per hour basis, so the uptimes have little or no bearing of the figures present.

Secondly, Site A is hosted on a very cheap server with a gaziilion users. Site B is on a somewhat more expensive server with a lot less users... This is observable by the total amount of traffic, Site B has less than half the traffic of Site A.

Now for the 'interesting' bit. Although Site B has half the traffic it has never reached the 20 day uptime that Site A currently has. Site B is a lot less reliable than Site A (one or two small outages per week on Site B. I can't recall the last time I had an outage on Site A).

In essence, this is suggesting that total traffic (per hour) is no guide as to how reliable either server is.

What is relevent though is the number of failed and aborted attempts made to each of them (all 3 including yours).

Site A 0.33% failed 0.01% aborted
Site B 0.21% failed 0.11% aborted
Yours 0.39% failed 0.19% aborted

From these figures your server is performing worse than both of ours in both respects. This is NOT good especially considering the number of outages and reboots our worst performing server has. Yours is almost certainly going to cause a few issues too. That said, the failed percentages aren't varying too wildly between the 3 of them..

Take special note of the % of aborted connections though .. Site A has 10 times less of these than Site B and ~20 times less than your site. This is a huge difference and clearly shows that our cheap, overloaded server is actually performing far better than the more expensive server with double the amount of traffic!

Whether this information is going to be of any use to you I cannot say. I am simply presenting it to show that traffic usage is a very bad indicator as to what is really going on, and that the failed attempts don't even tell us much.. The all important figure to watch is the % of aborted connections. You need to aim for <0.08% (or therabouts. Certainly less than 0.10).

Cheers
Rod

NOTE: We are sorry that Rod is no longer with us.
We are grateful for all his contributions to the Zen Cart community.

Ozpost - The Ultimate Shipping module for Australian Merchants. Click these links for its Homepage, or Download from Zen-Cart.com.

25 Apr 2012, 4:07 PM
#7
joejoejoe avatar

joejoejoe

Zen Follower

Join Date:
Oct 2011
Location:
AZ
Posts:
383
Plugin Contributions:
0

Re: Host, Shared Servers, Load Question(s)

RodG:

The all important figure to watch is the % of aborted connections. You need to aim for <0.08% (or therabouts. Certainly less than 0.10).

Cheers
Rod

That was all very useful info - thanks for a very easy to understand lesson. Have a great day!
Joe

25 Apr 2012, 7:25 PM
#8
mprough avatar

mprough

Totally Zenned

Join Date:
Nov 2007
Location:
Woodbine, Georgia, United States
Posts:
4,335
Plugin Contributions:
41

Re: Host, Shared Servers, Load Question(s)

Something to consider is that "load" has little and even nothing to do with bandwidth.

Lets say for example your cart is still running 1.3.8 and the whosonline table is running a bunch of overhead or you have 700 products on special.

Load is generally going to be a database issue with exorbitant queries or tables with errors/overhead. It can however be an issue with PHP erros as well.

You should inquire with them as to what processes are triggering the issue. They will likely respond with entries from their slow query log.

~Melanie

25 Apr 2012, 7:53 PM
#9
joejoejoe avatar

joejoejoe

Zen Follower

Join Date:
Oct 2011
Location:
AZ
Posts:
383
Plugin Contributions:
0

Re: Host, Shared Servers, Load Question(s)

They still haven't responded to my first email. And since I already tried calling and chatting and was told the only way to get an answer was email, there' s not much I can do there except assume inmotion doesn't want my business. I did check and they haven't moved me yet, even though the email said it was an "emergency." Of course logs are somethng they keep locked up tight but if they ever do decide to respond, I'll ask them to show me. I did check the SQL stats and the slow query log is only 36k. I don't know if that's the current size, or if that's the max size. Still - and I'm just winging it here - if I'm on 1.3.9h, no add-ons, 225 products in the database (and no google analytics or +1 or love-me-on-facebook, read-my-twitter-tweats scripts running either) then that seems pretty simple and any server that doesn't have Atari in its name should be able to handle whatever query is thrown at it.

25 Apr 2012, 7:54 PM
#10
mprough avatar

mprough

Totally Zenned

Join Date:
Nov 2007
Location:
Woodbine, Georgia, United States
Posts:
4,335
Plugin Contributions:
41

Re: Host, Shared Servers, Load Question(s)

What is your website address?

25 Apr 2012, 7:58 PM
#11
joejoejoe avatar

joejoejoe

Zen Follower

Join Date:
Oct 2011
Location:
AZ
Posts:
383
Plugin Contributions:
0

Re: Host, Shared Servers, Load Question(s)

I don't want this to end up in Google (at least not until I've moved on) so here's a tinyurl if that's kosher. I hope everyone doesn't hop over to look at once - I'm sure the resulting spike in traffic would be frowned upon by my host....

http://tinyurl.com/72m4qho

25 Apr 2012, 8:29 PM
#12
mprough avatar

mprough

Totally Zenned

Join Date:
Nov 2007
Location:
Woodbine, Georgia, United States
Posts:
4,335
Plugin Contributions:
41

Re: Host, Shared Servers, Load Question(s)

Okay, some suggestions to reduce the query load.

  1. Turn off or limit the new products sidebox and center box. This is currently querying a base of 71 products. Use featured and you can more easy control this area and it's queries.
  2. Turn off the "best sellers" sidebox.
  3. Turn off product counts in the admin and front end.
  4. Turn off downloads
  5. The manufacturer's side box is always a guilty party as well. Turn it off or hard code the links in an editable sidebox if you can.
  6. In your layout boxes controller turn off all boxes not in use.
  7. Turn off the footer IP address
  8. in the store manager empty your admin log and optimize your database.

These things will reduce the queries substantially. In PHP my admin sort your database tables using the OVERHEAD column and see which ones are running overhead or very large size. Optimize them.

25 Apr 2012, 9:57 PM
#13
joejoejoe avatar

joejoejoe

Zen Follower

Join Date:
Oct 2011
Location:
AZ
Posts:
383
Plugin Contributions:
0

Re: Host, Shared Servers, Load Question(s)

mprough:

Okay, some suggestions to reduce the query load.

  1. Turn off or limit the new products sidebox and center box. This is currently querying a base of 71 products. Use featured and you can more easy control this area and it's queries.
    I put it at 14 days, don't know why I had it at 90. I don't want to kill it completely because I have a lot of long-time customers who have bookmarked the "new" page and check in often to see if I've added stuff. (I could drop it down to a week and get away with that I guess).
  2. Turn off the "best sellers" sidebox.
    It's off - thanks, that always annoyed me anyhow since most of what I sell are one of a kind, so anytime I had two or more of an item and sold one it got stuck in that box.
  3. Turn off product counts in the admin and front end.
    I turned it off in admin, left it on in front - as a customer I don't like clicking on a subcategory and seeing "no products available"
  4. Turn off downloads
    It was already off.
  5. The manufacturer's side box is always a guilty party as well. Turn it off or hard code the links in an editable sidebox if you can.
    I had to keep it - I've got some customers who are collectors and come in search of certain tool makers and I don't have the skill (or energy) to write code.
  6. In your layout boxes controller turn off all boxes not in use.
    Done - didn't know I had so many "on" that weren't actually being used. (records, documents etc.)
  7. Turn off the footer IP address
    Done now - I actually usually had it off, only turned it on last week because I was lazy and wanted to quickly check that my home IP hadn't changed. (don't laugh! I was on the admin panel thinking of going down for maintenance.)
  1. in the store manager empty your admin log and optimize your database.
    Done again - I do this pretty often anyways. So I only cleaned up 3 days worth of data there.

In PHP my admin sort your database tables using the OVERHEAD column and see which ones are running overhead or very large size. Optimize them. Did it! Sessions (212k) and WHOIS Online (35k) They seem like small numbers, but I hit optimize and they went away. I'd never played with those buttons before because I'm pretty sure that someday I'm going to hit the wrong button and erase the entire internet.

Thanks for the help, every little bit is something. Still I can't help feeling that it's all such a small drop in the bucket with today's technology - if that host's shared server usage was a 55-gallon barrel full of coins, I just dropped my part down from a 4 pennies to 2.
Have a great day, Joe.

27 Apr 2012, 3:35 AM
#14
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,512
Plugin Contributions:
176

Re: Host, Shared Servers, Load Question(s)

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

29 Apr 2012, 6:22 PM
#15
coolcarpartsonline avatar

coolcarpartsonline

Totally Zenned

Join Date:
Feb 2008
Posts:
1,386
Plugin Contributions:
0

Re: Host, Shared Servers, Load Question(s)

I may be biased here but I am hosted with this host and been with them for about 18 months. I do have 3 sites with total of about 500,000 products running on a dedicated server. I have to say I am pleased with them, I used to go through a new host every few months for the last year before I switched to them.

I have ran into one problem with this host last year which was due to one script that was in a loop and was really overloading the server. They upgraded my hardware and software at their end, I optimized my script on my end and now been running fine for 6 months.

Server load is usually due to errors in the scripts you are using, and rarely are due to traffic unless you are CNN or something.

There are a lot of modules available that could optimize the query and cache some of the repeated queries to save loading time and increase speed. Just Google "Zen Cart Optimization" and read up on what to do.