Difference between revisions of "System is working on some queries already"
From Kolmisoft Wiki
Jump to navigationJump to search
(→Cause) |
(→Cause) |
||
| Line 1: | Line 1: | ||
= Cause = | = Cause = | ||
Why it happens when many requests goes to mysql: | Why it happens when many requests goes to mysql: | ||
<br><br> | |||
1.Many calls. | 1.Many calls. | ||
<br><br> | |||
2.Working with rates. | 2.Working with rates. | ||
<br><br> | |||
3.Working with reports. | 3.Working with reports. | ||
<br><br> | |||
4.In other cases when many users logged into the webgui and pressing different buttons to learn menu. | 4.In other cases when many users logged into the webgui and pressing different buttons to learn menu. | ||
<br><br> | |||
= Solutions = | = Solutions = | ||
Revision as of 10:03, 24 October 2018
Cause
Why it happens when many requests goes to mysql:
1.Many calls.
2.Working with rates.
3.Working with reports.
4.In other cases when many users logged into the webgui and pressing different buttons to learn menu.
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
