Terms of Service Violation - Fair Use 怎么办？

北京将军

刚收到IX的Tickets，内容如下，怎么解决？高手帮忙。


Marina G., Wed Jun 29 08:54:07 2011
Ticket Status was changed from New to On-Hold

This is an entry CREATED BY OUR SYSTEM. It includes all the information given while creating this ticket.

Issue properties:
Issue Type: Technical
Affected Product: Hosting ID #691092: Expert Plan
Affected Domain: N/A
Issue Category: Terms of Service Violation - Shared Hosting
Problem Code: Terms of Service Violation - Fair Use
Details given:
We are notifying you that your account, or a portion or feature of your account has caused an overload on one of our servers. We have a shared hosting environment that we must maintain at a certain level of performance. This performance is monitored and balanced by us, however there are times when accounts can cause the server's load to increase degrading the performance for all other customers on this server.

To protect your account from further action you must agree to our request for compliance. Please respond to this message stating your intent to do so. You may either log into your control panel with us, and access this ticket via the 24/7 help desk, or provide this ticket number to our Live Chat or phone representatives.

Failure to respond to this message within 72 hours will result in the suspension of the affected domain with us until such a time as this matter is resolved.

Most common queries for C314794_*:

1.Time: 37% (3771 sec)
Amount: 43% (346 queries)
Rows Examined/Sent: 46256715 / 1810
Avg. Query Exec/Lock Time: 10 / 0 sec.
Used databases: [C314794_health|C314794_lung]
Query example: SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') ORDER BY wp_posts.post_date DESC LIMIT 0, 10;

2.Time: 34% (3464 sec)
Amount: 29% (238 queries)
Rows Examined/Sent: 32148290 / 238
Avg. Query Exec/Lock Time: 14 / 0 sec.
Used databases: [C314794_health]
Query example: use C314794_health; SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') ORDER BY wp_posts.ID ASC LIMIT 0, 1;

3.Time: 15% (1531 sec)
Amount: 23% (187 queries)
Rows Examined/Sent: 11946120 / 187
Avg. Query Exec/Lock Time: 8 / 0 sec.
Used databases: [C314794_health]
Query example: SELECT p.* FROM wp_posts AS p WHERE p.post_date < '2011-05-25 03:09:45' AND p.post_type = 'post' AND p.post_status = 'publish' ORDER BY p.post_date DESC LIMIT 1;

4.Time: 11% (1202 sec)
Amount: 0% (5 queries)
Rows Examined/Sent: 1254053 / 575133
Avg. Query Exec/Lock Time: 240 / 0 sec.
Used databases: [C314794_health]
Query example: use C314794_health; SELECT `ID`, `post_author`, `post_date`, `post_date_gmt`, `post_status`, `post_name`, `post_modified`, `post_modified_gmt`, `post_parent`, `post_type` FROM `wp_posts` WHERE ( (post_status = 'publish' AND (post_type = 'post' OR post_type = '')) OR (post_status = 'publish' AND post_type = 'page') ) AND post_password='' ORDER BY post_modified DESC;

Databases C314794_health C314794_lung have been chmoded to 0.

微微百科

原帖由 北京将军 于 2011-6-30 07:45 AM 发表
Databases C314794_health C314794_lung have been chmoded to 0.

这二个数据库超载了

北京将军

原帖由 微微百科 于 2011-6-30 09:04 AM 发表


这二个数据库超载了

谢谢！！！

请问怎么和洋鬼子沟通解决呢？有哪些步骤？？？

微微百科

如果自己懂得怎么优化数据库的话，可以自己优化一下，否则是比较麻烦的。