Technical problems in the database

AriyanPayamak

Verified User
Joined
Nov 4, 2014
Messages
28
Greetings,
I am using the server with the following characteristics:
Intel(R) Xeon(R) CPU E5-1650 0 @ 3.20GHz

Twenty-user use it.
Unfortunately, we are constantly receiving messages.
Warning: The system load average is 100.08
Warning: The system load average is 16.12
Code:
 19413 mysql     20   0  902m 115m 3884 S  0.3  4.0  65:45.09 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/lib/mysql/server.7vps.ir.err --pid-file=/var/lib/mysql/server.7vps.ir.pid                                                                                                                                                                                                                                                                                                                              
One Minute      - 140.47
Five Minutes    - 100.08
Fifteen Minutes - 52.13

top - 07:30:28 up 1 day, 21:10,  0 users,  load average: 122.42, 98.70, 52.70
Tasks: 513 total,   4 running, 509 sleeping,   0 stopped,   0 zombie
Cpu(s): 20.4%us,  5.0%sy,  0.0%ni, 70.8%id,  3.7%wa,  0.0%hi,  0.0%si,  0.0%st
Mem:   2956660k total,  2890756k used,    65904k free,     5916k buffers
Swap:  2064380k total,  1486804k used,   577576k free,    25920k cached
This error indicates that the database server is high consumption of
With the increase in server memory still remains error
Please send your tips to fix the error.
ThankYou
 
Hello,

Try and check your tables, some of them might be corrupted. Enable slow logs and use a mysql-queries monitor to see what queries are currently running and in what state: sleep or another.

Or you probably want to hire somebody to check and fix it for you.
 
Back
Top