服务器负载高,网站打不开

问:

服务器重启过了,网站关闭试过了,都没有解决这个情况,麻烦尽快处理,服务器负载高,网站打不开

答:您好,1、您的站点存在CC攻击, 刚刚为您关闭httpd ,负载逐渐降低 (您是否又自行启动了apache ?) ,建议您可以开启百度云加速,有CC防御的左右, 另外 您服务器内部是宝塔面板,宝塔面板 -收费软件- 有apache防火墙,您可以安装 防火墙,也可以设置 CC防御 频率  ,非常感谢您长期对我司的支持!

问: 还是没有解决呀

答:您好,1、您的网站存在CC攻击,需要通过软件防火墙 或硬件防火墙 进行防御。  我司接入了百度云加速,目前设置的防护级别是 高级,请您稍后测试下。    

   另外也可以开启防护 ‘强制验证’ 就是需要输入验证码才可以访问, 有防护效果。

  您使用的是宝塔面板 – 在软件管理 – apache 防火墙 ,可以安装防火墙 设置 cc 频率 。

2、另外我司有硬件防火墙, https://www.west.cn/cloudhost/ddos.asp 购买后 回复工单, 可以开启 CC防护 ,非常感谢您长期对我司的支持!

问:服务器负载高,网站打不开,远程进不去

答:您好,查看您服务器网络带宽已经严重超标,请您通过服务器管理–管理–控制台–登陆后查看下是否有站点受攻击导致异常,如需我司协助分析,请提交主机租用vps、云主机–>系统设置–>服务器异常原因分析(cpu内存占完、服务器慢、多次意外重启、带宽用尽等),非常感谢您长期对我司的支持!

问:有办法让我远程看得到吗?》

答:您好,因为带宽超标,导致网络拥堵无法远程,您可先重启下服务器然后远程试试,如不能远程,只可通过控制台登陆检查处理,非常感谢您长期对我司的支持!

问:已经升级到5M了,为什么还是这么慢?

http://www.leyben.com/

答:您好,如图测试多次,网站打开速度正常, 您服务器负载目前也不高,请排查下本地网络情况,非常感谢您长期对我司的支持!

问:服务器负载高

答:您好,查看主要是msyql和cdydtx站点占用cpu资源较多,查看mysql的连接请求,核实在大量查询`cdydtx`.`ecs_g` 这个表,请联系程序开发人员优化下此查询语句和表文件后观察下,非常感谢您长期对我司的支持!

Id User Host db Command Time State Info

6574 cdydtx localhost:55738 cdydtx Sleep 0 NULL

6576 cdydtx localhost:55740 cdydtx Query 0 Copying to tmp table SELECT a.attr_id, MIN(a.goods_attr_id ) AS goods_id, a.attr_value AS attr_value FROM `cdydtx`.`ecs_g

6579 cdydtx localhost:55743 cdydtx Query 0 Sending data SELECT a.attr_name FROM `cdydtx`.`ecs_attribute` AS a, `cdydtx`.`ecs_goods_attr` AS ga, `cdydtx`.`ec

6580 cdydtx localhost:55744 cdydtx Query 0 Sending data SELECT a.attr_name FROM `cdydtx`.`ecs_attribute` AS a, `cdydtx`.`ecs_goods_attr` AS ga, `cdydtx`.`ec

6581 cdydtx localhost:55745 cdydtx Query 0 statistics SELECT a.attr_id, MIN(a.goods_attr_id ) AS goods_id, a.attr_value AS attr_value FROM `cdydtx`.`ecs_g

6582 cdydtx localhost:55746 cdydtx Query 0 Copying to tmp table SELECT a.attr_id, MIN(a.goods_attr_id ) AS goods_id, a.attr_value AS attr_value FROM `cdydtx`.`ecs_g

6584 cdydtx localhost:55748 cdydtx Query 0 Copying to tmp table SELECT a.attr_id, MIN(a.goods_attr_id ) AS goods_id, a.attr_value AS attr_value FROM `cdydtx`.`ecs_g

6583 cdydtx localhost:55747 cdydtx Query 0 Sending data SELECT a.attr_name FROM `cdydtx`.`ecs_attribute` AS a, `cdydtx`.`ecs_goods_attr` AS ga, `cdydtx`.`ec

6585 cdydtx localhost:55749 cdydtx Query 0 Sending data SELECT a.attr_name FROM `cdydtx`.`ecs_attribute` AS a, `cdydtx`.`ecs_goods_attr` AS ga, `cdydtx`.`ec

6586 cdydtx localhost:55750 cdydtx Query 0 Sending data SELECT a.attr_name FROM `cdydtx`.`ecs_attribute` AS a, `cdydtx`.`ecs_goods_attr` AS ga, `cdydtx`.`ec

6587 cdydtx localhost:55751 cdydtx Query 0 Sending data SELECT a.attr_name FROM `cdydtx`.`ecs_attribute` AS a, `cdydtx`.`ecs_goods_attr` AS ga, `cdydtx`.`ec

6588 cdydtx localhost:55752 cdydtx Query 0 Copying to tmp table SELECT a.attr_id, MIN(a.goods_attr_id ) AS goods_id, a.attr_value AS attr_value FROM `cdydtx`.`ecs_g

6589 cdydtx localhost:55753 cdydtx Query 0 Sending data SELECT a.attr_name FROM `cdydtx`.`ecs_attribute` AS a, `cdydtx`.`ecs_goods_attr` AS ga, `cdydtx`.`ec

6590 cdydtx localhost:55754 cdydtx Query 0 Copying to tmp table SELECT a.attr_id, MIN(a.goods_attr_id ) AS goods_id, a.attr_value AS attr_value FROM `cdydtx`.`ecs_g

6591 cdydtx localhost:55755 cdydtx Query 0 Copying to tmp table SELECT a.attr_id, MIN(a.goods_attr_id ) AS goods_id, a.attr_value AS attr_value FROM `cdydtx`.`ecs_g

6592 cdydtx localhost:55756 cdydtx Query 0 Copying to tmp table SELECT a.attr_id, MIN(a.goods_attr_id ) AS goods_id, a.attr_value AS attr_value FROM `cdydtx`.`ecs_g

6593 cdydtx localhost:55757 cdydtx Query 0 Sending data SELECT a.attr_name FROM `cdydtx`.`ecs_attribute` AS a, `cdydtx`.`ecs_goods_attr` AS ga, `cdydtx`.`ec

6594 cdydtx localhost:55758 cdydtx Query 0 Copying to tmp table SELECT a.attr_id, MIN(a.goods_attr_id ) AS goods_id, a.attr_value AS attr_value FROM `cdydtx`.`ecs_g

6595 cdydtx localhost:55759 cdydtx Query 0 Copying to tmp table SELECT a.attr_id, MIN(a.goods_attr_id ) AS goods_id, a.attr_value AS attr_value FROM `cdydtx`.`ecs_g

6596 cdydtx localhost:55760 cdydtx Query 0 Copying to tmp table SELECT a.attr_id, MIN(a.goods_attr_id ) AS goods_id, a.attr_value AS attr_value FROM `cdydtx`.`ecs_g

6597 cdydtx localhost:55761 cdydtx Query 0 Copying to tmp table SELECT a.attr_id, MIN(a.goods_attr_id ) AS goods_id, a.attr_value AS attr_value FROM `cdydtx`.`ecs_g

6598 cdydtx localhost:55762 cdydtx Query 0 Sending data SELECT a.attr_name FROM `cdydtx`.`ecs_attribute` AS a, `cdydtx`.`ecs_goods_attr` AS ga, `cdydtx`.`ec

6599 cdydtx localhost:55763 cdydtx Query 0 Sending data SELECT a.attr_name FROM `cdydtx`.`ecs_attribute` AS a, `cdydtx`.`ecs_goods_attr` AS ga, `cdydtx`.`ec

6601 cdydtx localhost:55765 cdydtx Query 0 Sending data SELECT a.attr_name FROM `cdydtx`.`ecs_attribute` AS a, `cdydtx`.`ecs_goods_attr` AS ga, `cdydtx`.`ec

6600 cdydtx localhost:55764 cdydtx Query 0 Copying to tmp table SELECT a.attr_id, MIN(a.goods_attr_id ) AS goods_id, a.attr_value AS attr_value FROM `cdydtx`.`ecs_g

6602 cdydtx localhost:55766 cdydtx Query 0 Sending data SELECT a.attr_name FROM `cdydtx`.`ecs_attribute` AS a, `cdydtx`.`ecs_goods_attr` AS ga, `cdydtx`.`ec

6604 cdydtx localhost:55768 cdydtx Query 0 Sending data SELECT a.attr_name FROM `cdydtx`.`ecs_attribute` AS a, `cdydtx`.`ecs_goods_attr` AS ga, `cdydtx`.`ec

6603 cdydtx localhost:55767 cdydtx Query 0 Sending data SELECT a.attr_name FROM `cdydtx`.`ecs_attribute` AS a, `cdydtx`.`ecs_goods_attr` AS ga, `cdydtx`.`ec

6605 cdydtx localhost:55769 cdydtx Query 0 Sending data SELECT a.attr_name FROM `cdydtx`.`ecs_attribute` AS a, `cdydtx`.`ecs_goods_attr` AS ga, `cdydtx`.`ec

6606 cdydtx localhost:55770 cdydtx Query 0 Sending data SELECT a.attr_name FROM `cdydtx`.`ecs_attribute` AS a, `cdydtx`.`ecs_goods_attr` AS ga, `cdydtx`.`ec

6607 cdydtx localhost:55771 cdydtx Query 0 Copying to tmp table SELECT a.attr_id, MIN(a.goods_attr_id ) AS goods_id, a.attr_value AS attr_value FROM `cdydtx`.`ecs_g

6608 cdydtx localhost:55772 cdydtx Query 0 Sending data SELECT a.attr_name FROM `cdydtx`.`ecs_attribute` AS a, `cdydtx`.`ecs_goods_attr` AS ga, `cdydtx`.`ec

6609 cdydtx localhost:55773 cdydtx Query 0 Sending data SELECT a.attr_name FROM `cdydtx`.`ecs_attribute` AS a, `cdydtx`.`ecs_goods_attr` AS ga, `cdydtx`.`ec

6610 cdydtx localhost:55774 cdydtx Query 0 Copying to tmp table SELECT a.attr_id, MIN(a.goods_attr_id ) AS goods_id, a.attr_value AS attr_value FROM `cdydtx`.`ecs_g

6613 cdydtx localhost:55777 cdydtx Query 0 Copying to tmp table SELECT a.attr_id, MIN(a.goods_attr_id ) AS goods_id, a.attr_value AS attr_value FROM `cdydtx`.`ecs_g

6614 cdydtx localhost:55778 cdydtx Query 0 Copying to tmp table SELECT a.attr_id, MIN(a.goods_attr_id ) AS goods_id, a.attr_value AS attr_value FROM `cdydtx`.`ecs_g

6615 cdydtx localhost:55779 cdydtx Query 0 Copying to tmp table SELECT a.attr_id, MIN(a.goods_attr_id ) AS goods_id, a.attr_value AS attr_value FROM `cdydtx`.`ecs_g

6616 cdydtx localhost:55780 cdydtx Query 0 Sending data SELECT a.attr_name FROM `cdydtx`.`ecs_attribute` AS a, `cdydtx`.`ecs_goods_attr` AS ga, `cdydtx`.`ec

6617 cdydtx localhost:55781 cdydtx Query 0 Copying to tmp table SELECT a.attr_id, MIN(a.goods_attr_id ) AS goods_id, a.attr_value AS attr_value FROM `cdydtx`.`ecs_g

6618 cdydtx localhost:55782 cdydtx Query 0 Copying to tmp table SELECT a.attr_id, MIN(a.goods_attr_id ) AS goods_id, a.attr_value AS attr_value FROM `cdydtx`.`ecs_g

6619 cdydtx localhost:55783 cdydtx Query 0 Copying to tmp table SELECT a.attr_id, MIN(a.goods_attr_id ) AS goods_id, a.attr_value AS attr_value FROM `cdydtx`.`ecs_g

6620 cdydtx localhost:55784 cdydtx Query 0 Sending data SELECT a.attr_name FROM `cdydtx`.`ecs_attribute` AS a, `cdydtx`.`ecs_goods_attr` AS ga, `cdydtx`.`ec

6621 cdydtx localhost:55785 cdydtx Query 0 Sending data SELECT a.attr_name FROM `cdydtx`.`ecs_attribute` AS a, `cdydtx`.`ecs_goods_attr` AS ga, `cdydtx`.`ec

6622 cdydtx localhost:55786 cdydtx Query 1 Copying to tmp table SELECT a.attr_id, MIN(a.goods_attr_id ) AS goods_id, a.attr_value AS attr_value FROM `cdydtx`.`ecs_g

6623 cdydtx localhost:55787 cdydtx Query 0 Sending data SELECT a.attr_name FROM `cdydtx`.`ecs_attribute` AS a, `cdydtx`.`ecs_goods_attr` AS ga, `cdydtx`.`ec

6624 cdydtx localhost:55788 cdydtx Query 0 statistics SELECT a.attr_name FROM `cdydtx`.`ecs_attribute` AS a, `cdydtx`.`ecs_goods_attr` AS ga, `cdydtx`.`ec

6625 cdydtx localhost:55789 cdydtx Query 0 Copying to tmp table SELECT a.attr_id, MIN(a.goods_attr_id ) AS goods_id, a.attr_value AS attr_value FROM `cdydtx`.`ecs_g

6626 cdydtx localhost:55790 cdydtx Query 0 Copying to tmp table SELECT a.attr_id, MIN(a.goods_attr_id ) AS goods_id, a.attr_value AS attr_value FROM `cdydtx`.`ecs_g

6627 cdydtx localhost:55791 cdydtx Query 1 Copying to tmp table SELECT a.attr_id, MIN(a.goods_attr_id ) AS goods_id, a.attr_value AS attr_value FROM `cdydtx`.`ecs_g

6628 cdydtx localhost:55792 cdydtx Query 0 Copying to tmp table SELECT a.attr_id, MIN(a.goods_attr_id ) AS goods_id, a.attr_value AS attr_value FROM `cdydtx`.`ecs_g

6629 cdydtx localhost:55793 cdydtx Query 1 Copying to tmp table SELECT a.attr_id, MIN(a.goods_attr_id ) AS goods_id, a.attr_value AS attr_value FROM `cdydtx`.`ecs_g

6630 cdydtx localhost:55794 cdydtx Query 0 Copying to tmp table SELECT a.attr_id, MIN(a.goods_attr_id ) AS goods_id, a.attr_value AS attr_value FROM `cdydtx`.`ecs_g

6631 cdydtx localhost:55795 cdydtx Query 1 Copying to tmp table SELECT a.attr_id, MIN(a.goods_attr_id ) AS goods_id, a.attr_value AS attr_value FROM `cdydtx`.`ecs_g

6632 cdydtx localhost:55796 cdydtx Query 0 Copying to tmp table SELECT a.attr_id, MIN(a.goods_attr_id ) AS goods_id, a.attr_value AS attr_value FROM `cdydtx`.`ecs_g

6633 cdydtx localhost:55797 cdydtx Query 0 Sending data SELECT a.attr_name FROM `cdydtx`.`ecs_attribute` AS a, `cdydtx`.`ecs_goods_attr` AS ga, `cdydtx`.`ec

6634 cdydtx localhost:55798 cdydtx Query 0 Copying to tmp table SELECT a.attr_id, MIN(a.goods_attr_id ) AS goods_id, a.attr_value AS attr_value FROM `cdydtx`.`ecs_g

6635 cdydtx localhost:55799 cdydtx Query 0 Copying to tmp table SELECT a.attr_id, MIN(a.goods_attr_id ) AS goods_id, a.attr_value AS attr_value FROM `cdydtx`.`ecs_g

6636 cdydtx localhost:55800 cdydtx Query 0 Sending data SELECT a.attr_name FROM `cdydtx`.`ecs_attribute` AS a, `cdydtx`.`ecs_goods_attr` AS ga, `cdydtx`.`ec

6637 cdydtx localhost:55801 cdydtx Query 0 Copying to tmp table SELECT a.attr_id, MIN(a.goods_attr_id ) AS goods_id, a.attr_value AS attr_value FROM `cdydtx`.`ecs_g

6638 cdydtx localhost:55802 cdydtx Query 0 Sending data SELECT a.attr_name FROM `cdydtx`.`ecs_attribute` AS a, `cdydtx`.`ecs_goods_attr` AS ga, `cdydtx`.`ec

6639 cdydtx localhost:55803 cdydtx Query 0 Sending data SELECT a.attr_name FROM `cdydtx`.`ecs_attribute` AS a, `cdydtx`.`ecs_goods_attr` AS ga, `cdydtx`.`ec

6640 cdydtx localhost:55804 cdydtx Query 0 Copying to tmp table SELECT a.attr_id, MIN(a.goods_attr_id ) AS goods_id, a.attr_value AS attr_value FROM `cdydtx`.`ecs_g

6641 cdydtx localhost:55805 cdydtx Query 0 Sending data SELECT a.attr_name FROM `cdydtx`.`ecs_attribute` AS a, `cdydtx`.`ecs_goods_attr` AS ga, `cdydtx`.`ec

6642 cdydtx localhost:55806 cdydtx Query 0 Copying to tmp table SELECT a.attr_id, MIN(a.goods_attr_id ) AS goods_id, a.attr_value AS attr_value FROM `cdydtx`.`ecs_g

6643 cdydtx localhost:55807 cdydtx Query 0 statistics SELECT a.attr_name FROM `cdydtx`.`ecs_attribute` AS a, `cdydtx`.`ecs_goods_attr` AS ga, `cdydtx`.`ec

6644 cdydtx localhost:55808 cdydtx Query 0 Copying to tmp table SELECT a.attr_id, MIN(a.goods_attr_id ) AS goods_id, a.attr_value AS attr_value FROM `cdydtx`.`ecs_g

6645 cdydtx localhost:55809 cdydtx Query 0 Sending data SELECT a.attr_name FROM `cdydtx`.`ecs_attribute` AS a, `cdydtx`.`ecs_goods_attr` AS ga, `cdydtx`.`ec

6647 cdydtx localhost:55811 cdydtx Query 0 Copying to tmp table SELECT a.attr_id, MIN(a.goods_attr_id ) AS goods_id, a.attr_value AS attr_value FROM `cdydtx`.`ecs_g

6646 cdydtx localhost:55810 cdydtx Query 0 Sending data SELECT a.attr_name FROM `cdydtx`.`ecs_attribute` AS a, `cdydtx`.`ecs_goods_attr` AS ga, `cdydtx`.`ec

6648 cdydtx localhost:55812 cdydtx Query 0 Sending data SELECT a.attr_name FROM `cdydtx`.`ecs_attribute` AS a, `cdydtx`.`ecs_goods_attr` AS ga, `cdydtx`.`ec

6649 cdydtx localhost:55813 cdydtx Query 0 Copying to tmp table SELECT a.attr_id, MIN(a.goods_attr_id ) AS goods_id, a.attr_value AS attr_value FROM `cdydtx`.`ecs_g

6650 cdydtx localhost:55814 cdydtx Query 0 statistics SELECT a.attr_id, MIN(a.goods_attr_id ) AS goods_id, a.attr_value AS attr_value FROM `cdydtx`.`ecs_g

6651 cdydtx localhost:55815 cdydtx Query 0 Copying to tmp table SELECT a.attr_id, MIN(a.goods_attr_id ) AS goods_id, a.attr_value AS attr_value FROM `cdydtx`.`ecs_g

6652 cdydtx localhost:55816 cdydtx Query 0 Copying to tmp table SELECT a.attr_id, MIN(a.goods_attr_id ) AS goods_id, a.attr_value AS attr_value FROM `cdydtx`.`ecs_g

6654 cdydtx localhost:55818 cdydtx Query 0 Copying to tmp table SELECT a.attr_id, MIN(a.goods_attr_id ) AS goods_id, a.attr_value AS attr_value FROM `cdydtx`.`ecs_g

6655 cdydtx localhost:55819 cdydtx Query 0 Copying to tmp table SELECT a.attr_id, MIN(a.goods_attr_id ) AS goods_id, a.attr_value AS attr_value FROM `cdydtx`.`ecs_g

6656 cdydtx localhost:55820 cdydtx Query 0 Copying to tmp table SELECT a.attr_id, MIN(a.goods_attr_id ) AS goods_id, a.attr_value AS attr_value FROM `cdydtx`.`ecs_g

6657 cdydtx localhost:55821 cdydtx Query 0 Sending data SELECT a.attr_name FROM `cdydtx`.`ecs_attribute` AS a, `cdydtx`.`ecs_goods_attr` AS ga, `cdydtx`.`ec

6658 cdydtx localhost:55822 cdydtx Query 0 Copying to tmp table SELECT a.attr_id, MIN(a.goods_attr_id ) AS goods_id, a.attr_value AS attr_value FROM `cdydtx`.`ecs_g

6659 cdydtx localhost:55823 cdydtx Query 0 Copying to tmp table SELECT a.attr_id, MIN(a.goods_attr_id ) AS goods_id, a.attr_value AS attr_value FROM `cdydtx`.`ecs_g

6660 cdydtx localhost:55824 cdydtx Query 0 Copying to tmp table SELECT a.attr_id, MIN(a.goods_attr_id ) AS goods_id, a.attr_value AS attr_value FROM `cdydtx`.`ecs_g

6661 cdydtx localhost:55825 cdydtx Query 0 Copying to tmp table SELECT a.attr_id, MIN(a.goods_attr_id ) AS goods_id, a.attr_value AS attr_value FROM `cdydtx`.`ecs_g

6662 cdydtx localhost:55826 cdydtx Query 0 Copying to tmp table SELECT a.attr_id, MIN(a.goods_attr_id ) AS goods_id, a.attr_value AS attr_value FROM `cdydtx`.`ecs_g

6663 cdydtx localhost:55827 cdydtx Query 0 Copying to tmp table SELECT a.attr_id, MIN(a.goods_attr_id ) AS goods_id, a.attr_value AS attr_value FROM `cdydtx`.`ecs_g

6664 cdydtx localhost:55828 cdydtx Query 0 Copying to tmp table SELECT a.attr_id, MIN(a.goods_attr_id ) AS goods_id, a.attr_value AS attr_value FROM `cdydtx`.`ecs_g

6665 cdydtx localhost:55829 cdydtx Query 0 Sending data SELECT a.attr_name FROM `cdydtx`.`ecs_attribute` AS a, `cdydtx`.`ecs_goods_attr` AS ga, `cdydtx`.`ec

6666 cdydtx localhost:55830 cdydtx Query 0 Copying to tmp table SELECT a.attr_id, MIN(a.goods_attr_id ) AS goods_id, a.attr_value AS attr_value FROM `cdydtx`.`ecs_g

6667 cdydtx localhost:55831 cdydtx Query 0 Copying to tmp table SELECT a.attr_id, MIN(a.goods_attr_id ) AS goods_id, a.attr_value AS attr_value FROM `cdydtx`.`ecs_g

6668 cdydtx localhost:55832 cdydtx Query 0 Copying to tmp table SELECT a.attr_id, MIN(a.goods_attr_id ) AS goods_id, a.attr_value AS attr_value FROM `cdydtx`.`ecs_g

6669 cdydtx localhost:55833 cdydtx Query 0 statistics SELECT a.attr_id, MIN(a.goods_attr_id ) AS goods_id, a.attr_value AS attr_value FROM `cdydtx`.`ecs_g

6670 cdydtx localhost:55834 cdydtx Query 0 Sending data SELECT a.attr_name FROM `cdydtx`.`ecs_attribute` AS a, `cdydtx`.`ecs_goods_attr` AS ga, `cdydtx`.`ec

6671 cdydtx localhost:55835 cdydtx Query 0 Sending data SELECT a.attr_name FROM `cdydtx`.`ecs_attribute` AS a, `cdydtx`.`ecs_goods_attr` AS ga, `cdydtx`.`ec

6672 cdydtx localhost:55836 cdydtx Query 0 statistics SELECT a.attr_name FROM `cdydtx`.`ecs_attribute` AS a, `cdydtx`.`ecs_goods_attr` AS ga, `cdydtx`.`ec

6673 cdydtx localhost:55837 cdydtx Query 0 Copying to tmp table SELECT a.attr_id, MIN(a.goods_attr_id ) AS goods_id, a.attr_value AS attr_value FROM `cdydtx`.`ecs_g

6674 cdydtx localhost:55838 cdydtx Query 0 Copying to tmp table SELECT a.attr_id, MIN(a.goods_attr_id ) AS goods_id, a.attr_value AS attr_value FROM `cdydtx`.`ecs_g

6675 cdydtx localhost:55839 cdydtx Query 0 Copying to tmp table SELECT a.attr_id, MIN(a.goods_attr_id ) AS goods_id, a.attr_value AS attr_value FROM `cdydtx`.`ecs_g

6676 cdydtx localhost:55840 cdydtx Query 0 statistics SELECT a.attr_id, MIN(a.goods_attr_id ) AS goods_id, a.attr_value AS attr_value FROM `cdydtx`.`ecs_g

6677 cdydtx localhost:55841 cdydtx Query 0 Sending data SELECT a.attr_name FROM `cdydtx`.`ecs_attribute` AS a, `cdydtx`.`ecs_goods_attr` AS ga, `cdydtx`.`ec

6678 cdydtx localhost:55842 cdydtx Query 0 Sending data SELECT a.attr_name FROM `cdydtx`.`ecs_attribute` AS a, `cdydtx`.`ecs_goods_attr` AS ga, `cdydtx`.`ec

6679 cdydtx localhost:55843 cdydtx Query 0 Sending data SELECT a.attr_name FROM `cdydtx`.`ecs_attribute` AS a, `cdydtx`.`ecs_goods_attr` AS ga, `cdydtx`.`ec

6680 localhost:55844 NULL Query 0 NULL show  processlist

问:我都晓得是数据卡出问题,我们这边没有技术人员了,麻烦帮我看看,谢谢!

答:您好,1.目前为您优化了D:\\SOFT_PHP_PACKAGE\\mysql\\my.ini文件,优化了如下参数;

          2.查看访问日志有大量访问您的站点,当前在D:\\www\\cdydtx\\www\\web.config里已经屏蔽了此域名www.semrush.com访问,现在查看服务器cpu已经下降了,非常感谢您长期对我司的支持!

tmp_table_size=512M

max_connections=1000

wait_timeout=20

问:你好!意思是被人植入了?谢谢!

答:您好,这是国外的一种蜘蛛,在大量爬取您的网站造成,现在还帮您用安全组屏蔽了这个蜘蛛的ip段,访问日志已经没有大量的访问了,再观察,非常感谢您长期对我司的支持!

问:还是不对,现在CPU又升高了

问:

答:您好, 还有两个个ip段又大量访问过您的网站,已经帮您屏蔽,之后请自行观察日志,或者用第三方统计工具观察访问情况,这些属于不正常的访问

日志在D:\\w3log\\W3SVC10004 

安全组屏蔽ip段方法https://www.west.cn/faq/list.asp?unid=1427

,非常感谢您长期对我司的支持!

更多关于云服务器域名注册虚拟主机的问题,请访问西部数码官网:www.west.cn
赞(0)
声明:本网站发布的内容(图片、视频和文字)以原创、转载和分享网络内容为主,如果涉及侵权请尽快告知,我们将会在第一时间删除。文章观点不代表本网站立场,如需处理请联系客服。电话:028-62778877-8306;邮箱:fanjiao@west.cn。本站原创内容未经允许不得转载,或转载时需注明出处:西部数码知识库 » 服务器负载高,网站打不开

登录

找回密码

注册