VPS server speed very slow mysql issue

Lezárva Kiadva: 5 évvel ezelőtt Kiszállításkor fizetve
Lezárva Kiszállításkor fizetve

PLEASE IGNORE THE BUDGET AS WE NEED TO DISCUSS

The speed of my web hosting is very slow for some reason, it is okay when I have a few people on the website like up to 10. When there is 25 - 35 people the website slows down and is too slow to use.

SEE attached screenshot for TOP results in ssh. I believe it is a database issue as it is using 100% CPU. server details below.

You need to start your proposal with, Hello Anthony. This is so I know you have read and understood this

Host: Vultr VPS

CentOS 7 x64

CPU: 4 vCore

RAM: 8192 MB

Storage: 100 GB SSD

Bandwidth: 29.86 GB of 4000 GB

Apache Linux MySQL PHP Rendszergazda

Projektazonosító: #18490601

A projektről

34 ajánlat Távolról teljesíthető projekt Utoljára aktív: 5 évvel ezelőtt

34 szabadúszó tett átlagosan 59$ összegű árajánlatot erre a munkára

dkokmadis

Hello from Greece, Do you have root ssh access to vultr vps? Would you like to have a chat? Best Regards, Dimitris

$20 AUD 1 napon belül
(609 vélemény)
7.6
tlchung

Hello Anthony. I can find out what causing high cpu usage and fix it for you. I am a skilled server admin with over 10 years experience. let discuss more via private message.

$66 AUD 2 napon belül
(513 vélemény)
7.5
vili1977

Hello Anthony. I would like to help you with site server optimization issue. I have expeience. Please read my feedbaks. Thank you.

$20 AUD 1 napon belül
(1042 vélemény)
7.6
dynamitewebsol

Hello, I read your requirements and understand very-well and ready to start work from now. Thank you

$100 AUD 2 napon belül
(208 vélemény)
7.5
bindmission

Hello, Hope you are doing well. I have 6 years of experience in Linux and Webhosting. I will help you to speed up website. We need to Optimise DB and Webserver. Regards. VishnuLal

$45 AUD 1 napon belül
(526 vélemény)
7.4
tanujchugh

Hi I will resolve the issue of mysql for vps server as per your requirement and have expertise in the relevant field.I have 9 years of experience. Regards

$45 AUD 3 napon belül
(414 vélemény)
7.1
mizanbdit

Hi, Your server setup is very good, Need to configure and optimize to reduce http request and file size. Will configure apahce, mysql, and other to get highest possible performance. I have relevant experience to Továbbiak

$100 AUD 3 napon belül
(113 vélemény)
6.7
stels88

Hello Anthony, I am linux sys admin, with wide experience in hosting field, I am ready to help you with your server configuration/speed troubleshot

$66 AUD 2 napon belül
(281 vélemény)
6.9
Gauravsingh9828

Hi i will optimise your server and resolve the issue.I am working as server admin from past 5 years and have expertise in the task like this one. I have good command over Apache, Linux, MySQL, PHP, System Admin and Továbbiak

$50 AUD 1 napon belül
(177 vélemény)
6.3
Hostingshades

Hello Anthony, I'll help you to optimise mysql and all other things that will increase your server and site speed. Please initiate a chat session so we can discuss more about it. thank you

$30 AUD 1 napon belül
(139 vélemény)
5.9
logicalsoft

Need to talk with customer to discuss Need to talk with customer to discuss Need to talk with customer to discuss Need to talk with customer to discuss

$37 AUD 10 napon belül
(13 vélemény)
5.5
redssr

Did you had enabled MySQL slow queries, if yes are there any such queries in MySQL processlist or slow query logs Is seems your php-fpm processes are also taking too cpu usage, did you checked php error logs for this Továbbiak

$50 AUD 3 napon belül
(138 vélemény)
5.4
ikabsd

Hello Anthony, I have deep experience in situations like this. Can debug MySQL procedures and tune your mysql instance *BUT* in case there is a code issue, I cannot help with this. P.S Also I can suggest query caching Továbbiak

$77 AUD 0 napon belül
(16 vélemény)
5.2
EngMah

Hello Anthony From your screenshot, it looks like that php also involved in the slowness. Maybe your queries are horrible. I faced this issue with a server of a municapility before and it turned out that my queries w Továbbiak

$45 AUD 10 napon belül
(44 vélemény)
5.0
raushanex

Hello Anthony, It's the really very small visitor, As far as screenshot concerned issue with FPM setting. It looks like server not optimized yet. I have 7+ years experienc in era of system admin I will assure you i Továbbiak

$55 AUD 1 napon belül
(14 vélemény)
5.1
ebonk

Hello, I see you have a poor mysql performance problem. I can help you find the root causes, any slow queries, that consumes so much cpu usage. I will need ssh access to your vps. We can discuss the budget so it reaso Továbbiak

$111 AUD 2 napon belül
(16 vélemény)
5.1
NitinSheoran

Hello Anthony, I'll resolve your issue in minimum time. Please inbox me for further communication. thank you.

$30 AUD 1 napon belül
(59 vélemény)
4.9
chiragdosi

Hello Anthony, I am a Red Hat Certified Linux Engineer with more than 5 years of experience in Managing Core Server including Dedicated Server and VPS Server, Server Security and Optimization and Complete Server Set Továbbiak

$40 AUD 1 napon belül
(38 vélemény)
5.1
Ashish01429

I have 5 years experience in setup and management of different Linux web hosting servers, Cloud Servers, Server Management, Server Security, Mailing Servers, Email Servers, SSL, Server Monitoring etc. i will configu Továbbiak

$35 AUD 1 napon belül
(47 vélemény)
4.8
Wulfyuk

Hello Anthony Hope your well today, I believe your issue is not directly related to your database rather how your site is exhausting the max connections apache has available and needs to be configured to allow more Továbbiak

$37 AUD 10 napon belül
(18 vélemény)
4.9