Operating System & Version
Cloudlinux 8
cPanel & WHM Version
106

retechpro

Well-Known Member
Dec 23, 2022
141
16
18
Pakistan
cPanel Access Level
Root Administrator
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

Jurassic Moderator
Staff member
Oct 19, 2014
17,470
2,843
363
cPanel Access Level
Root Administrator
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.