Slow webpage due to hight SQL load.
Budget: $30 – $250 USD
My page uses WHM and cPanel with Mysql.
When i got arround 700 visitors at the same time the loadtime is long (Arround 10 sec for eatch click on the page).
I need someone thats an exspert on SQL to help me tune this sql server to work fastest.
My server Specs are:
16gb ram.
6 vCPUs
AlmaLinux with WHM.
360GB SSD.
If you are intersted please write ***MYSQL READ*** in the top of your bidding so i know you are not a bot.
Stats:
Network traffic since startup: 1,0 GiB
This MySQL server has been running for 0 days, 0 hours, 11 minuttes og 50 sec. It started up on 19. Okt, 2022 17:43 PM.
Trafic # ø per hour
Recived 13,0 MiB 65,7 MiB
Sendt 1,0 GiB 5,0 GiB
Total 1,0 GiB 5,0 GiB
Conncetins # ø per time %
Max. concurrent connections 9 --- ---
Feilede forsøk 1 5,07 <0.01%
Avbrutt 0 0 0%
Totalt 3.382 17,15 k 100,00%
--
Questions since startup: 236.641 Dokumentasjon
ø per hour: 1.075.641
ø per minute: 17.927
ø per second: 299
When i got arround 700 visitors at the same time the loadtime is long (Arround 10 sec for eatch click on the page).
I need someone thats an exspert on SQL to help me tune this sql server to work fastest.
My server Specs are:
16gb ram.
6 vCPUs
AlmaLinux with WHM.
360GB SSD.
If you are intersted please write ***MYSQL READ*** in the top of your bidding so i know you are not a bot.
Stats:
Network traffic since startup: 1,0 GiB
This MySQL server has been running for 0 days, 0 hours, 11 minuttes og 50 sec. It started up on 19. Okt, 2022 17:43 PM.
Trafic # ø per hour
Recived 13,0 MiB 65,7 MiB
Sendt 1,0 GiB 5,0 GiB
Total 1,0 GiB 5,0 GiB
Conncetins # ø per time %
Max. concurrent connections 9 --- ---
Feilede forsøk 1 5,07 <0.01%
Avbrutt 0 0 0%
Totalt 3.382 17,15 k 100,00%
--
Questions since startup: 236.641 Dokumentasjon
ø per hour: 1.075.641
ø per minute: 17.927
ø per second: 299