服务器被360搜索爬蹦了 1小时爬了我10W数据。。。 42.236.17.37 42.236.17.88 是255个字段循环爬取
时间 :
2022-11-06
编辑 :超级管理员
先看进程占用情况
top
mysql 400%
q 退出
进数据库
mysql -u root -p
输入密码
查看数据库占用进程
show full processlist;
3083 | www_xiaozi_org | localhost:39904 | www_xiaozi_org | Query | 3 | Sending data | SELECT a.id,a.title,a.filename,a.ico,a.scode,b.filename as sortfilename,c.type,c.urlname FROM ay_content a LEFT JOIN ay_content_sort b ON a.scode=b.scode LEFT JOIN ay_model c ON b.mcode=c.mcode WHERE(a.id<85160) AND a.scode='41' AND(a.acode='cn') AND(a.status=1) AND(a.date<'2022-11-06 16:43:43') ORDER BY a.id DESC LIMIT 1
重启数据库
service mysqld restart;
quit或者exit退出mysql
RedHat Linux (Fedora Core/Cent OS)
1.启动：/etc/init.d/mysqld start
2.停止：/etc/init.d/mysqld stop
3.重启：/etc/init.d/mysqld restart
