Kill slow queries mysql

# MySQL queries can sometimes be long-running and may prevent transactions from accessing necessary tables to complete a request. This will put your users on hold. In order to kill these long-running queries, you must access the environment’s MySQL database.
# Correcting Long-Running Queries
# When you are able to successfully make a local MySQL connection to the site’s database, run the ensuing command to present a list of accessible threads:
# Show processlist;


# Then review the “Time” field to find the longest running query
# Next, run the following command to kill it:


kill thread_ID;

 
# As a side note, be sure to replace <thread_id> with the ID of the query you want to deactivate or get rid of.


Kill All Queries


# If multiple bad requests are preventing valid queries from working, you can fix this by clearing them out without having to run kill on individual threads. 
Perform the following to produce kill commands from the PROCESSLIST table:


mysql> SELECT GROUP_CONCAT(CONCAT('KILL ',id,';') SEPARATOR ' ') 
 
FROM information_schema.processlist WHERE user <> 'system user';

# The final step is to copy the provided query in the output and run as instructed. This will fix your queries problem!

Similar codes

4 votes141 views1 answer
Update table from another table oracle
SQL
0 vote131 views1 answer
Drush SQLSTATE[HY000] [2002] No such file or directory
SQL
2 votes150 views2 answers
Mysql show table column comments sql
SQL
8 votes202 views2 answers
Oracle auto increment primary key
SQL
23 votes151 views3 answers
Sql where contains part of string
SQL
1 vote159 views1 answer
Insert value to new table by joining 2 different tables
SQL
0 vote137 views1 answer
Get the Domain Name, Page Name and Query Parameter from a URL
SQL
0 vote130 views1 answer
Oracle 11g forget password
SQL
24 votes135 views6 answers
Rename a column in sql server
SQL
0 vote136 views1 answer
Sequelize postgresql schema
SQL