VPS server speed very slow mysql issue

Closed Posted 5 years ago Paid on delivery
Closed Paid on delivery

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 System Admin

Project ID: #18490601

About the project

34 proposals Remote project Active 5 years ago

34 freelancers are bidding on average $59 for this job

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 day
(609 Reviews)
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 days
(513 Reviews)
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 day
(1042 Reviews)
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 days
(208 Reviews)
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 day
(526 Reviews)
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 days
(414 Reviews)
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 More

$100 AUD in 3 days
(113 Reviews)
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 days
(281 Reviews)
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 More

$50 AUD in 1 day
(177 Reviews)
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 day
(139 Reviews)
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 days
(13 Reviews)
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 More

$50 AUD in 3 days
(138 Reviews)
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 More

$77 AUD in 0 days
(16 Reviews)
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 More

$45 AUD in 10 days
(44 Reviews)
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 More

$55 AUD in 1 day
(14 Reviews)
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 More

$111 AUD in 2 days
(16 Reviews)
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 day
(59 Reviews)
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 More

$40 AUD in 1 day
(38 Reviews)
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 More

$35 AUD in 1 day
(47 Reviews)
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 More

$37 AUD in 10 days
(18 Reviews)
4.9