NND 又罢工了，奉劝做采集的不要使用wordpress来搞

xiongyujie37

三万数据，今天又罢工了！

平时很文明，今天实在是忍不住怒火。。。

pr=4 就这么废了？？？

先前是一天1000以内数据，后来被空间商停用了一次

马上意识到搞采集不能用wordpress

减少每天更新50左右


这次是给逼的。。。空间商这次貌似是敲诈了，直接给停了，说要换个更好的服务器匹配

NND，天天倒贴本，还贴时间，还要停空间，靠。。。




以下是空间商发来的信，NND


Hello,

I'm writing you about your database, xiongq. The database was causing
some severe
load on the mysql server, it seems from some very slow wordpress queries
taking 200+ seconds per query, as well as causing slowness and customer
complaints.  Is wp-cache enabled on all wordpress installs?  This was
causing enough problems that I've had to disable the wp_posts table until
this plugin is installed, or if it is already installed, I'm afraid your
mysql needs have outgrown shared hosting and you will need to update to a
DreamHost MySQL PS or seek out a more powerful VPS or dedicated solution
at another host.

https://panel.dreamhost.com/index.cgi?tree=vserver.provision&

You can write me at justin@dreamhost.com about this issue.  I can provide
a
backup of the database, such as to your ftp directory, if you wish. Here
are the bad queries that were in the mysql slow log, please note the
"query_time" in seconds and the rows_examined.

# Query_time: 235  Lock_time: 0  Rows_sent: 10    Rows_examined: 26549
use xiongq;
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;
# User@Host: xiongq[xiongq] @ daedalus.dreamhost.com [208.113.188.29]
# Query_time: 113  Lock_time: 0  Rows_sent: 10    Rows_examined: 26549
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;
# User@Host: xiongq[xiongq] @ daedalus.dreamhost.com [208.113.188.29]
# Query_time: 143  Lock_time: 0  Rows_sent: 10    Rows_examined: 26549
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;
# User@Host: xiongq[xiongq] @ daedalus.dreamhost.com [208.113.188.29]
# Query_time: 240  Lock_time: 0  Rows_sent: 10    Rows_examined: 26549
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;
# User@Host: xiongq[xiongq] @ daedalus.dreamhost.com [208.113.188.29]
# Query_time: 167  Lock_time: 0  Rows_sent: 10    Rows_examined: 26549
use xiongq;
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;
# Query_time: 111  Lock_time: 0  Rows_sent: 10    Rows_examined: 10770
use twwordpress;
SELECT SQL_CALC_FOUND_ROWS  twwordpresswp_posts.* FROM
twwordpresswp_posts  WHERE 1=1    AND twwordpresswp_posts.post_type =
'post' AND (twwordpresswp_posts.post_status = 'publish')  ORDER BY
twwordpresswp_posts.post_date DESC LIMIT 1, 10;

Thanks!
Justin K

futurekb

你用的那个空间商?wordpress加了插件没有?

cnncnn

买个VPS得了.

孤魂

使用ＷＰ，ＤＨ和ＨＭ的空间都停了，ＧＯＤ的还在撑，十五万数据

shayajin

有那么惨么？

sushy

你们每天都在采集一些什么东东啊，那么大的数据量

落寞三少

学习学习