MYSQL High Load on server

irshad101

• February 05, 2021 09:48

Hello, I have linux server with bellow configration Intel Xeon E3-1245V2 2x HDD SATA 3,0 TB Enterprise 4x RAM 8192 MB DDR3 ECC NIC 1 Gbit mysql usage is very high, see attached server load and top result -02-05 at 15.46.29.png">70309-02-05 at 15.46.48.png">70313 and this load stays like that, what can be reason and how to fix that. Thanks so much

• 

  ffeingol

  • February 05, 2021 14:55

  can you post the results of mysqladmin processlist
  That will show what is currently going on with MySQL.

  0
• 

  cPRex Jurassic Moderator

  • February 05, 2021 16:36

  For some additional details I always like this one: mysqladmin proc status
  as that will also how the total queries per second and if there are any slow queries happening.

  0

Please sign in to leave a comment.