問:http://www.zyshiqi.com/
127.0.0.1: 初始用戶名:**********
密碼:**********,網站又打不開,給查查什么原因,切換服務器后就經常給出問題
問:昨天還好好的 是不是缺少什么軟件
答:您好,測試服務器80端口通的,但是網站打開轉圈超時,和您提供這個截圖沒關系,我司查看是mysql的問題,mysql 鎖表了。
最終核實是有個表有問題需要修復,修復后重啟mysql正常了請您在核實測試,此工單扣除了一次金牌服務次數,獨立IP主機問題下次提交工單時請選擇主機租用vps、云主機類問題提交工單,非常感謝您長期對我司的支持.由此給您帶來的不便之處,敬請原諒!謝謝!
問:經常會出問題,每次都是數據庫問題,怎么增加下數據庫配置,別再讓出問題啊
問:現在又打不開了
問:還提示這個
答:您好,開啟慢查詢后查看到主要類似以下mysql語句執行慢經常鎖表:
幫您創建了幾個索引,我司測試查詢要快些了但是查詢多了后依然會導致慢,請您您聯系程序方檢查調整下程序,優化mysql查詢,非常感謝您長期對我司的支持!
問:以前沒有出現這個情況啊,也就是轉到新服務在這樣的,現在好像又卡住了
問:數據庫問題 應該是后臺卡,前臺怎么也卡
答:您好,可能是之前沒什么訪問量問題不明顯,有些訪問量后問題暴露出來了,前臺也是會讀數據庫的,頁面上顯示的產品等都會從數據庫讀出來的,
SELECT g.goods_id, g.goods_name, g.shop_price, g.goods_thumb, SUM(og.goods_number) as goods_number FROM `shiqishangmao`.`ecs_goods` AS g, `shiqishangmao`.`ecs_order_info` AS o, `shiqishangmao`.`ecs_order_goods` AS og WHERE g.is_on_sale = 1 AND g.is_alone_sale = 1 AND g.is_delete = 0 AND (g.cat_id IN ('2','24','120','20','305','315','33','302','26','21','117','34','29','123','214','119','3','38','221','295','223','181','177','225','226','254','262','40','35','228','222','312','227','244','261','4','47','64','124','53','173','318','130','234','175','180','176','275','48','131','245','259','324','193','325','172','137','55','307','247','277','49','170','171','299','42','273','289','51','127','128','125','126','5','252','286','253','276','313','231','60','158','65','293','189','61','66','62','288','332','230','233','57','6','72','69','178','70','251','140','7','258','323','187','77','80','218','298','260','300','74','257','322','81','8','94','268','266','267','191','207','201','195','192','208','256','209','200','90','291','165','87','198','95','154','155','156','161','157','91','290','278','160','279','132','129','297','272','92','265','269','169','190','89','236','240','308','237','82','241','238','287','242','239','270','217','243','84','264','9','105','215','99','106','255','281','103','164','174','100','303','97','104','317','314','152','182','196','150','319','316','197','194','183','184','101','310','167','163','311','320','168','202','250','263','203','98','139','329','330','331','10','108','109','321','212','213','107','186','210','1','294','326','115','133','16','204','13','271','116','17','188','284','220','280','14','199','216','122','246','18','143','141','274','219','142','328','159','15','12','19','102','211','205','232','206','144','147','134','138','151','301','249','235','248','146','327','185','135','224','304','282','283','296','309','153','306') OR g.goods_id IN ('492','662','698') ) AND g.goods_number > 0 AND og.order_id = o.order_id AND og.goods_id = g.goods_id AND (o.order_status = '1' OR o.order_status = '5') AND (o.pay_status = '2' OR o.pay_status = '1') AND (o.shipping_status = '1' OR o.shipping_status = '2') GROUP BY g.goods_id ORDER BY goods_number DESC, g.goods_id DESC LIMIT 8;
可以讓程序方看下此語句是實現的什么功能,調整優化語句或功能,非常感謝您長期對我司的支持!
問:也就這兩天才這樣,以前都沒問題啊,服務器配置還增加了,而且現在也沒人操作,還是很卡,以前也是這么多數據 都沒問題
答:您好,通過查詢數據來看是首頁這個銷量排行功能,只要訪問就會執行一次, 建議您調整此功能(看下后臺是否有設置項,可考慮關閉此功能后再測試) ,此問題是程序代碼優化方面的問題,我司確實也無法為您處理,如果您還有疑問建議您咨詢程序方協助調整優化(比如把銷量最高的產品數據寫到一個表中不要每次都去讀多個表聯合查詢排序看哪個銷量大),非常感謝您長期對我司的支持!
問:昨天還好好的呢 是不是服務器被攻擊了
答:您好,目前來看沒有攻擊的,日志分析來看有一些蜘蛛的訪問比如幫您設置了攔截, 同時建議您聯系程序方按上面的說明排查檢查優化下,否則您網站后期訪問量上去后問題會更嚴重,非常感謝您長期對我司的支持!
三五互聯(35.com)是經工信部、ICANN、CNNIC認證審批,持有ISP、云牌照、IDC、CDN、頂級域名注冊商等全業務資質的正規老牌服務商,自成立至今20余年專注于域名注冊、虛擬主機、云服務器、企業郵箱、企業建站等互聯網基礎服務!
截止目前,已經為超過2000萬個域名提供了注冊、解析等服務,是中國五星級域名注冊注冊商!已為超過50萬個網站提供了高速穩定的云托管服務,獲評中國最受用戶喜歡云主機服務商。
三五互聯提供全方位7X24H專業售后支撐,域名注冊特價1元起,高速穩定云主機45元起,更多詳情請瀏覽三五互聯官網:http://www.shinetop.cn/