Help us reduce our CPU load caused by a MySQL (MariaDB) and PHP Application.

Mbyllur Postuar 5 vite mё parё Paguhet në dorëzim
Mbyllur Paguhet në dorëzim

Hello

We have a CPanel/WHM server that constantly is experiencing high CPU load at peak times of the day.

We want to reduce the load.

The cause of the load is definitely MySQL (Mariadb) as shown by a simple "htop" screen capture. I am not sure if it's due to a poorly written PHP application that uses the MariaDB database or what....or if it's just poor server configuration to handle the traffic.

The applicant must have experience in MYSQL (MariaDB) and server configuration to help optimize performance. Must also be able to identify causes and fix these causes in any PHP scripts that might be causing this. So, vast experience in PHP is a requirement.

We have already:

- added Nginx as a front end reverse proxy

- changed different settings for [login to view URL]

- configured php-fpm and tried some different settings there

- run slow queries for mysql (although we did not do anything with that)

- Use mysqltuner without success.

The server has alot of ram and CPU so it can handle the high CPU load, however, the applications begin to slow down and lag at these CPU levels so it is best to reduce the load.

When the load goes down, the applications run smoother.

The reduction in CPU load and/or optimization of the PHP code (add indexes?) is a requirement to increase performance and get rid of lag is a requirement for completion of this project.

Apache Linux MariaDB PHP System Admin

ID Projekti: #18654631

Rreth projektit

16 propozimet Projekti në distancë Aktiv 5 vite mё parё

16 profesionistë freelancer dërguan një ofertë mesatare prej $37 për këtë punë

vili1977

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

$25 USD për 1 ditë
(1068 Përshtypje)
7.7
amin6106

Hi, What is your website url ? Is it custom coded using core php or some framework used ? I have experience of 9+ years in php, mysql etc. Waiting for your response to discuss it further. Thanks, Amin

$25 USD për 1 ditë
(88 Përshtypje)
6.4
risharde

Hi, in no way am I trying to be disrespectful to you but that budget is way too low for the immense work that would probably be required. You do sound like you know a lot more than many hosters as your attempts seem va Më shumë

$35 USD për 1 ditë
(25 Përshtypje)
5.5
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 Më shumë

$20 USD për 1 ditë
(47 Përshtypje)
4.8
navneetkhare

Are you on a shared (virtual) server space or a an actual separate physical server space? Because, sometimes, the problem is the server itself rather than the load and it just looks like the CPU is reaching max usage w Më shumë

$30 USD për 1 ditë
(24 Përshtypje)
4.4
NurulKadir

Dear Sir, I am interested of your job. I am confident to fix server cpu load issue. I have experience to handle huge traffic and fine tune MySQL. I am CakePHP programmer also. so i can take care of server side and app Më shumë

$55 USD për 1 ditë
(9 Përshtypje)
4.2
Superbsolutions

Hello! I've 6 years of experience in webhosting field. currently working in a hosting company as a sys admin. i have vast experience in cpanel configurations, software installations, dns configurations, ssl installat Më shumë

$55 USD për 1 ditë
(41 Përshtypje)
4.4
Shreyaswarup

We have limitations in cpanel. I have to check the main cause of the issue. However, you can separate your MariaDB to put some load off. I am an experienced system administrator and programmer. I am running hosting c Më shumë

$35 USD për 1 ditë
(10 Përshtypje)
3.4
graphichaa

Hello I'm technical manager in a hosting company , and I can do it for you as free of charge then If you confirmed me accept this bid Kind Regards

$30 USD për 1 ditë
(2 Përshtypje)
2.6
billmask

You need PHP and MySQL Tuning. Not hard, I can even teach you where to find all you need and next time you can do yourself.

$55 USD për 1 ditë
(0 Përshtypje)
0.0
sinagt

Having experience in troubleshooting for servers more than 3 year. Setup many dedicated machine over centos and linux server environment.

$25 USD për 1 ditë
(0 Përshtypje)
0.0
zairius

I've been making things 'go faster' for over 10 years, and at my current job I inherited a legacy billing system that used to take 13 hours to generate invoices on the first of the month and with a few tweaks I got tha Më shumë

$25 USD për 1 ditë
(0 Përshtypje)
0.0