|
|
用了BLUEHOST的美国虚拟主机4年多了，第一次遇到这样的事情，到现在还没解决，不知道怎么办了。
我买的虚拟主机是plus那款，号称无限空间无限带宽无限数据库的，里面只装了三个dz论坛。
其中一个论坛是作为纪念保留的，现在已经不用了，古老的dz6.0，数据库150m左右。
第二个论坛是影视交流论坛，同时在线人数不超过20人，dzX3.2，数据库不到60m。
第三个论坛同时在线人数不超过30人，用于天黑请闭眼游戏（版杀），dzX3.0，数据库400m，是这三个论坛里最活跃的。
8月31号半夜3点多（大概美国时间中午12点）突然就给我暂停了，显示要我尽快登录联系他们。
等我登录后home页只显示这么一句话
Your web hosting account for mysite has been deactivated, as of 2016-08-31 13:47:43.
Reason: site causing performance problems.
For more information about this account, please call 888-401-4678, option 2.
同时我收到一封自动邮件，也是类似的说法。
Your web hosting account for mysite has been deactivated, as of 08/31/2016. (reason: site causing performance problems)
This deactivation was due to a Terms of Service violation associated with your account. At sign-up, all users state that they have read through, understand, and agree to our terms. These terms are legal and binding.
Please contact our Terms of Service team immediately to resolve the violation; your account will remain deactivated until you contact us and the issue is resolved.
Contact us if you feel the deactivation was a mistake. You must contact us to regain access to your account. Please call and speak with our Terms of Service Compliance department as soon as possible at 888-401-4678 (ext. 3).
以往网站出什么问题，有个工单后可以很方便的沟通，现在bluehost的工单系统改成了这样，部门不对，提交了也没人理，其中技术支持部分还只能用Liive Chat和电话。
要联系他们的Terms of Service Department无法通过工单，Live Chat倒是有，但永远在排队
等排了1个多小时，变成这样，然后就没有然后了，让其他朋友试也是这样结果。
后来我在help里找到了Terms of Service的邮件地址，发了一封邮件过去，问为何我网站被暂停，并且指出我的总文件数没有超过5万，也没有收到过cpu超出的警告，要求他们给出原因。
3个小时后收到回信。
Hello,
Thank you for contacting Terms of Service Department.
Your account was deactivated for causing performance problems on the server for MySQL. I've included the Administrator's notes as well as some other information that you might find useful in troubleshooting the problem. Once it's resolved, please contact us so we can note the account with what was done then reactivate it for you.
Here are the notes provided by the server administrator:
______________________________________________________________________________________________________________________________________________________________
It appears that multiple viewthread.php are querying the website for details on the respective thread. These processes are generated by the bots (baidu, bing...) and its causing load to the server.
搜索蜘蛛太多造成崩溃？我的小站根本不需要收录和推广，所以完全没用过增加收录的设定，但平时在线的蜘蛛确实很多，峰值曾经达到400只。
List of process:
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
23947 mysite 20 0 182m 21m 7600 R 19.8 0.1 0:00.09 /ramdisk/bin/php5 /home2/mysite/public_html/viewthread.php
23948 mysite 20 0 181m 21m 7600 R 19.8 0.1 0:00.09 /ramdisk/bin/php5 /home2/mysite/public_html/viewthread.php
24000 mysite 20 0 180m 19m 7600 R 19.8 0.1 0:00.08 /ramdisk/bin/php5 /home2/mysite/public_html/viewthread.php
23950 mysite 20 0 173m 13m 7560 R 14.8 0.0 0:00.07 /ramdisk/bin/php5 /home2/mysite/public_html/viewthread.php
23996 mysite 20 0 172m 11m 7280 R 14.8 0.0 0:00.06 /ramdisk/bin/php5 /home2/mysite/public_html/viewthread.php
23952 mysite 20 0 166m 5308 4272 R 9.9 0.0 0:00.04 /ramdisk/bin/php5 /home2/mysite/public_html/viewthread.php
23991 mysite 20 0 166m 4448 3516 R 9.9 0.0 0:00.04 /ramdisk/bin/php5 /home2/mysite/public_html/viewthread.php
23987 mysite 20 0 166m 2300 1688 R 7.4 0.0 0:00.03 /ramdisk/bin/php5 /home2/mysite/public_html/viewthread.php
23989 mysite 20 0 166m 2776 2084 R 7.4 0.0 0:00.03 /ramdisk/bin/php5 /home2/mysite/public_html/viewthread.php
23990 mysite 20 0 166m 2548 1896 R 7.4 0.0 0:00.03 /ramdisk/bin/php5 /home2/mysite/public_html/viewthread.php
23999 mysite 20 0 166m 2776 2084 R 7.4 0.0 0:00.03 /ramdisk/bin/php5 /home2/mysite/public_html/viewthread.php
23998 mysite 20 0 25244 1740 1356 R 4.9 0.0 0:00.02 /usr/bin/perl /ramdisk/bin/php5s /home2/mysite/public_html/viewthread.php
24005 mysite 20 0 157m 1164 776 R 4.9 0.0 0:00.02 /ramdisk/bin/php5 /home2/mysite/public_html/viewthread.php
24007 mysite 20 0 25244 2000 1596 R 2.5 0.0 0:00.01 /usr/bin/perl /ramdisk/bin/php5s /home2/mysite/public_html/viewthread.php
24008 mysite 20 0 25244 1740 1356 R 2.5 0.0 0:00.01 /usr/bin/perl /ramdisk/bin/php5s /home2/mysite/public_html/viewthread.php
Also upon checking robot .txt does not contain any info about viewthread.php
______________________________________________________________________________________________________________________________________________________________
A slow query is when a website tries to get information from the database and it takes over 1 second to deliver. A website can make anywhere from 5 to 30 queries toload a single page. When one query is taking over a second it can eat up a lot of server resources and cause poor performance on all of your sites. MySQL slow queries are written into log files by the server and stored in a location on your account that you have access to. They are in your home directory (one level up from the public_html folder.). Within that home directory they are in the tmp folder and withing the tmp folder they are in the mysql_slow_queries folder. There you find files that that have a record of the slow queries that your account has generated.
There are 3 things that will resolve MySQL performance issues and they are as follows:这一部分完全没看懂，这是在说dz系统造成数据库消耗资源么？
1. Remove the code that generates the offending query all together.
2. Institute proper table indexing for tables whereupon the bad queries are being executed. Proper indexing is explained in our help desk and is the most ideal solution for any MySQL performance issues.
3. Rework the query that is responsible for the performance issue so that it can perform the same task without having to perform as large a query. This solution is not plausible in all circumstances, will require intimate knowledge of the tasks at hand to elicit a better query, and will often achieve modest gains at best. This option is often best implemented in addition to #2 as the combination of a better query and proper indexing will obviously yield substantial benefits.
https://www.bluehost.com/cgi/help/435
https://www.bluehost.com/cgi/help/436
https://www.bluehost.com/cgi/help/437
https://www.bluehost.com/cgi/help/438
Try minimizing the amount of software and plugins you need for your website. Also, implement whatever caching or load reducing measures you can for the software to have it run as efficiently as possible. Lastly, consider your website and the resources it consumes. If it's constantly slow or experiencing problems, then shared hosting may not be the right environment for you. If you have queries that don't use indexes, or if queries run slowly with indexes in place, you need to rethink how you're pulling your data. Should your data be split into multiple tables? Are you pulling more data than you need? Keep these questions in mind while going over the MySQL slow query logs in your ~/tmp/mysql_slow_queries folder. These logs will show queries that were slow and will help you find where the bottlenecks occur. Queries that are over 1 second should be re-worked.
研究半天，我觉得第一个问题好解决，回信说robots文件里改成这样，禁止一切蜘蛛访问。
- <div>#</div><div># robots.txt for Discuz! X3</div><div>#</div><div>
- </div><div>User-agent: *</div><div>Disallow: /</div>
[color=rgb(51, 102, 153) !important]复制代码
但第二个问题，不知道怎么解决，难道要删掉所有dz文件和数据库？
我回信说删掉了一些可能造成消耗资源的插件，但要优化数据库和代码需要discuz自带的功能，所以希望他们能重激活我的站。
邮件已经发了三封，现在已经过了四天，一直没人回复。
心累/(ㄒoㄒ)/~~
到底该怎么做？ |
|
BlueHost
1378 人阅读
|
3 人回复
狗仔卡
提升卡
置顶卡
沉默卡
喧嚣卡
变色卡
显身卡