
Closed
Posted
Paid on delivery
My website is experiencing slow query performance due to its heavy traffic and substantial data load. - Main Issue: The primary problem I'm facing with my MySQL database is slow query performance. This is affecting user experience and overall site functionality. The sites are built in Joomla so default joomla / components queries should not be touched as the changes may be overwritten by upgrades. The task is to optimise [login to view URL] and if necessary identify the slow queries causing the latency and optimise them. Ideal Skills and Experience: - Proficient in MySQL 8, with a deep understanding of its optimization techniques. - Experience handling large-scale websites with complex databases. - Strong problem-solving skills to identify slow queries and implement effective solutions. - Ability to enhance server performance and reduce load times. This is a live site with thousands of visitors - No access will be provided to the server. i'll send you the [login to view URL] site to optimise and i'll upload it.
Project ID: 38850858
40 proposals
Remote project
Active 1 yr ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
40 freelancers are bidding on average $42 USD for this job

As an experienced full-stack developer with a specialization in front-end and back-end technologies including MySQL and PHP, I am both qualified and equipped to optimize your MySQL 8 database for high-traffic conditions. Over my 14-year career, I've successfully handled similar projects where slow query performance had become a major bottleneck – a problem we can address here as well. With Joomla sites your concern of database changes potentially being reverted by upgrades is valid but rest assured, I understand the importance of avoiding core file modifications in such situations. Drawing on my knowledge of the platform, I will identify and optimize only those specific queries that need it while safeguarding the existing functionalities without compromising Joomla's integrity. Moreover, with a strong command on server optimization, I'll ensure not just improved query performances but also reduced load times and enhanced server responses for an optimized overall user experience – critical for any website to succeed in today's ever-impatient digital realm. For me, client satisfaction is paramount and all with quick turnarounds - so let's make your site faster without introducing any breaking changes whatsoever!
$38 USD in 7 days
8.3
8.3

Hello. I would like to help you with Mysql 8 optimization issue. I have experience. Please read my feedbacks. Thank you.
$30 USD in 1 day
7.5
7.5

Hello, I have 10 years of experience in MySQL optimization and database management. I can help improve your site’s performance by optimizing the MySQL configuration and identifying slow queries. I will focus on enhancing server performance without altering default Joomla queries. With my expertise, I ensure effective solutions for your high-traffic website needs. Regards, VishnuLal NB
$50 USD in 2 days
7.4
7.4

As a Top-Rated Full Stack Developer with an extensive history in Mobile App Development and Web Design/Development, I have successfully completed over 550 projects that align with your requirements. With almost a decade of experience behind me, I'm well-versed in optimizing database performance and familiar with large-scale websites, particularly those using MySQL 8 - the exact system you need help with. In addition to my broad experience, I excel in problem-solving and have the eyes to identify and fine-tune even the most complex slow queries effectively. My deep understanding of MySQL's optimization techniques combined with my analytical skills make me an ideal candidate for this task. I assure you 100% work satisfaction, maintaining a quality of service through greater server performance to reduce load times - absolutely paramount for a site receiving thousands of visitors! Furthermore, being proficient in multiple technologies including React JS, Node JS and PHP, I'm well-equipped to optimize your site while ensuring that default Joomla queries remain untouched to prevent future complications. I understand the importance of timely results for both urgent and long-term projects, which is why I guarantee delivering swift and accurate solutions. Let me use my 9+ years of experience to enhance your site's performance!
$38 USD in 7 days
5.1
5.1

Hi Richard H.. No problem this for me. I am very excited with your project because I have completed similar project recently. The skills required for your project ---MySQL 8 Optimization for High-traffic Website--- are my main specialty. I can handle this perfectly and have abundent experiences. Please confirm that I am one of the best fits for you and drop me a message for further discussion. Thanks and Best Regards.
$45 USD in 2 days
3.3
3.3

Hi, Wishing you a good day. Have go throw your requirement formanaging traffic on webiste. I can complete this project with my experties in website development using PHP, Laravel and Codeignitor and can complete in less than a week. Wish to connect with you soon and discuss more. Thanks, Manoj
$38 USD in 7 days
3.2
3.2

As an expert in MySQL with a myriad of successful website optimizations under my belt, I am equipped to tackle the issue at hand promptly and effectively. During my extensive tenure, I have optimized large-scale and highly-traffic websites like yours while ensuring the integrity of your existing infrastructure. My deep understanding of MySQL 8 coupled with my problem-solving aptitude is primed to not only identify slow queries, but effectively resolve them without ever touching any default Joomla components that are prone to overwritten. Being within top 5K members on this platform and amongst the top 4% of freelancers, alone speaks volumes about how valuable my expertise is held. I have worked with over 150+ companies, honing my skills in various domains including DATABASE SQL which primes me for this job. Moreover, I believe in quality work and customer satisfaction above all else which aligns perfectly with your project's expectations. With guarantee of competitive rates, regular updates and extended post-delivery support - you won't just get your job done, you'll get it done the right way with careful attention paid to each detail
$38 USD in 7 days
2.7
2.7

Hey Richard H., I just finished reading the job description and I see you are looking for someone experienced in MySQL, PHP and Database Administration. This is something I can do. Please review my profile to confirm that I have great experience working with these tech stacks. While I have few questions: 1. These are all the requirements? If not, Please share more detailed requirements. 2. Do you currently have anything done for the job or it has to be done from scratch? 3. What is the timeline to get this done? Why Choose Me? 1. I have done more than 250 major projects. 2. I have not received a single bad feedback since the last 5-6 years. 3. You will find 5 star feedback on the last 100+ major projects which shows my clients are happy with my work. Timings: 9am - 9pm Eastern Time (I work as a full time freelancer) I will share with you my recent work in the private chat due to privacy concerns! Please start the chat to discuss it further. Regards, Haroonz6
$25 USD in 3 days
2.9
2.9

I am a Senior Linux Consultant with over 20 years of experience. I have managed hundreds of servers, and particularly I have a project with millions of rows in a MySQL database. I understand your concern about not providing access to the server, but this makes MySQL tuning practically unfeasible, as it requires a thorough analysis of what exactly causes the slowness, whether it really is just tuning, poorly structured queries or even a lack of hardware resources. I can help you, for this I need SSH acceptance and access to the server.
$45 USD in 2 days
1.2
1.2

?Hello, there I am glad to have a the opportunity to contribute with your business. As an experienced web developer, I am confident in this project. Above all, I would like to meet with you and we can discuss this in more detail. I am new one at this service and have no experience and past work just in this service, which is why I am offering a low price. However, I am a experienced developer with 5+ years and promise to provide high quality services based on my past experience, and my skill is not related to the budget. If you are looking for a programmer who can complete on this project, please reach out me. It would be thanks for me if you could take a look at my proposal and also although you don't choose me, I hope you to meet another talent and experienced programmer to complete this proejct perfectly. I reaffirm my commitment to providing you with a clean, polished and high-quality service. Best regards Toru Ichikawa
$25 USD in 7 days
0.0
0.0

Maidstone, United Kingdom
Payment method verified
Member since Mar 1, 2008
$30-250 USD
$10-100 USD
$10-30 USD
$10-15 USD
$10-50 USD
₹1500-12500 INR
₹12500-37500 INR
$250-750 USD
$10-30 USD
€30-250 EUR
$2-8 USD / hour
₹600-1500 INR
$10-30 USD
$750-1500 USD
$250-750 AUD
£750-1500 GBP
$115-200 HKD / hour
$15-25 USD / hour
₹1500-12500 INR
$250-750 USD
₹37500-75000 INR
₹12500-37500 INR
$750-1500 USD
$1500-3000 USD
$10-30 USD