Help us reduce our CPU load caused by a MySQL (MariaDB) and PHP Application.
$10-30 USD
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.
Nº del proyecto: #18654631
Sobre el proyecto
16 freelancers están ofertando un promedio de $37 por este trabajo
Hello. I would like to help you with server optimization. I have expeience. Please read my feedbaks. Thank you.
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
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
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
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
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
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
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
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.
Having experience in troubleshooting for servers more than 3 year. Setup many dedicated machine over centos and linux server environment.