hosted by liquidweb


Go Back   Web Hosting Talk : Web Hosting Main Forums : Web Hosting : Could a blog with about 1k unique daily cause excessive Mysql usage ?
Reply

Forum Jump

Could a blog with about 1k unique daily cause excessive Mysql usage ?

Reply Post New Thread In Web Hosting Subscription
 
Send news tip View All Posts Thread Tools Search this Thread Display Modes
  #1  
Old 07-19-2007, 10:30 PM
myanlien myanlien is offline
Newbie
 
Join Date: Jul 2007
Posts: 8

Could a blog with about 1k unique daily cause excessive Mysql usage ?


The question is like above. I just got my site suspended because the host said that my site was causing trouble. He gave my this log:
Code:
+--------+-----------------+-----------+-----------------+---------+-------+
| Id     | User            | Host      | db              | Command | Time  |
+--------+-----------------+-----------+-----------------+---------+-------+
| 351407 | xxxxxx_xxx     | localhost | xxxxxx_xxx     | Sleep   | 942   |
| 351864 | xxxxxx_xxx     | localhost | xxxxxx_xxx     | Sleep   | 840   |
| 352290 | mailwatch       | localhost | mailscanner     | Sleep   | 8     |
| 353244 | xxxxxx_xxx     | localhost | xxxxxx_xxx     | Sleep   | 434   |
| 353555 | xxxxxx_xxx     | localhost | xxxxxx_xxx     | Sleep   | 350   |
| 353592 | xxxxxx_xxx     | localhost | xxxxxx_xxx     | Sleep   | 340   |
I don't know what this log means but it's a wordpress site with wp-cache turned on, so i don't think it could cause so much usage for the server.



Sponsored Links
  #2  
Old 07-19-2007, 10:42 PM
ServerOrigin ServerOrigin is offline
Web Hosting Master
 
Join Date: Jun 2006
Location: NYC
Posts: 1,408
That is a possibility but I would find it easier to believe that there may be some hung processes. Are you running any special plugins other than the caching plugin?

Is your site ok for all ages? Try posting the address and let us take a look...May could give you a better idea by seeing the layout etc.

__________________
• ServerOrigin.Com • ethProxy™ DDoS Mitigation • Protect your current server in minutes! •
[Intrusion Detection • CDN • DDoS Protected VPS • DDoS Cloud Hosting • 99.99% SLA • AnyCast IP Services]
[Enterprise-Class DDoS Protection • Automated Datacenter Failover • Serving more than 1 million domains!]


  #3  
Old 07-19-2007, 10:56 PM
myanlien myanlien is offline
Newbie
 
Join Date: Jul 2007
Posts: 8
Yes, i run some plugins like poll and embedded video (but the videos are actually hosted on video sharing site)

Sorry my site is suspended right now, you only see a cpanel suspend page there. It did run normally in the past. In fact i was quite happy with its speed.

This month traffic is about 14Gb.

Sponsored Links
  #4  
Old 07-19-2007, 11:17 PM
Jedito Jedito is online now
Web Hosting Master
 
Join Date: Apr 2001
Location: Paradise
Posts: 11,527
Is that all your activity? 5 mysql connections in 15 minutes?
How many posts per page do you have?

__________________
Shared Web Hosting - Reseller Hosting - Semi-Dedicated Servers - SolusVM/XEN VPS
LiteSpeed Powered - R1Soft Continuous Data Protection - 24/7 Chat/Phone/Helpdesk Support - US/EU/Asia Servers
Cpanel/WHM - Softaculous - R1soft Backup - Litespeed - Cloudlinux -Site Builder- SSH support - Account Migration
DowntownHost LLC - In Business since 2001 - Toll Free:*1-877-384-6781*

  #5  
Old 07-19-2007, 11:37 PM
myanlien myanlien is offline
Newbie
 
Join Date: Jul 2007
Posts: 8
15 posts per page.

Is 5 mysql connections in 15 min considered normal ? I have really no clue about system or mysql load

  #6  
Old 07-19-2007, 11:44 PM
ServerOrigin ServerOrigin is offline
Web Hosting Master
 
Join Date: Jun 2006
Location: NYC
Posts: 1,408
No that isn't bad...I think we're all confused why you would be suspended for such limited connectivity. Who is the provider? Have you asked for a more detailed explanation and whether they are going to allow you to try and correct the issue?

__________________
• ServerOrigin.Com • ethProxy™ DDoS Mitigation • Protect your current server in minutes! •
[Intrusion Detection • CDN • DDoS Protected VPS • DDoS Cloud Hosting • 99.99% SLA • AnyCast IP Services]
[Enterprise-Class DDoS Protection • Automated Datacenter Failover • Serving more than 1 million domains!]


  #7  
Old 07-20-2007, 12:20 AM
Illustrious Illustrious is offline
…
 
Join Date: May 2007
Posts: 893
It depends. Some providers have very low usage limits for their shared users. If you're on one of those, you'll see suspensions for even minor spikes in traffic.

  #8  
Old 07-20-2007, 12:58 AM
YUPAPA YUPAPA is offline
Quant Trader
 
Join Date: May 2001
Location: HK
Posts: 2,974
Smile

I am assuming you are using persistent connection? Those are sleeping processes in the mySQL process list and they don't do anything - not even executing any SQL so they shouldn't be the one contributed to the system usage.

  #9  
Old 07-20-2007, 01:10 AM
Fixago Fixago is offline
Web Hosting Master
 
Join Date: Apr 2006
Posts: 556
If you get cutoff for 1k uniques per week you need to find another host. One of my slowest blogs does 4-5k uniques per week and no one bats an eye.

If you're not inclined to move, try optimizing your site by enabling a caching plugin to cut down the MySQL requests.

Since you're using WP, I highly doubt persistent connections are enabled, that would certainly be reason enough to suspend you (1 person could do enough damage with PC enabled by simply refreshing a number of times).

  #10  
Old 07-20-2007, 01:10 AM
uberjon uberjon is offline
Web Hosting Guru
 
Join Date: Jan 2007
Posts: 308
Quote:
Originally Posted by YUPAPA View Post
I am assuming you are using persistent connection? Those are sleeping processes in the mySQL process list and they don't do anything - not even executing any SQL so they shouldn't be the one contributed to the system usage.
exactly?

have you had any trouble over the last few weeks?

what was your traffic/bw like today? (or do you know?)

perhaps someone did something to your accnt? brute it and start abusing it or something?

i could see some issues if you had like 500 sleeping processes...... but that is just to few to cause issues.....

who is your host? or possible soon to be ex-host?

from how i read that log. i see no reason to suspend you.... that log shows nothing wrong imo.... maybe your host went or something?

  #11  
Old 07-20-2007, 07:05 AM
myanlien myanlien is offline
Newbie
 
Join Date: Jul 2007
Posts: 8
Quote:
Originally Posted by Fixago View Post
If you get cutoff for 1k uniques per week you need to find another host. One of my slowest blogs does 4-5k uniques per week and no one bats an eye.

If you're not inclined to move, try optimizing your site by enabling a caching plugin to cut down the MySQL requests.

Since you're using WP, I highly doubt persistent connections are enabled, that would certainly be reason enough to suspend you (1 person could do enough damage with PC enabled by simply refreshing a number of times).
It's 1k unique per day. But my site just got that amount of traffic for 3 weeks.

Yes i did have WP-Cache because i knew my blog will grow fast.
Quote:
Originally Posted by uberjon
have you had any trouble over the last few weeks?
No nothing. As i stated above, in overall i was happy with this host. Until this suspension.
Quote:
Originally Posted by uberjon
what was your traffic/bw like today? (or do you know?)
My account was suspended so i cant give you the exact number but 14G for this month. Thus about 600-700Mb a day.
Quote:
Originally Posted by uberjon
perhaps someone did something to your accnt? brute it and start abusing it or something?
I have no idea really. Maybe. But that's not the reason my host gave me anyway.
Quote:
Originally Posted by uberjon
who is your host? or possible soon to be ex-host?

from how i read that log. i see no reason to suspend you.... that log shows nothing wrong imo.... maybe your host went or something?
I don't want to publicize the name of the host now. I want to solve the problem with him first.

The support went bad recently. At first everything was fine, my tickets got responded within 5 hours, what is acceptable for me. Yesterday i saw the suspension page on my account, i was like wtf, so i submitted the ticket and wait ... well 15 hours for this simple answer and the log above:
Quote:
We had to suspend your site because of excessive mysql usage, it was causing trouble
No more explaination. And he closed the ticket. I must open a new ticket asking what is going on and if my site really caused trouble then give me access to db and files to move to another host. It was before i went to sleep and now i waked up with no answer.

At the beginning i thought going with a small host were a good idea, you get personal contact and if something wrong happens then you got informed first. Well, it was like that in the first month. But he wants to expand his business fast i guess, his promotion is running for 2 months now (i signed up through that promotion too, my mistake). And as you can see, things went wrong when the business is expanding too fast.

My question to the hosting providers in WHT is: If one of your customers causes the excessive usage that affects the server, would you suspend the site without any notice, or suspend it then send the customer an email, or give them some time to fix the issue ?

  #12  
Old 07-20-2007, 07:23 AM
Mxhub Mxhub is offline
Web Hosting Master
 
Join Date: May 2001
Posts: 2,162
Yes, when your blog get lot of traffic all of the sudden.. you will utilise more than the usual resource on your host server. Try sort out a solution with your host.

__________________
Affordable Managed Hosting Solutions for Professional & Business since 2001
Mxhub.com - Global : USA - UK - Canada - Europe - Asia Pacific



  #13  
Old 07-20-2007, 07:27 AM
uberjon uberjon is offline
Web Hosting Guru
 
Join Date: Jan 2007
Posts: 308
Quote:
Originally Posted by myanlien View Post
My question to the hosting providers in WHT is: If one of your customers causes the excessive usage that affects the server, would you suspend the site without any notice, or suspend it then send the customer an email, or give them some time to fix the issue ?
actually as long as i havent went over my bw budget for the month. or something is actually "illegal" going on. i would expect them to email me 2x. once right away. then another 12 hours later. and wait 12 hours after that. then take action. (or better yet. call me!)

if your traffic hasnt increased very much/very fast. he could have given you ample warning weeks ago. instead of just suspending it!

  #14  
Old 07-20-2007, 07:34 AM
myanlien myanlien is offline
Newbie
 
Join Date: Jul 2007
Posts: 8
No i would not call the traffic on my site is "lot of traffic all of the sudden". The traffic grows steadily over a month. It's absolute not any kind of dugg or slahsdotted. If it's like that then i would be very happy.

  #15  
Old 07-20-2007, 08:21 AM
040Hosting 040Hosting is offline
Community Liaison
 
Join Date: May 2006
Location: EU & USA
Posts: 3,674
Quote:
Originally Posted by myanlien View Post
My question to the hosting providers in WHT is: If one of your customers causes the excessive usage that affects the server, would you suspend the site without any notice, or suspend it then send the customer an email, or give them some time to fix the issue ?
We have seen some of these happening, and before it gets crazy we contact the customer and try to solve the issue. This is what normally happens.

But we also had a customers where the guestbook was spammed with messages causing the system to slow down, we disabled this guestbook and contact the customer (once again no suspension).

And if we do not have another way, i.e. contacted the customer and other users are badly affected by your account, yes, we would suspend you. But i don't believe the suspension in your case is the bad part of your story, the lack of response to the created ticket is.

Try to talk it over with your host, ask him why support has been so slow, and how they will improve this service to you.

Good luck with your blog!

__________________
» cPanel Servers in Europe (Strasbourg, Amsterdam & London), USA (Dallas, St.Louis), Asia (Singapore) | Follow us at Twitter: @040hosting
»
| Shared | Reseller | (managed) Dedicated Hosting | 040Hosting (Registered company #17093425 KVK Eindhoven, The Netherlands)



Last edited by 040Hosting; 07-20-2007 at 08:22 AM. Reason: typo
Reply

Related posts from TheWhir.com
Title Type Date Posted
Google Releases Hosted Database Service Cloud SQL to General Availability Web Hosting News 2014-02-12 13:46:02
Google Cloud Platform Introduces Billing Export Feature Web Hosting News 2013-12-27 14:24:30
Google Cloud Provides Support For Native MySQL Connections Web Hosting News 2013-11-01 14:36:06
Zynga Open Sources Server Performance Monitoring Tool Web Hosting News 2013-08-14 14:12:10
UK Hosting Giant iomart Acquires Hosting UK for $2.4 Million Web Hosting News 2012-12-05 10:26:17


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Postbit Selector

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 Off
HTML code is Off

Forum Jump
Login:
Log in with your username and password
Username:
Password:



Forgot Password?
Advertisement:
Web Hosting News:



 

X

Welcome to WebHostingTalk.com

Create your username to jump into the discussion!

WebHostingTalk.com is the largest, most influentual web hosting community on the Internet. Join us by filling in the form below.


(4 digit year)

Already a member?