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

Cerrado Publicado hace 5 años Pagado a la entrega
Cerrado Pagado a la entrega

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 Administración de sistemas

Nº del proyecto: #18654631

Sobre el proyecto

16 propuestas Proyecto remoto Activo hace 5 años

16 freelancers están ofertando un promedio de $37 por este trabajo

vili1977

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

$25 USD en 1 día
(1068 comentarios)
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 en 1 día
(88 comentarios)
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ás

$35 USD en 1 día
(25 comentarios)
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ás

$20 USD en 1 día
(47 comentarios)
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ás

$30 USD en 1 día
(24 comentarios)
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ás

$55 USD en 1 día
(9 comentarios)
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ás

$55 USD en 1 día
(41 comentarios)
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ás

$35 USD en 1 día
(10 comentarios)
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 en 1 día
(2 comentarios)
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 en 1 día
(0 comentarios)
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 en 1 día
(0 comentarios)
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ás

$25 USD en 1 día
(0 comentarios)
0.0