MySQL / MariaDB Query Optimization Project
Budget: £20 – £250 GBP
**Description:**
We are in search of a highly skilled developer with a deep understanding of optimizing MySQL MariaDB queries.
**Project Scope:**
- The developer will conduct a thorough analysis of all database queries, with a particular focus on identifying and addressing slow queries.
- This analysis will encompass both normal and peak usage periods, as our server currently handles approximately 40,000 queries per second. During peak hours, the server experiences high load averages and CPU usage.
- The developer should possess the expertise to access slow queries via SSH and, if necessary, utilize tools like Percona for in-depth analysis.
**Deliverables:**
The developer will provide a comprehensive report with the following details:
1. Identification of slow queries: A list of queries that are causing performance bottlenecks, including their frequency and impact on server performance.
2. Detailed optimization solutions: A step-by-step guide on how to optimize each identified query. This should cover indexing, query structure improvements, and any other relevant optimizations.
3. Performance benchmarks: Before-and-after performance metrics to demonstrate the effectiveness of the optimizations.
**Requirements:**
- Proficiency in MySQL and MariaDB query optimization techniques.
- Strong analytical skills to pinpoint performance bottlenecks accurately.
- Experience with SSH access and proficiency in using tools like Percona for query analysis.
- Excellent communication skills to convey optimization strategies clearly.
**Timeline:**
Please provide an estimated timeline for completing this project.
If you have any specific qualifications, experience levels, or additional information you'd like to include, feel free to incorporate them into the description. This refined description should help attract qualified candidates for your project.
We are in search of a highly skilled developer with a deep understanding of optimizing MySQL MariaDB queries.
**Project Scope:**
- The developer will conduct a thorough analysis of all database queries, with a particular focus on identifying and addressing slow queries.
- This analysis will encompass both normal and peak usage periods, as our server currently handles approximately 40,000 queries per second. During peak hours, the server experiences high load averages and CPU usage.
- The developer should possess the expertise to access slow queries via SSH and, if necessary, utilize tools like Percona for in-depth analysis.
**Deliverables:**
The developer will provide a comprehensive report with the following details:
1. Identification of slow queries: A list of queries that are causing performance bottlenecks, including their frequency and impact on server performance.
2. Detailed optimization solutions: A step-by-step guide on how to optimize each identified query. This should cover indexing, query structure improvements, and any other relevant optimizations.
3. Performance benchmarks: Before-and-after performance metrics to demonstrate the effectiveness of the optimizations.
**Requirements:**
- Proficiency in MySQL and MariaDB query optimization techniques.
- Strong analytical skills to pinpoint performance bottlenecks accurately.
- Experience with SSH access and proficiency in using tools like Percona for query analysis.
- Excellent communication skills to convey optimization strategies clearly.
**Timeline:**
Please provide an estimated timeline for completing this project.
If you have any specific qualifications, experience levels, or additional information you'd like to include, feel free to incorporate them into the description. This refined description should help attract qualified candidates for your project.