problem high load

[hatembadran]

Hello
it's big problem with high load


80523 mysql 20 0 1912180 242276 10456 S 55.5 0.7 10:19.86 /usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid


dedicated server

Hardware
CPUIntel Xeon E3-1245v2 - 4c/8t - 3.4 GHz/3.8 GHzRAM
32 GB 1333 MHz
Data disks
2×480 GB SSD SATA
Expansion cardsSoft RAID

centos 7 with cloud lunix shared pro

 

[hatembadran]

Screenshot

Captured with Lightshot

prnt.sc

 

[cPRex]

Hey there! Unless your machine is a single-core CPU system, that specific output doesn't look bad to me. That would indicate that MySQL is using 55% of one CPU core.

Do you see anything else in "top" that could provide a clue? Alternatively, if you stop the MySQL service for a few minutes, does the load quickly go down on the system?

Could you also let us know the overall load and the machine?

 

[hatembadran]

it's dedicated server
and no website
can you tell me what is best configration for my sql
becuase i dodn't do any thing in configration my sql

 

[hatembadran]

and please Screenshot lite speed conffgraion

 

[cPRex]

Thanks for the additional details. That load average looks fine to me - I wouldn't change anything. That shows the CPU is 91% idle, so it's not doing very much at all.

Are you seeing a specific problem with the server?

We generally don't recommend specific configuration options as those need to be handled by a server administrator, but everything seems to be running well on your machine from the details I can see.