SQL slow query causes CPU memory to reach 100%, what should I do?

Question

It is said that there are a large number of slow query records in the database, and the execution time is too long, resulting in resource exhaustion. What should I do? Delete mysql-bin.XXXXXXX and mysql-bin.XXXXXXX in mysql-bin.index. Delete mysql-slow.log and rebuild log-bin=mysql-binbinlog_format=mixedserver-id = 1expire_logs_days = 10slow_query_log=0slow. -query-log-file=/www/server/data/mysql-slow.loglong_query_time=1#log_queries_not_using_indexes=on

Answer 1

See if we can create an index to optimize