
Closed
Posted
Paid on delivery
My newly-redesigned product catalogue site has been crashing the virtual cloud server it lives on. The load climbs rapidly until the kernel’s OOM-killer steps in, MySQL gets shot down, and Apache stops responding. Early digging points to two likely culprits: MySQL’s OOM score is too high, making it the first service killed, and suPHP is adding unnecessary overhead as our current PHP handler. What I need is a concise rescue and hardening job: STEP 1. • Diagnose the precise cause of the memory spikes and 100 % CPU events. • Re-tune (or override) the OOM score so MySQL stays alive under pressure. STEP 2. • Migrate the site from suPHP to a more efficient handler such as PHP-FPM or FastCGI, with zero downtime. • Verify database settings and query cache to be sure MySQL itself is not the bottleneck. • Hand back a short report describing what was changed and why, plus any follow-up recommendations. The stack is standard LAMP on a virtual cloud server, MySQL is the only database, and the site is code-based—no cPanel wizards. SSH root access is ready when we agree on the plan. Success is the server running steadily for 48 hours under simulated peak traffic without MySQL getting killed or the site slowing to a crawl.
Project ID: 40673853
204 proposals
Remote project
Active 3 days ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
204 freelancers are bidding on average $134 AUD for this job

With over a decade of experience in web development, we have encountered and effectively resolved numerous server overload issues like the one you're currently experiencing. In fact, server optimization is one of our core competencies, encompassing deep knowledge of various platforms including the standard LAMP stack your site operates on. We've not only managed to optimize PHP configurations such as FastCGI or PHP-FPM but also revamped entire hosting infrastructure when necessary. Our expertise extends to MySQL and PHP, the two culprits you've identified as prime suspects for your virtual cloud server malfunction. We're adept at pinpointing memory spikes and high CPU events with precision, modifying OOM scores to prioritize and safeguard key services such as MySQL, and verifying database settings for optimal performance. Ultimately, our mission is not just to fix your immediate problems but to foster long-term stability and growth for your website. This entails not only providing an effective debugging but also offering overlooked suggestions that may further enhance your site's performance. Our collaborative approach coupled with a research-driven mindset is sure to tackle even the most complex issues gracefully to deliver a more reliable digital-footprint for your bussiness. Choose us today for a high-quality, efficient fix that will save you from futur headaches while positioning your site for better scalability and sustainability!
$140 AUD in 7 days
9.4
9.4

Hello, CnEL India can help diagnose and stabilize your LAMP server with a structured, evidence-based approach rather than making blind configuration changes. Methodology: Baseline & Diagnosis: Review CPU/RAM usage, Apache/PHP processes, MySQL status, slow queries, logs, OOM events and running services to identify the actual memory/CPU bottleneck. Memory & MySQL Tuning: Analyze MySQL configuration, connection usage, buffers and queries, then safely tune resource consumption and OOM priorities so critical services remain stable. PHP Handler Migration: Prepare and test PHP-FPM/FastCGI configuration alongside the existing setup, then migrate carefully with rollback protection to minimize service interruption. Performance Testing: Monitor PHP workers, Apache, MySQL and system resources under controlled load and optimize based on measured results. Validation & Hardening: Verify application functionality, database stability and resource usage, followed by 48-hour monitoring under simulated peak traffic. Handover: Provide a concise report documenting changes, findings, rollback considerations and recommendations. We can begin with a server audit and proceed safely through each optimization stage.
$140 AUD in 15 days
9.0
9.0

Hi, I reviewed your LAMP server overload issue where MySQL is killed by OOM and Apache becomes unresponsive, and I will diagnose the memory spikes and 100% CPU events to pinpoint the root cause. I’ll retune or override the OOM score so MySQL stays alive under pressure, then verify MySQL settings like query cache and review for bottleneck queries. I’ll migrate the PHP handler from suPHP to PHP-FPM or FastCGI with zero downtime, keeping performance stable under peak traffic. I’ll deliver a short report of what changed and why, with clear follow-up recommendations. Let’s discuss here now.
$150 AUD in 7 days
8.4
8.4

Hello, As an experienced developer with a detailed understanding of server-side infrastructure and optimization, I can provide the precise rescue and hardening solutions your project requires. My extensive knowledge of not only PHP but also servers and databases will be crucial in diagnosing the precise causes of your server overload and memory spike issues, as well as implementing effective strategies to counter them. Migrating your site from suPHP to more efficient handers like PHP-FPM or FastCGI is not only within my skill set, it's a task I've accomplished seamlessly for my previous clients. My 15+ years hands-on experience developing scalable, secure products blended with my growing expertise in A.I automation makes me the ideal fit for dealing with complex, sensitive optimization needs. Your satisfaction is my top priority. In addition to solving current Overload issues, I will provide you with a comprehensive report documenting the changes made, their importance and any follow-up recommendations needed to ensure long-term stability and efficiency of your server system. Let's team up now and bring back stability to your virtual cloud server while revolutionizing your overall web experience! Thanks!
$180 AUD in 2 days
8.6
8.6

With a background in optimizing LAMP stacks and troubleshooting MySQL performance, I understand the urgency of stabilizing your product catalogue site on the virtual cloud server. My focus will be on diagnosing memory spikes, adjusting MySQL's OOM score, and transitioning to a more efficient PHP handler like PHP-FPM. One question: Are there any specific peak traffic times that should be considered during this migration and hardening process? Looking forward to collaborating on this critical rescue operation. Regards, Yogesh Kumar
$30 AUD in 9 days
8.4
8.4

Hi, Could you provide access to your server logs for a more accurate diagnosis? To tackle the issue, I will start by analyzing memory spikes and high CPU usage, then adjust the OOM score to prioritize MySQL. Next, I’ll migrate from suPHP to PHP-FPM, ensuring no downtime. I’ll also check your database settings to confirm that it isn’t the bottleneck. I have over 12+ years of experience with LAMP stacks, and I’m confident I can stabilize your site effectively. Please see our portfolio on this link : https://www.freelancer.com/u/webperfection123 Feel free to reach out to discuss the details or if you want to move forward. Best Regards, Priyanka
$140 AUD in 2 days
8.4
8.4

Hi, I can diagnose and stabilize your LAMP server, focusing on the memory spikes, 100% CPU events, MySQL OOM behavior, and PHP handler overhead. I’ll first analyze resource usage, MySQL processes/queries, Apache/PHP workload and logs to identify the actual bottleneck. Then I can safely tune the OOM configuration and migrate suPHP to PHP-FPM/FastCGI with minimal or zero downtime. I’ll also review MySQL configuration and caching, run controlled load tests, and monitor the server for the required 48-hour stability period. A concise report with all changes and recommendations will be provided. I’m comfortable working through SSH/root access and on production LAMP environments. Best regards, Muhammad Rizwan LA
$50 AUD in 1 day
8.2
8.2

Hello, I can see the real pain point here: the server isn’t just “slow” , it’s being pushed into a memory death spiral where MySQL gets sacrificed first. I’ve handled similar LAMP hardening jobs with PHP handler migrations, OOM tuning, and root-level troubleshooting, and I’d approach this by tracing the spike source, protecting MySQL from being the first victim, then moving suPHP to PHP-FPM/FastCGI with a safe rollout. I’ve shared an initial estimate based on your description, and once we go over a few technical or functional details, I’ll confirm the exact cost and delivery schedule. I’ll also review MySQL settings, confirm whether the issue is workload, config, or handler overhead, and provide a short change report with clear follow-up recommendations. Looking forward to your reply so we can finalize the exact plan. Would you like me to prioritize zero-downtime handler migration first, or do you want the root-cause memory/CPU diagnosis completed before any changes? Thanks, Asad
$75 AUD in 3 days
8.2
8.2

Protecting MySQL with an oom_score_adj is the right immediate safety net, but it treats the symptom — with prefork Apache and suPHP, each request forks its own PHP process, so under a traffic spike MaxRequestWorkers × per-process memory can exceed RAM regardless of which process the kernel picks off. I'd start by instrumenting before changing anything: capture per-process RSS over time, Apache's scoreboard, slow-query and process lists during a spike, so we know whether memory is going to PHP workers, MySQL buffers, or a specific unindexed catalogue query. Then set MySQL's oom_score_adj via a systemd drop-in so it survives restarts, migrate to PHP-FPM with mod_proxy_fcgi and a pool sized to actual available RAM — bounded workers mean load queues instead of the box dying — cutting over on a staged vhost so there's no downtime. On the DB side I'd tune innodb_buffer_pool_size against real RAM and index the slow queries; worth noting the query cache is gone in MySQL 8, so if you're on it that lever doesn't exist and the win comes from indexing plus a PHP object cache instead. You get a written report of every change and a 48-hour load-test soak before sign-off. Ready to start once SSH access is through.
$30 AUD in 1 day
7.9
7.9

OKAY I got the issue i will fix perefctly without any error -----------------Server Overload Fix & PHP Optimization I am sure i will achieve your given expectations by completing this project with high quality. I am highly proficient to work on this project. I am Passionate PHP/Full stack developer having rich experience with all the latest technologies with so many successful Tasks. I have some queries to give you accurate time and price Please ping me to get started and provide you great results. Thanks!!!
$150 AUD in 7 days
8.1
8.1

I’ll stabilize the LAMP server by first identifying what is driving the memory spikes and 100% CPU events, rather than applying blind configuration changes. With root SSH access, I’ll review journalctl, kernel OOM records, Apache/PHP process counts, MySQL memory usage, vmstat, disk I/O, and slow-query data during representative traffic. I’ll protect MySQL using an appropriate OOMScoreAdjust/systemd override, then validate that its buffer pool, connections, temporary tables, and query-cache settings fit the available virtual-server RAM. I’ll also check whether query cache is helping or creating contention and inspect slow queries if database activity is contributing to the load. For PHP, I’ll stage PHP-FPM behind Apache using the suitable PHP version and Unix socket, tune worker limits to prevent memory exhaustion, verify file ownership and permissions, and switch with graceful Apache/PHP reloads to avoid downtime. I’ll keep a rollback configuration ready and confirm application, catalogue, and database behavior after the migration. Finally, I’ll run simulated peak traffic, monitor CPU, RAM, swap, MySQL survival, response times, and Apache errors for the requested 48-hour stability period. I’ll provide a concise report covering every change, the reason for it, observed results, and practical follow-up recommendations. Muhammad Saad
$200 AUD in 3 days
7.8
7.8

Hi I can troubleshoot the memory spikes and CPU saturation at the server level, identify the actual processes or queries driving the load, and harden the LAMP stack accordingly. I’ll safely adjust MySQL’s OOM protection, migrate from suPHP to PHP-FPM/FastCGI with minimal disruption, review MySQL configuration and caching, then run simulated peak-load testing. You’ll receive a concise change report and follow-up recommendations. I’m ready to work through the SSH access and stabilise the server. Thanks
$135 AUD in 3 days
8.2
8.2

I understand the urgency and impact of your ongoing server overload issues and I'm confident that my comprehensive skill set makes me an ideal fit for this task. Over the last 12+ years, I have diligently honed my expertise in not just MySQL and PHP but also in troubleshooting and web hosting. Having designed, optimized, and maintained numerous complex websites over the years, I've dealt with various database and server performance issues - precisely what is needed for your project. Furthermore, my experience extends beyond just resolving issues to optimizing overall performance. I have a strong background in website speed optimization, malware removal, and making necessary design/code adjustments to keep websites running smoothly. This encompasses migrating sites from one environment to another with zero downtime, much like the challenge at hand. Additionally, my automation skills could be an asset post-project as well. With my chatbot setup, integration and other automation abilities, I can create solutions that will monitor your site's performance continuously, alerting you to any potential issues before they become detrimental. Hiring me will ensure not only a successful fix for your immediate problem but also a long-term efficient performance for your server and site. Let's get started!
$140 AUD in 7 days
7.7
7.7

Hello, I have 10 years of experience in troubleshooting and optimizing server performance. I can diagnose the causes of memory spikes and CPU overload on your site. I will adjust the OOM score to keep MySQL running smoothly. I will migrate your site to PHP-FPM or FastCGI without downtime. I will optimize MySQL settings and ensure there are no bottlenecks. I will provide you with a report on changes made and recommendations. Regards, VishnuLal NB*
$100 AUD in 1 day
7.8
7.8

Hello, I have more than 10 years of experience handlings servers and php websites, I have read your requirements and I can fulfil them. I can manage your server and make it running properly without any crashes. I am available to start the work immediately on this. Regards Avinash
$75 AUD in 1 day
7.6
7.6

Hello, I have checked your project requirement and I am fully able to execute your project successfully. ➔ Please inbox me So we can have quick discussion and proceed further. ➔ Available to get started immediately. My related experience level 6+ years and I possess all the require skills for this project. I will also share my work samples related to your job, please inbox me. Awaiting your reply. Regards Kuldeepak
$250 AUD in 3 days
7.6
7.6

With over a decade of experience in web development and server management, navigating the intricate world of virtual cloud servers and LAMP stacks is second nature to me. Your project of fixing server overload and optimizing PHP is right up my alley. I've encountered similar issues in the past and have not only successfully resolved them but also implemented prevention measures to ensure long-term stability. My first step is thorough diagnosis because understanding the root cause is pivotal. Whether it's retuning the OOM score or migratіng to a more efficient handler like PHP-FPM or FastCGI, I have hands-on experience with these tasks. I meticulously test every change before executing it to minimize downtime. Additionally, verifying database settings and query cache to identify bottlenecks is something I do routinely. At the culmination of this project, you won't just have a crashed-free server for forty-eight hours; you'll receive an exhaustive report of all changes, their rationale, and any additional recommendations for future-proofing your site's performance. It would be a pleasure to employ my skills in Apache, Linux, MySQL, PHP as well as my troubleshooting acumen to optimize your server, alleviate your crashes and deliver unrivaled efficiency for your site.
$120 AUD in 2 days
7.6
7.6

Hi, I’ve read the failure pattern closely: OOM-killer taking down MySQL, Apache stalling, and suPHP likely wasting resources. I can diagnose the memory and CPU spikes, harden the MySQL survival behavior, and migrate the stack to PHP-FPM or FastCGI with minimal disruption. I work on PHP and MySQL based LAMP environments, including production troubleshooting, handler migration, query and config review, and Web Hosting level server fixes over SSH root access. I’ll isolate the spike source, tune the service priorities safely, verify whether MySQL settings or queries are contributing, and deliver a short report with exactly what changed and why. I can begin after access is shared and complete the rescue plus validation within 3 days, with the 48-hour stability test plan clearly defined. Before I touch the stack, which PHP version and Linux distro are currently running this LAMP server? Best regards, KANIKA
$180 AUD in 3 days
6.9
6.9

Hi there, Your LAMP box is hitting OOM because suPHP spawns a new process per request and MySQL's oom_score_adj makes it the first target — I'll stabilise both in one session. What I'll do: ✅ Diagnose memory/CPU spikes with pidstat, smem and MySQL slow-log analysis, then harden /proc/<mysqld-pid>/oom_score_adj and add a systemd drop-in so it survives reboots ✅ Migrate the vhost from suPHP to PHP-FPM (event MPM + proxy_fcgi) with a pre-warmed pool, graceful Apache reload and zero-downtime cut-over ✅ Tune innodb_buffer_pool_size, query_cache_type=OFF, and max_connections to match RAM; deliver a one-page runbook with before/after metrics ✅ Snapshot the VM and test the new stack under siege(1) load before handing back ✅ Linux performance tuning (vmstat, perf, eBPF) ✅ Apache event MPM & PHP-FPM pool sizing ✅ MySQL 8/InnoDB memory architecture ✅ Systemd hardening & OOM-score management ✅ Zero-downtime migration patterns ✅ Microsoft® Certified: MCSA | MCSE | MCT ✅ 300+ projects delivered, 280+ five-star reviews Why me: 24/7 availability and unlimited revisions until you're satisfied. One question: any existing monitoring (Zabbix, Prometheus, CloudWatch) I should hook the new metrics into? I'll have this stable for 115 AUD within 1 day and can start the moment you approve.
$115 AUD in 1 day
6.9
6.9

Hi, I can handle this server rescue and hardening task. I’ll first diagnose the memory and CPU spikes using system logs, process monitoring, Apache/PHP/MySQL metrics, and slow queries. Then I can optimize the PHP handler by moving from suPHP to PHP-FPM or another suitable setup, review MySQL configuration, and address OOM behavior carefully without masking the underlying memory issue. I’ll also test the site after the changes and provide a short report covering the root cause, changes made, and recommendations. A few quick questions: * Which Linux distribution and version is the server running? * What are the server specifications (RAM, CPU, PHP and MySQL versions)? * Can you provide SSH root access and any recent OOM/kernel logs? Thanks, Saju
$60 AUD in 7 days
7.0
7.0

Sydney, Australia
Payment method verified
Member since May 30, 2016
$1500-3000 AUD
$30-250 AUD
$250-750 USD
$10-30 AUD
$30-250 AUD
₹750-1250 INR / hour
₹600-1500 INR
$30-250 USD
₹1500-12500 INR
₹12500-37500 INR
₹1500-12500 INR
$250-750 AUD
€100-500 EUR
₹150000-250000 INR
₹12500-37500 INR
$120-180 USD
$2-8 AUD / hour
₹12500-37500 INR
$30-250 USD
₹12500-37500 INR
$250-750 USD
€30-250 EUR
$10-30 USD
₹3500-4000 INR / hour
₹600-1500 INR