MySQL Optimization & Server Performance Tuning - High CPU Usage Issue -- 2

₹2000-7000 INR

Closed

Posted 4 months ago

₹2000-7000 INR

Paid on delivery

I am looking for a skilled and experienced server administrator with expertise in MySQL optimization and server performance tuning to resolve a critical issue with my website ijsrem.com. The website is experiencing intermittent downtime (30-50 minutes daily), and the issue appears to be caused by MySQL's excessive CPU usage, which is consuming up to 278.2% CPU. This high CPU usage is resulting in significant performance degradation, especially during peak traffic times. The issue as reported by the hosting provider: The server is consuming 278.2% CPU due to the MySQL process (/usr/sbin/mysqld), which indicates that the database is using excessive resources. The hosting provider has informed me that the CPU usage can exceed 100% on multi-core systems (each 100% represents one core utilization). The issue causes continuous downtime, impacting the user experience and website availability. Key Responsibilities: Analyze the MySQL database performance and identify the root cause of excessive CPU usage. Review and optimize the MySQL configuration files (such as [login to view URL]). Investigate and optimize SQL queries that may be inefficient or resource-hungry. Check for potential database locking issues, excessive connections, or unnecessary background processes. Tune the server for improved performance (index optimization, query caching, etc.). Provide recommendations for scaling and improving the overall server health, particularly for handling higher traffic loads. Ensure that the server is properly configured for resource management (e.g., memory usage, thread handling, etc.). Test and validate that the changes result in reduced CPU usage and enhanced website uptime. Requirements: Proven experience in MySQL optimization and performance tuning on Linux servers. Strong knowledge of server resource management and database performance metrics. Experience in diagnosing and resolving MySQL-related performance issues such as high CPU usage, slow queries, and resource hogging. Familiarity with server logs and diagnostic tools to identify bottlenecks. Ability to work with hosting providers and system administrators for server-side troubleshooting. Excellent communication skills for providing updates and recommendations. NOTE: Please find the attached files of error and log files for your reference.

Project ID: 39223709

About the project

20 proposals

Remote project

Active 3 mos ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

20 freelancers are bidding on average ₹10,457 INR for this job

@vili1977

Hello. I would like to help you with optimization apache/php/mysql/memory an fix ddos attacks issue. I have experience. Please read my feedbacks. Thank you.

₹3,000 INR in 1 day

4.9

(1293 reviews)

7.9

@kuldeepvk

Hi, I have 10 years of experience and knowledge as system administrator setup and management of different Linux Web Hosting Servers, AWS servers,Cloud Servers, Server Monitoring, Server Security, Server Optimisation, Mailing Servers, Email Marketing, SSL, DNS, Apache, Nginx, etc with Cpanel, Plesk, Virtualmin or other panels. Services such as cPanel/WHM, Plesk, Virtualmin LAMP Stack, Tomcat, MySQL/MariaDB, Zimbra, Postfix mail server, Mailenable, smarter mail, MS SQL,AWS , etc. Please discuss to start. Thank you

₹4,500 INR in 1 day

4.9

(741 reviews)

7.6

@metaexcel

hello sir, are you sure there is no suspcious activities or malicious activities in your server? how long before you got tihs issue? I need to discuss more. I am ready to start. Thanks

₹8,500 INR in 7 days

5.0

(308 reviews)

7.1

@skynatstech

Hello, We have read your project and would be happy to help you with the task of optimizing the mysql server. We are a professional server-cloud infrastructure management company with over 10 years of experience. Currently, we manage less than 400 servers, including cloud instances, dedicated boxes, and VPS boxes. We would be delighted to speak more about the project over chat and work on a solution. Do pings in chat so that you can get to know us better. Regards Skynats Team

₹5,500 INR in 1 day

5.0

(450 reviews)

7.1

@bitwiz

Hi, I have handled various fullstack development projects involving mysql. I have written various database related routines. I can handle this task to help you figure out the issues in the db.

₹4,500 INR in 7 days

5.0

(38 reviews)

5.7

@hotranan

Hi, I can help much in your project! I'm senior developer, I can work on mobile apps development for Android/iOS and REST api. I'm an experienced full-stack web developer specializing in Linux, PHP, Flutter, Java, MYSQL, Oracle, WordPress, Laravel, CAKEPHP, MAGENTO, CodeIgniter, Django/Python, Opencart, Prestashop, Shopify, WIX, AWS, cloudflare, VPS, WHM/cPanel.

₹45,000 INR in 7 days

4.9

(8 reviews)

5.1

@bhupen2606

Hello, I have extensive experience in MySQL with expertise in performance tuning. I have understood your requirements and can help improve performance and stability of the application. I'll review the configuration and check the details of queries traffic during peak load. A holistic solution can be formulated based on observations. There can be some queries that are inefficient and in turn impact others as well. I can review the queries, the joins and index usage (or lack of it). Lets connect over chat and i can start immediately. There is no obligation till you see some improvements. Thanks,

₹7,000 INR in 7 days

5.0

(43 reviews)

4.7

@gara123

Hello, I’m an IT expert with over 20 years of experience in the industry. I hold certifications as a Cisco Certified Networking Professional (300-100 and 300-115), Linux Certified Professional (LPI 101, 102, 103), Red Hat Certified System Administrator, VMware Certified Professional (versions 4, 5, and 5.5), as well as being a Microsoft System Administrator/Engineer from 2003 to 2019.

₹5,500 INR in 1 day

5.0

(7 reviews)

3.1

@bizmanas

I have expertise in sql performance tuning. My name is Debashree and I'd love to assist in resolving this pressing issue on your website. With over 18 years of experience in database development and web development using SQL Server, MYSQL, PostgreSQL, Oracle and ASP.Net, C#, I have a deep familiarity with SQL optimization and performance tuning. I believe my comprehensive knowledge of server resource management and diagnostic strategies could be put to effective use to address your high CPU usage concern. Throughout my career, I've successfully solved similar issues for multiple large-scale IT enterprises across various industries. This includes diagnosing and resolving high CPU usage problems, slow queries, resource hogging, and general database optimizations. My in-depth understanding of SQL Server query performance tuning, indexing optimization, caching techniques combined with proficiency in tools like Power BI and SSRS make me highly capable of making data-driven decisions to improve your server's health and user experience.

₹75,000 INR in 5 days

5.0

(5 reviews)

2.9

@Manish502

Hello Dear, I have 5 years of experience in server administration and Devops. I have managed shared servers, VPS servers, dedicated servers, GoDaddy hosting, AWS Cloud Server, Digital Ocean Cloud Server, Google Cloud, DNS, domains, SSL certificates, Plesk Panel, Red Hat, CentOS, Ubuntu, and email servers like Zimbra, Exim, Postfix, and Dovecot. I am proficient in backup solutions such as JetBackup, Acronis, and custom backup scripts. As a Microsoft and AWS-certified engineer, I have extensive experience managing EC2, Load Balancer, RDS, Route53, S3 Bucket, LightSail, SES, WorkMail setup, SES Snapshot, Volume, Auto Scaling, Stress Testing, AMI, IAM Role, SSL installation, dedicated servers, shared servers, WordPress, Django, PHP, MySQL, and LAMP servers. I have successfully migrated thousands of websites from shared hosting to AWS Cloud servers. My skills include CI/CD, GitHub Actions, Pipeline, Jenkins, autodeployment, DNS, domain management, website migration, SSL installation for domains and subdomains, and installation of LAMP, Node.js, NPM, Java, Ruby on Rails, WordPress, PHP, phpMyAdmin, MySQL, and Windows software. I’d love to work with you and bring my expertise to ensure a smooth and successful migration for your travel website. Regards,

₹3,500 INR in 7 days

5.0

(5 reviews)

2.6

@Visharaa2024

As a seasoned server administrator, I can address your immediate needs - fixing the intermittent downtime and reducing high CPU usage on your website. I have over 8 years of experience across multiple platforms notably in MySQL Optimization for Linux servers which will be essential in investigating, identifying, and mitigating the root causes for the excessive resource consumption. My knowledge base extends to tuning queries, managing database resources, dealing with locking issues all aimed at delivering optimal performance and maximum uptime. Apart from troubleshooting and performance tweaking, my strengths lie in my resourcefulness when confronted with fresh challenges., particularly in scaling up servers to handle higher traffic loads. By examining and revamping your current server configuration files, and implementing resource management strategies we can ensure an optimized use of memory allocation, improved thread handling resulting in a more robust system better equipped to deal with your web traffic. Furthermore, my transparent approach guarantees regular updates throughout the process while recommending improvements that extend beyond immediate fixes. Don't be swayed by my mobile application development background – it's the varied expertise that makes me versatile; capable to adapt swiftly and effectively to your unique challenges. Let us work together for a stable, well-functioning site that enhances user experience!

₹4,500 INR in 7 days

5.0

(2 reviews)

2.0

@sranjeet49311

Based on your requirements, I propose conducting a comprehensive MySQL performance audit and optimization plan. This will include analyzing query performance, tuning MySQL configurations, and identifying bottlenecks using diagnostic tools like mysqltuner, pt-query-digest, and server logs. I will also provide detailed recommendations to improve database efficiency, reduce CPU usage, and optimize resource allocation. Additionally, I'll collaborate with your hosting provider or system administrators for server-side troubleshooting and ensure clear communication throughout the process. Please share the attached files for a more precise analysis.

₹5,100 INR in 1 day

0.0

(0 reviews)

0.0

@jitendar1989b

Hello Sir, I will optimize your databases server and give proper solution of CPU spike I resolved such type of issue in my past hosting company, kindly chat me so we can start work on it immediately. I have good working experience with hosting and Server support. Thanks

₹4,500 INR in 7 days

0.0

(0 reviews)

0.0

@neetus703

Dear sir/madam, I am offering my services on short notice. Relevant Skills and Experience Please consider me and give me a chance to impress you by my quality services

₹4,500 INR in 7 days