Problem with database

Support and Discussion Database Server
1

I have a site with the Careerfy template and plugin in Wordpress this is used for a job application system.

I used to have my installation on AWS EC2 on ubuntu 20.04.

I switched to another VPS with ubuntu 20.04 and cyberpanel, when I enter the part of the module where I see 14,000 users it takes 1:20 seconds to respond, I have tested the site on a hosting with cpanel and it takes 12 sec, test on a vps with NGnix + hestia and it takes 6 seconds.

What could be happening with cyberpanel that takes so long to respond?

VPS with 4 CPU - 8 GB of ram

2

try speedtest cli
see the upload rate of your server from some test site like dallas, texas, vietnam, SG, AUS, FR, DE

3

I don’t think it is a network problem, the tests on the other VMs were on the same server with the same network connection.

The frontend of the site loads extremely fast.

-------------------- A Bench.sh Script By Teddysun -------------------
Intro : 一键测试脚本bench.sh | 秋水逸冰
Version : v2022-01-01
Usage : wget -qO- bench.sh | bash

CPU Model : QEMU Virtual CPU version 2.5+
CPU Cores : 4
CPU Frequency : 2399.998 MHz
CPU Cache : 512 KB
Total Disk : 80.5 GB (18.0 GB Used)
Total Mem : 7820 MB (1384 MB Used)
Total Swap : 2559 MB (6 MB Used)
System uptime : 24 days, 17 hour 20 min
Load average : 0.13, 0.19, 0.22
OS : CentOS Linux release 7.9.2009 (Core)
Arch : x86_64 (64 Bit)
Kernel : 3.10.0-1160.49.1.el7.x86_64
TCP CC : cubic
Virtualization : KVM
Organization : AS29802 HIVELOCITY, Inc.
Location : Tampa / US
Region : Florida

I/O Speed(1st run) : 901 MB/s
I/O Speed(2nd run) : 1.0 GB/s
I/O Speed(3rd run) : 1.0 GB/s
I/O Speed(average) : 983.0 MB/s

The problem only occurs with the mentioned module when it calls the database all that information takes more than 90 seconds to respond.

5

I thought I’d take a look but it’s geographically restricted.

1 Like
6

i dont know exactly what is the problem
but let me tell u something

Networking sometimes messed up… because of admin’s configuration, or something else

oot: i remember long long long times ago
i have reseller hosting with space 2GB
i can sell 8 Hosting Account with space they pay me for 500MB lol
and i was network admin long long long time ago at small ISP i do some trick for baremetal server
if i have networking 1 GB
but i do some trick with burst …
if total Tx = x then burst to x2 for ysec
and sometimes without any trick… the speed or connection meesed up because my routing config

ok back to topic

let back to this statement…
you should test with iftop or iptraf or other monitoring tools + some internal resources monitor like htop atop or else. you cant just test on end-user interface.
and u must have same spec, same datacenter, same internal network.

and the most important things
if you are not face to face with the gateway port/server…never ever trust the speed
you can check using speedtest cli several times from some server at dallas,vietnam,sg,aussi,german
ex.
do 3 times speedtest at same server
see the result with the link as the result. if you understand the connection
u can read the graphics not just final result. see the progress.

7

I have done all kinds of tests and I can’t find the problem.

Any specialist who can write to me internally and earn some extra money to solve this problem please.

8

What you can do here is optimize your mysql config
Make sure you run the Cyberpanel upgrade command even though if its on latest version. The latest cyberpanel has provided default mysql config settings in it.

Secondly, make sure the port speed is good enough and not restrictive.

Try disabling the firewall for a while to test this.

Restart server once