Mysql Optimization Required

[retechpro]

Hi Mates, Could anyone help to optimize my mysql. I don’t have technical knowledge of linux.

Server mysql are taking 30-35GB ram and 70% cpu always.
Max connection is 10000 because when i do defualt setting. Sites goes down and took 30-60s for load. When i do 10000 connection then it work fine. I don’t know why this is happening.

Servers specs:
Ryzen 5950x with 128GB ECC DDR4
4X2TB NVMe(Raid-1)
Using Cloudlinux, cpanel, litespeed and Imunify360.

 

[cPRex]

Hey there! There isn't enough information here to help give you exact details, and I personally wouldn't be able to provide specific settings for the MySQL service on my end.

I would recommend examining the "mysqladmin proc status" command so you can be certain what is happening with the MySQL service in real-time. You could also use the MySQL tuner script that is popular online to scan your server and give you more details about the system.

 

[retechpro]

Ok i will update with the mysql tuner result