Difference between revisions of "System is working on some queries already"
From Kolmisoft Wiki
Jump to navigationJump to search
| Line 9: | Line 9: | ||
== Kill MySQL Query == | == Kill MySQL Query == | ||
1. Log in to the server over SSH. | |||
<br><br> | |||
2. Connect to the mysql | |||
<br><br> | |||
mysql -u root -pkolmisoft | |||
3. Check processlist | |||
<br><br> | |||
select * from INFORMATION_SCHEMA.PROCESSLIST where db = 'mor'\g | |||
<br><br> | |||
[[File:Query_list.png]] | |||
<br><br> | |||
4. Kill process which is overloading mysql | |||
mysql> kill 2488509; | |||
= Precaution = | = Precaution = | ||
Revision as of 09:40, 24 October 2018
Cause
Solutions
Wait
Kill MySQL Query
1. Log in to the server over SSH.
2. Connect to the mysql
mysql -u root -pkolmisoft
3. Check processlist
select * from INFORMATION_SCHEMA.PROCESSLIST where db = 'mor'\g
4. Kill process which is overloading mysql
mysql> kill 2488509;
Precaution
Setting for users to limit for how many days they can watch statistics
Check slow query log
