問：mysql ，NTFS日志瘋狂寫入，服務器的cpu非常高，網站卡頓，怎么解決,服務器負載高，NTFS日志瘋狂寫入
答：您好，查看是數據庫daishi中執行查詢表ds_arctiny太多次數,嘗試幫您把ds_arctiny.id列添加了索引,目前看cpu有所降低了,請您檢查下dsbuxi這個站點,是否在做一些任務計劃等工作,非常感謝您長期對我司的支持!謝謝!
140 daishi localhost:51013 daishi Query 0 Sorting result SELECT id FROM `ds_arctiny` arc WHERE arc.arcrank > -1 AND ( arc.typeid IN(8,25,26,27,65,63,64,66
142 daishi localhost:51015 daishi Query 2 Sorting result SELECT id FROM `ds_arctiny` arc WHERE arc.arcrank > -1 AND ( arc.typeid IN(8,25,26,27,65,63,64,66
145 daishi localhost:51019 daishi Query 1 Sorting result SELECT id FROM `ds_arctiny` arc WHERE arc.arcrank > -1 AND ( arc.typeid IN(8,25,26,27,65,63,64,66
147 daishi localhost:51022 daishi Query 2 Sorting result SELECT id FROM `ds_arctiny` arc WHERE arc.arcrank > -1 AND ( arc.typeid IN(8,25,26,27,65,63,64,66
150 daishi localhost:51025 daishi Query 2 Sorting result SELECT id FROM `ds_arctiny` arc WHERE arc.arcrank > -1 AND ( arc.typeid IN(8,25,26,27,65,63,64,66
177 daishi localhost:51052 daishi Query 2 Sorting result SELECT id FROM `ds_arctiny` arc WHERE arc.arcrank > -1 AND ( arc.typeid IN(8,25,26,27,65,63,64,66
180 daishi localhost:51055 daishi Query 1 Sorting result SELECT id FROM `ds_arctiny` arc WHERE arc.arcrank > -1 AND ( arc.typeid IN(8,25,26,27,65,63,64,66
182 daishi localhost:51057 daishi Query 2 Sending data SELECT id FROM `ds_arctiny` arc WHERE arc.arcrank > -1 AND ( arc.typeid IN(8,25,26,27,65,63,64,66
189 daishi localhost:51064 daishi Query 2 freeing items SELECT id FROM `ds_arctiny` arc WHERE arc.arcrank > -1 AND ( arc.typeid IN(8,25,26,27,65,63,64,66
191 daishi localhost:51066 daishi Sleep 0 NULL
211 daishi localhost:51086 daishi Query 0 Sorting result SELECT id FROM `ds_arctiny` arc WHERE arc.arcrank > -1 AND ( arc.typeid IN(8,25,26,27,65,63,64,66
219 daishi localhost:51095 daishi Query 2 Sorting result SELECT id FROM `ds_arctiny` arc WHERE arc.arcrank > -1 AND ( arc.typeid IN(8,25,26,27,65,63,64,66
221 daishi localhost:51099 daishi Query 2 Sorting result SELECT id FROM `ds_arctiny` arc WHERE arc.arcrank > -1 AND ( arc.typeid IN(8,25,26,27,65,63,64,66
288 daishi localhost:51173 daishi Sleep 0 NULL
291 daishi localhost:51178 daishi Sleep 0 NULL
295 daishi localhost:51182 daishi Query 1 freeing items SELECT id FROM `ds_arctiny` arc WHERE arc.arcrank > -1 AND ( arc.typeid = '65' OR CONCAT(',', ar
298 daishi localhost:51185 daishi Sleep 0 NULL
301 daishi localhost:51188 daishi Query 1 Sorting result SELECT id FROM `ds_arctiny` arc WHERE arc.arcrank > -1 AND ( arc.typeid IN(8,25,26,27,65,63,64,66
問：噢噢 謝謝帥帥的工程師
答：您好，不客氣,非常感謝您長期對我司的支持!謝謝!