数据库被清空 邮件+ticket 怎么办？（已解決問題）

gakumayi

IX主机

A new trouble ticket was created in your account.

**********************************
Subject: TOS Violation - MySQL Overload
Account Link: General Inquiry
Category: Technical


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.

Please contact us to resolve this matter.

DataBase C283793_ue**ns chmoded to zero

Time: 28% (14395 sec) Amount: 19% (692 queries) Rows Examined/Sent: 416685 / 3949 Avg. Query Exec/Lock Time: 20 / 0 sec.
use C283793_ue**ns; 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;

Time: 15% (8049 sec) Amount: 14% (520 queries) Rows Examined/Sent: 543190 / 520 Avg. Query Exec/Lock Time: 15 / 0 sec.
SELECT YEAR(min(post_date_gmt)) AS firstyear, YEAR(max(post_date_gmt)) AS lastyear FROM wp_posts WHERE post_date_gmt > 1970;

Time: 9% (4642 sec) Amount: 11% (408 queries) Rows Examined/Sent: 2121 / 2121 Avg. Query Exec/Lock Time: 11 / 0 sec.
use C283793_ue**ns; SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (1100);

Time: 7% (3687 sec) Amount: 8% (282 queries) Rows Examined/Sent: 44819 / 8388 Avg. Query Exec/Lock Time: 13 / 0 sec.
use C283793_ue**ns; SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (84, 82, 80, 76, 74, 72, 69, 67, 65, 63) ORDER BY t.name ASC;

Time: 6% (3420 sec) Amount: 7% (277 queries) Rows Examined/Sent: 3181 / 1589 Avg. Query Exec/Lock Time: 12 / 1 sec.
use C283793_ue**ns; SELECT * FROM wp_comments WHERE comment_post_ID = 84 AND ( comment_approved = '0' OR comment_approved = '1' ) ORDER BY comment_date_gmt DESC;

Time: 3% (1920 sec) Amount: 5% (184 queries) Rows Examined/Sent: 0 / 0 Avg. Query Exec/Lock Time: 10 / 0 sec.
use C283793_ue**ns; UPDATE `wp_postmeta` SET `meta_value` = '98' WHERE `post_id` = 736 AND `meta_key` = 'views';

Time: 2% (1422 sec) Amount: 3% (118 queries) Rows Examined/Sent: 1352 / 565 Avg. Query Exec/Lock Time: 12 / 1 sec.
use C283793_ue**ns; SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.ID = 84 AND wp_posts.post_type = 'post' ORDER BY wp_posts.post_date DESC;

Time: 2% (1379 sec) Amount: 2% (92 queries) Rows Examined/Sent: 31627 / 27579 Avg. Query Exec/Lock Time: 14 / 1 sec.
use C283793_ue**ns; SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes';

gakumayi

怎么办啊 这个数据库还可以恢复么
我没备份啊~~
IX太糟糕了

kingto

就是因为mysql超载引起的
他们说，为了保护您账户在今后能继续使用，请承诺同意ix的要求。请通过ticket或在线客服联系他们

gakumayi

同意了能给我回复数据么？
再说我不知道怎么控制数据库不超载啊！

kingto

。。恩 问您一下
您的网站是dz论坛还是？
日ip有大约多少？