NND 又罢工了，奉劝做采集的不要使用wordpress来搞
三万数据，今天又罢工了！平时很文明，今天实在是忍不住怒火。。。
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: 235Lock_time: 0Rows_sent: 10 Rows_examined: 26549
use xiongq;
SELECT SQL_CALC_FOUND_ROWSwp_posts.* FROM wp_postsWHERE 1=1AND
wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish')ORDER
BY wp_posts.post_date DESC LIMIT 0, 10;
# User@Host: xiongq @ daedalus.dreamhost.com
# Query_time: 113Lock_time: 0Rows_sent: 10 Rows_examined: 26549
SELECT SQL_CALC_FOUND_ROWSwp_posts.* FROM wp_postsWHERE 1=1AND
wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish')ORDER
BY wp_posts.post_date DESC LIMIT 0, 10;
# User@Host: xiongq @ daedalus.dreamhost.com
# Query_time: 143Lock_time: 0Rows_sent: 10 Rows_examined: 26549
SELECT SQL_CALC_FOUND_ROWSwp_posts.* FROM wp_postsWHERE 1=1AND
wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish')ORDER
BY wp_posts.post_date DESC LIMIT 0, 10;
# User@Host: xiongq @ daedalus.dreamhost.com
# Query_time: 240Lock_time: 0Rows_sent: 10 Rows_examined: 26549
SELECT SQL_CALC_FOUND_ROWSwp_posts.* FROM wp_postsWHERE 1=1AND
wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish')ORDER
BY wp_posts.post_date DESC LIMIT 0, 10;
# User@Host: xiongq @ daedalus.dreamhost.com
# Query_time: 167Lock_time: 0Rows_sent: 10 Rows_examined: 26549
use xiongq;
SELECT SQL_CALC_FOUND_ROWSwp_posts.* FROM wp_postsWHERE 1=1AND
wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish')ORDER
BY wp_posts.post_date DESC LIMIT 0, 10;
# Query_time: 111Lock_time: 0Rows_sent: 10 Rows_examined: 10770
use twwordpress;
SELECT SQL_CALC_FOUND_ROWStwwordpresswp_posts.* FROM
twwordpresswp_postsWHERE 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 你用的那个空间商?wordpress加了插件没有? 买个VPS得了. :lol :lol 使用ＷＰ，ＤＨ和ＨＭ的空间都停了，ＧＯＤ的还在撑，十五万数据
有那么惨么
有那么惨么？:lol :lol 你们每天都在采集一些什么东东啊，那么大的数据量 学习学习
页:
[1]