Status
Not open for further replies.

LuDawgs

Customer
Hey, guys. For the past day, my host has been shutting off my account and taking my site offline. I think this is due to the number of connections that are running and I'm exceeding server load. Do you know if this has ever been a problem in the past? My site is relatively small with only about 25 members online at a time. I'm not sure what's causing the issue. Can someone please help? Could it be that I have installed something improperly? Is there a need to repair tables after doing any changes? What could be causing me to max out my allowable CPU? Here is the note from Hostgator:

Hello,

This message is to advise you of a temporary block placed on your database. The database was found to be consuming an inordinate amount of processor time, to the point of degrading overall system performance. While we do limit each account to no more than 25% of a system's CPU in our terms of service, we do not actively disable accounts until they greatly exceed that number, which is what happened in this case. Requests to this database may become degraded by limiting the maximum number of queries or connections for a limited amount of time, or if there are sustained issues, ultimately we may be forced to block access to this database until the issue has been resolved.

Resolving this situation may be as simple as adding additional indexes to your database, optimizing the queries used, or something equally easy. If not, it may simply be a matter of moving this database to dedicated services, as it may have outgrown a shared environment.

If you believe you have a solution to this overuse, we are happy to discuss the situation with you and possibly reinstate the database on the server. Otherwise, we will be happy to assist you with the upgrade process if a dedicated server is the most appropriate solution. Thank you, and we look forward to hearing from you shortly.

~~~
Excessive MySQL activity is caused by (a) a long-running process that locks a table, causing other queries to back up, (b) a query that is not optimized ][example: select all from ... and involving a large or complex query], (c) huge table copies/maintenance during peak hours.

NOTE:, the following are just possible fixes or suggestions, and are not endorsed or supported by HostGator. They are included in the hope that they may apply to your situation, and/or help you reduce the amount of resources your SQL queries consume. As always, it's best to backup any data before making any changes or adjustments.

First and foremost, you may need to optimize your tables. The frequency depends on the size and usage of the database, but most databases would benefit from doing something like this on a yearly basis: a) Enter your phpMyAdmin/MySQL control panel. Click on the database (not the table, the database name), and on the right hand column your tables should be listed. Scroll down till you see the .Check all. link. Click on that link, make sure all database tables are checked and then from the drop-down next to it, and carefully select .Optimize table..

Additionally, adding indexes to your table(s) may improve performance. If you're not sure what you're doing, it's best not to modify any table; caution is recommended. There are various articles (Four Ways to Optimize Your MySQL Database - Developer.com and Optimizing MySQL: Queries and Indexes — DatabaseJournal.com). It may be best to Google for something like [Your Software Name] MySQL indexes for suggestions.

If you reply back to this with your IP address (IP Address Retrieval) we will be more than happy to go ahead enable HTTP access for you, so that you can safely work on the script without it causing further issues. Please let us know how you would like to proceed.


CPU_TIME:1 table_rows_read:14583 SELECTS:776 ROWS_UPDATED:202 ROWS_FETCHED:0 BUSY_TIME:1431 ONNECTED_TIME:3570 BYTES_SENT:45633733 BYTES_RECEIVED:767745 WAIT_TIME:1430


Top table row reads:
DB_USER: ludawgs_mysql -- TOTAL_CONNECTIONS: 126 -- CONNECTED_TIME: 7351 -- CPU_TIME: 1 -- TABLE_ROW_READS: 15988 -- SELECT_COMMANDS: 887 -- UPDATE_COMMANDS: -- BUSY_TIME: 1483 -- BYTES_SENT: 48398206 -- BYTES_RECEIVED: 900484 -- WAIT_TIME (IO): 1482



Top WAIT (IO) TIME:
DB_USER: ludawgs_mysql -- TOTAL_CONNECTIONS: 126 -- CONNECTED_TIME: 7351 -- CPU_TIME: 1 -- TABLE_ROW_READS: 15988 -- SELECT_COMMANDS: 887 -- UPDATE_COMMANDS: -- BUSY_TIME: 1483 -- BYTES_SENT: 48398206 -- BYTES_RECEIVED: 900484 -- WAIT_TIME (IO): 1482



ludawgs 1585 0.0 0.1 43384 20708 ? DN 17:57 0:00 /usr/bin/php /home/ludawgs/public_html/calendar.php
ludawgs 1692 0.0 0.1 42408 19732 ? DN 17:57 0:00 /usr/bin/php /home/ludawgs/public_html/forum.php
ludawgs 1704 0.0 0.1 42412 19760 ? DN 17:57 0:00 /usr/bin/php /home/ludawgs/public_html/forum.php
ludawgs 1710 0.0 0.1 42652 20068 ? DN 17:57 0:00 /usr/bin/php /home/ludawgs/public_html/ajax.php
ludawgs 1728 0.0 0.1 42692 20172 ? DN 17:57 0:00 /usr/bin/php /home/ludawgs/public_html/newreply.php
ludawgs 2859 0.0 0.1 42968 20500 ? DN 17:58 0:00 /usr/bin/php /home/ludawgs/public_html/showthread.php
ludawgs 3179 0.0 0.1 42828 20132 ? DN 17:59 0:00 /usr/bin/php /home/ludawgs/public_html/forum.php
ludawgs 3199 0.0 0.1 43224 20580 ? DN 17:59 0:00 /usr/bin/php /home/ludawgs/public_html/showthread.php
ludawgs 3379 0.1 0.1 42652 20080 ? DN 17:59 0:00 /usr/bin/php /home/ludawgs/public_html/ajax.php
ludawgs 3390 0.1 0.1 42640 20048 ? DN 17:59 0:00 /usr/bin/php /home/ludawgs/public_html/search.php
ludawgs 3990 0.1 0.1 42516 19948 ? DN 18:00 0:00 /usr/bin/php /home/ludawgs/public_html/forum.php
ludawgs 4004 0.1 0.1 43212 20616 ? DN 18:00 0:00 /usr/bin/php /home/ludawgs/public_html/showthread.php
ludawgs 4321 0.1 0.1 42640 20048 ? DN 18:00 0:00 /usr/bin/php /home/ludawgs/public_html/search.php
ludawgs 4673 0.1 0.1 42408 19764 ? DN 18:00 0:00 /usr/bin/php /home/ludawgs/public_html/forum.php
ludawgs 4712 0.1 0.1 42652 20080 ? DN 18:00 0:00 /usr/bin/php /home/ludawgs/public_html/ajax.php
ludawgs 4759 0.1 0.1 42828 20144 ? DN 18:00 0:00 /usr/bin/php /home/ludawgs/public_html/forum.php
ludawgs 4784 0.0 0.1 42828 20136 ? DN 18:00 0:00 /usr/bin/php /home/ludawgs/public_html/forum.php
ludawgs 4819 0.1 0.1 42968 20508 ? DN 18:00 0:00 /usr/bin/php /home/ludawgs/public_html/showthread.php
ludawgs 4822 0.1 0.1 43220 20640 ? DN 18:00 0:00 /usr/bin/php /home/ludawgs/public_html/showthread.php
ludawgs 4847 0.1 0.1 42408 19760 ? DN 18:00 0:00 /usr/bin/php /home/ludawgs/public_html/forum.php
ludawgs 4966 0.1 0.1 42828 20136 ? DN 18:01 0:00 /usr/bin/php /home/ludawgs/public_html/forum.php
ludawgs 5079 0.1 0.1 42828 20144 ? DN 18:01 0:00 /usr/bin/php /home/ludawgs/public_html/forum.php
ludawgs 5125 0.1 0.1 42412 19772 ? DN 18:01 0:00 /usr/bin/php /home/ludawgs/public_html/forum.php
ludawgs 5143 0.1 0.1 43024 20412 ? DN 18:01 0:00 /usr/bin/php /home/ludawgs/public_html/forumdisplay.php
ludawgs 19702 0.0 0.0 3024 908 ? SN 16:59 0:00 imap

Wed Feb 29 18:03:30 CST 2012
Running Processes:
ludawgs 1585 0.0 0.1 43384 20708 ? DN 17:57 0:00 /usr/bin/php /home/ludawgs/public_html/calendar.php
ludawgs 1692 0.0 0.1 42408 19732 ? DN 17:57 0:00 /usr/bin/php /home/ludawgs/public_html/forum.php
ludawgs 1704 0.0 0.1 42412 19760 ? DN 17:57 0:00 /usr/bin/php /home/ludawgs/public_html/forum.php
ludawgs 1710 0.0 0.1 42652 20068 ? DN 17:57 0:00 /usr/bin/php /home/ludawgs/public_html/ajax.php
ludawgs 1728 0.0 0.1 42692 20172 ? DN 17:57 0:00 /usr/bin/php /home/ludawgs/public_html/newreply.php
ludawgs 2859 0.0 0.1 42968 20500 ? DN 17:58 0:00 /usr/bin/php /home/ludawgs/public_html/showthread.php
ludawgs 3179 0.0 0.1 42828 20132 ? DN 17:59 0:00 /usr/bin/php /home/ludawgs/public_html/forum.php
ludawgs 3199 0.0 0.1 43224 20580 ? DN 17:59 0:00 /usr/bin/php /home/ludawgs/public_html/showthread.php
ludawgs 3379 0.1 0.1 42652 20080 ? DN 17:59 0:00 /usr/bin/php /home/ludawgs/public_html/ajax.php
ludawgs 3390 0.1 0.1 42640 20048 ? DN 17:59 0:00 /usr/bin/php /home/ludawgs/public_html/search.php
ludawgs 3990 0.1 0.1 42516 19948 ? DN 18:00 0:00 /usr/bin/php /home/ludawgs/public_html/forum.php
ludawgs 4004 0.1 0.1 43212 20616 ? DN 18:00 0:00 /usr/bin/php /home/ludawgs/public_html/showthread.php
ludawgs 4321 0.1 0.1 42640 20048 ? DN 18:00 0:00 /usr/bin/php /home/ludawgs/public_html/search.php
ludawgs 4673 0.1 0.1 42408 19764 ? DN 18:00 0:00 /usr/bin/php /home/ludawgs/public_html/forum.php
ludawgs 4712 0.1 0.1 42652 20080 ? DN 18:00 0:00 /usr/bin/php /home/ludawgs/public_html/ajax.php
ludawgs 4759 0.1 0.1 42828 20144 ? DN 18:00 0:00 /usr/bin/php /home/ludawgs/public_html/forum.php
ludawgs 4784 0.0 0.1 42828 20136 ? DN 18:00 0:00 /usr/bin/php /home/ludawgs/public_html/forum.php
ludawgs 4819 0.1 0.1 42968 20508 ? DN 18:00 0:00 /usr/bin/php /home/ludawgs/public_html/showthread.php
ludawgs 4822 0.1 0.1 43220 20640 ? DN 18:00 0:00 /usr/bin/php /home/ludawgs/public_html/showthread.php
ludawgs 4847 0.1 0.1 42408 19760 ? DN 18:00 0:00 /usr/bin/php /home/ludawgs/public_html/forum.php
ludawgs 4966 0.1 0.1 42828 20136 ? DN 18:01 0:00 /usr/bin/php /home/ludawgs/public_html/forum.php
ludawgs 5079 0.1 0.1 42828 20144 ? DN 18:01 0:00 /usr/bin/php /home/ludawgs/public_html/forum.php
ludawgs 5125 0.1 0.1 42412 19772 ? DN 18:01 0:00 /usr/bin/php /home/ludawgs/public_html/forum.php
ludawgs 5143 0.1 0.1 43024 20412 ? DN 18:01 0:00 /usr/bin/php /home/ludawgs/public_html/forumdisplay.php
ludawgs 19702 0.0 0.0 3024 908 ? SN 16:59 0:00 imap

Running Queries:

Current Site Requests:
108.49.100.219 ludawgs.com /ajax.php?do=autosave
108.49.100.219 ludawgs.com /newreply.php?do=postreply&t=6567
108.49.100.219 ludawgs.com /search.php?do=getnew&contenttype=vBForum_Post
108.49.100.219 ludawgs.com /search.php?do=getnew&contenttype=vBForum_Post
108.70.93.198 ludawgs.com /attachment.php?attachmentid=1361&d=1330537013
108.70.93.198 ludawgs.com /images/pagination/previous-right.png
12.188.74.18 ludawgs.com /ckeditor.php?l=en&t=1308796747
12.188.74.18 ludawgs.com /clear.gif
12.188.74.18 ludawgs.com /clientscript/ckeditor/skins/kama/editor.css?t=B37D54V
12.188.74.18 ludawgs.com /clientscript/ckeditor/skins/kama/mainui.css
12.188.74.18 ludawgs.com /clientscript/ckeditor/skins/kama/menu.css
12.188.74.18 ludawgs.com /clientscript/ckeditor/skins/kama/panel.css
12.188.74.18 ludawgs.com /clientscript/ckeditor/skins/kama/reset.css
12.188.74.18 ludawgs.com /clientscript/ckeditor/skins/kama/richcombo.css
12.188.74.18 ludawgs.com /clientscript/ckeditor/skins/kama/toolbar.css
12.188.74.18 ludawgs.com /clientscript/ckeditor_config.js?v=417&t=B37D54V
12.188.74.18 ludawgs.com /image.php?u=929&dateline=1329841488
12.188.74.18 ludawgs.com /images/buttons/newbtn_middle.png
12.188.74.18 ludawgs.com /images/gradient.jpg
12.188.74.18 ludawgs.com /images/misc/blog/top-highlight.png
12.188.74.18 ludawgs.com /images/pagination/first-right.png
12.188.74.18 ludawgs.com /images/pagination/previous-right.png
12.188.74.18 ludawgs.com /images/paypal_small.png
12.188.74.18 ludawgs.com /images/site_icons/add.png
12.188.74.18 ludawgs.com /images/site_icons/blog.png
12.188.74.18 ludawgs.com /images/site_icons/forum.png
12.188.74.18 ludawgs.com /images/site_icons/message.png
12.188.74.18 ludawgs.com /images/site_icons/profile.png
12.188.74.18 ludawgs.com /images/styles/ludawgs/images/buttons.png
12.188.74.18 ludawgs.com /images/styles/ludawgs/images/content.png
12.188.74.18 ludawgs.com /images/styles/ludawgs/images/dotted.png
12.188.74.18 ludawgs.com /images/styles/ludawgs/images/fb.png
12.188.74.18 ludawgs.com /images/styles/ludawgs/images/nav.png
12.188.74.18 ludawgs.com /images/styles/ludawgs/images/pbbottom.png
12.188.74.18 ludawgs.com /images/styles/ludawgs/images/pbbottomleft.png
12.188.74.18 ludawgs.com /images/styles/ludawgs/images/pbleft.png
12.188.74.18 ludawgs.com /images/styles/ludawgs/images/pbright.png
12.188.74.18 ludawgs.com /images/styles/ludawgs/images/pbtop.png
12.188.74.18 ludawgs.com /images/styles/ludawgs/images/pbtopright.png
12.188.74.18 ludawgs.com /images/styles/ludawgs/images/sbu.png
12.188.74.18 ludawgs.com /images/styles/ludawgs/misc/progress.gif
12.188.74.18 ludawgs.com /images/styles/ludawgs/statusicon/user-offline.png
12.188.74.18 ludawgs.com /images/styles/ludawgs/statusicon/user-online.png
157.55.16.87 ludawgs.com /showthread.php?2166-Keeping-it-light-today
174.55.86.63 ludawgs.com /showthread.php?6528-2-29-DraftDay-fantasy-picks-and-insigh
174.71.72.193 ludawgs.com /cpstyles/slider.css
174.71.72.193 ludawgs.com /image.php?u=829&datelin
174.71.72.193 ludawgs.com /image.php?u=862&datelin
174.71.72.193 ludawgs.com /image.php?u=92&dateline
174.71.72.193 ludawgs.com /images/cms/widget-blog.png
174.71.72.193 ludawgs.com /images/icons/icon6.png
174.71.72.193 ludawgs.com /images/overlay.png
174.71.72.193 ludawgs.com /images/site_icons/blog.png
174.71.72.193 ludawgs.com /images/styles/ludawgs/images/header-right.png
174.71.72.193 ludawgs.com /images/styles/ludawgs/images/nnn2.png
174.71.72.193 ludawgs.com /images/styles/ludawgs/images/tbu.png
174.71.72.193 ludawgs.com /images/styles/ludawgs/images/wgobg.png
174.71.72.193 ludawgs.com /images/styles/ludawgs/images/wgoleft.png
174.71.72.193 ludawgs.com /images/styles/ludawgs/images/wgomid.png
174.71.72.193 ludawgs.com /images/styles/ludawgs/images/wgoshright.png
180.76.5.148 ludawgs.com /showthread.php?6086-Monday-NBA&p=80093&viewfull=1
180.76.5.93 ludawgs.com /showthread.php?2899-Bruno-s-Sport-Picks-and-Leans-9-14&p=4
180.76.5.93 ludawgs.com /showthread.php?2916-Bruno-s-Sport-Picks-and-Leans-9-15&p=4
199.21.99.118 ludawgs.com /showthread.php?6555-ECU-vs.-Marshall-7-00-ET=&goto=newpost
24.207.71.22 ludawgs.com /forum.php
24.207.71.22 ludawgs.com /forum.php
24.207.71.22 ludawgs.com /forum.php
66.249.71.114 ludawgs.com /calendar.php?do=getinfo&day=2010-10-21&c=1
66.249.71.114 ludawgs.com /calendar.php?do=getinfo&day=2013-10-27&c=1
66.249.71.114 ludawgs.com /showthread.php?1393-22-s-540-MAX-PRESS-YOUR-LUCK-FREEroll-
66.249.71.114 ludawgs.com /showthread.php?1859-22-s-166-H-R-E-s-contest-All-Star-Game
66.249.71.114 ludawgs.com /showthread.php?2881-22-s-225-max-Pick-5-12-Just-Winners-Fr
70.99.212.158 ludawgs.com /forumdisplay.php?9-NHL-Insight
71.1.190.155 ludawgs.com /cron.php?rand=1330559408
71.49.212.35 ludawgs.com /images/styles/ludawgs/images/footer.png
72.192.0.45 ludawgs.com /forum.php
72.192.0.45 ludawgs.com /forum.php
72.227.68.211 ludawgs.com /image.php?u=498&dateline=1329235535&type=thumb
74.96.155.236 ludawgs.com /favicon.ico
74.96.155.236 ludawgs.com /forumdisplay.php?11-College-Hoops-Insight
98.119.224.65 ludawgs.com /
98.119.224.65 ludawgs.com /
98.203.193.147 ludawgs.com /ajax.php?do=autosave
98.203.193.147 ludawgs.com /ajax.php?do=autosave
98.203.193.147 ludawgs.com /forum.php
98.203.193.147 ludawgs.com /forum.php
98.90.56.103 ludawgs.com /forum.php
98.90.56.103 ludawgs.com /forum.php
98.90.56.103 ludawgs.com /forum.php
99.135.102.9 ludawgs.com /forum.php?referrerid=36
99.136.228.59 ludawgs.com /ajax.php?do=autosave
99.136.228.59 ludawgs.com /ajax.php?do=autosave



Cordially,

Shaun L
Linux Systems Administrator
HostGator.com LLC
HostGator.com Support Portal
 
Nothing looks out of the ordinary there - your site has just outgrown your current hosting plan. 25 concurrent users on a forum is starting to push at the limit of what cheap shared servers etc can handle.

For the record it doesn't even look like vBCredits is being used in any of those processes, so it's certainly not the cause.

A lot of hosts use tricks like this to get in customers - they offer "unlimited" or very high bandwidth, space etc knowing that in the small print there are limitations (like on CPU) that mean it's impossible for the customer to ever use much. They throw a poor processor in the machine and configure things so that when a customer has enough going on in their site to start using a lot of bandwidth for instance, the CPU fails and they can force them to upgrade their hosting plan.

Personal recommendation would be to try out Hivelocity hosting, they've always been great with us and if you mention our name (DragonByte Technologies) you should be able to get an extra little discount as well.

Cosmic
 
Figured. I upgraded to a VPS server this morning. I knew at some point we'd outgrow our shared 14 dollar server. We should have a lot more room to work with now....of course now we're paying $50/month.
 
Status
Not open for further replies.

Legacy vBCredits II Deluxe

vBulletin 3.8.x vBulletin 4.x.x
Seller
DragonByte Technologies
Release date
Last update
Total downloads
845
Customer rating
0.00 star(s) 0 ratings
Back
Top