VPS server speed very slow mysql issue

Zamknięty Opublikowano 5 lat temu Płatność przy odbiorze
Zamknięty Płatność przy odbiorze

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 Administrator systemu

Numer ID Projektu: #18490601

O projekcie

34 ofert Zdalny projekt Aktywny 5 lat temu

34 freelancerów złożyło ofertę za $59 w tym projekcie

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 w ciągu 1 dnia
(609 Oceny)
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 w ciągu 2 dni
(513 Oceny)
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 w ciągu 1 dnia
(1042 Oceny)
7.6
dynamitewebsol

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

$100 AUD w ciągu 2 dni
(208 Oceny)
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 w ciągu 1 dnia
(526 Oceny)
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 w ciągu 3 dni
(414 Oceny)
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 Więcej

$100 AUD w ciągu 3 dni
(113 Oceny)
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 w ciągu 2 dni
(281 Oceny)
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 Więcej

$50 AUD w ciągu 1 dnia
(177 Oceny)
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 w ciągu 1 dnia
(139 Oceny)
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 w ciągu 10 dni
(13 Oceny)
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 Więcej

$50 AUD w ciągu 3 dni
(138 Oceny)
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 Więcej

$77 AUD w ciągu 0 dni
(16 Oceny)
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 Więcej

$45 AUD w ciągu 10 dni
(44 Oceny)
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 Więcej

$55 AUD w ciągu 1 dnia
(14 Oceny)
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 Więcej

$111 AUD w ciągu 2 dni
(16 Oceny)
5.1
NitinSheoran

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

$30 AUD w ciągu 1 dnia
(59 Oceny)
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 Więcej

$40 AUD w ciągu 1 dnia
(38 Oceny)
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 Więcej

$35 AUD w ciągu 1 dnia
(47 Oceny)
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 Więcej

$37 AUD w ciągu 10 dni
(18 Oceny)
4.9