VPS server speed very slow mysql issue

Chiuso Pubblicato 5 anni fa Pagato alla consegna
Chiuso Pagato alla consegna

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 Amministratore di sistema

Rif. progetto: #18490601

Info sul progetto

34 proposte Progetto a distanza Attivo 5 anni fa

34 freelance hanno fatto un'offerta media di $59 per questo lavoro

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 in 1 giorno
(609 valutazioni)
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 in 2 giorni
(513 valutazioni)
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 in 1 giorno
(1042 valutazioni)
7.6
dynamitewebsol

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

$100 AUD in 2 giorni
(208 valutazioni)
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 in 1 giorno
(526 valutazioni)
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 in 3 giorni
(414 valutazioni)
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 Altro

$100 AUD in 3 giorni
(113 valutazioni)
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 in 2 giorni
(281 valutazioni)
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 Altro

$50 AUD in 1 giorno
(177 valutazioni)
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 in 1 giorno
(139 valutazioni)
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 in 10 giorni
(13 valutazioni)
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 Altro

$50 AUD in 3 giorni
(138 valutazioni)
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 Altro

$77 AUD in 0 giorni
(16 valutazioni)
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 Altro

$45 AUD in 10 giorni
(44 valutazioni)
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 Altro

$55 AUD in 1 giorno
(14 valutazioni)
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 Altro

$111 AUD in 2 giorni
(16 valutazioni)
5.1
NitinSheoran

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

$30 AUD in 1 giorno
(59 valutazioni)
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 Altro

$40 AUD in 1 giorno
(38 valutazioni)
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 Altro

$35 AUD in 1 giorno
(47 valutazioni)
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 Altro

$37 AUD in 10 giorni
(18 valutazioni)
4.9