问：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
问：噢噢 谢谢帅帅的工程师
答：您好，不客气,非常感谢您长期对我司的支持!谢谢!
