System is working on some queries already

Cause

You see this message if in the MOR menu:

Setup/Settings/Server Load TAB you have setup values

Server Load is too high when one of these conditions are met:

1.HDD utilisation higher than:

2.CPU General load higher than:

3.CPU Ruby process higher than:

And other

Why it happens ?

1.Many queres goes to mysql

2.Many calls.

3.Working with rates.

4.Working with reports.

5.In other cases when many users logged into the webgui and pressing different buttons to learn menu.

Also possible bad hard disk condition, which must be replaced.

Solutions

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