System is working on some queries already

From Kolmisoft Wiki
Revision as of 10:03, 24 October 2018 by Valerij (talk | contribs) (→‎Cause)
Jump to navigationJump to search

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



Query list.png

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