問:
服務器重啟過了,網站關閉試過了,都沒有解決這個情況,麻煩盡快處理,服務器負載高,網站打不開
答:您好,1、您的站點存在CC攻擊, 剛剛為您關閉httpd ,負載逐漸降低 (您是否又自行啟動了apache ?) ,建議您可以開啟百度云加速,有CC防御的左右, 另外 您服務器內部是寶塔面板,寶塔面板 -收費軟件- 有apache防火墻,您可以安裝 防火墻,也可以設置 CC防御 頻率 ,非常感謝您長期對我司的支持!
問: 還是沒有解決呀
答:您好,1、您的網站存在CC攻擊,需要通過軟件防火墻 或硬件防火墻 進行防御。 我司接入了百度云加速,目前設置的防護級別是 高級,請您稍后測試下。
另外也可以開啟防護 ‘強制驗證’ 就是需要輸入驗證碼才可以訪問, 有防護效果。
您使用的是寶塔面板 – 在軟件管理 – apache 防火墻 ,可以安裝防火墻 設置 cc 頻率 。
2、另外我司有硬件防火墻, http://www.shinetop.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段方法http://www.shinetop.cn/faq/list.asp?unid=1427
,非常感謝您長期對我司的支持!