problem high load

hatembadran

• August 25, 2022 14:41

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

  • August 25, 2022 19:44

  0
• 

  cPRex Jurassic Moderator

  • August 25, 2022 20:50

  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?

  0
• 

  hatembadran

  • August 25, 2022 21:17

  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

  0
• 

  hatembadran

  • August 25, 2022 21:18

  and please Screenshot lite speed conffgraion

  0
• 

  cPRex Jurassic Moderator

  • August 25, 2022 21:26

  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.

  0

Please sign in to leave a comment.