You will get MySQL Database Optimization for Speed, Stability & Scalability
Project details
Is your MySQL database slowing down your website or application? Are you facing performance bottlenecks, high server loads, or long query times?
I specialize in MySQL performance optimization and can help you dramatically improve database efficiency by identifying and resolving performance issues. Whether you're running a WordPress site, a Laravel application, or a custom-built platform, I’ll help ensure your database is lean, fast, and scalable.
What This Project Includes:
✅ In-depth analysis of your current database performance
✅ Identification of slow or inefficient queries using tools like EXPLAIN, Slow Query Log, and more
✅ Index optimization to speed up query execution
✅ Schema review and normalization advice (if needed)
✅ Configuration tuning of MySQL settings (my.cnf) for your environment
✅ Query refactoring for better performance
✅ Recommendations or implementation of caching (e.g., query caching, Redis, etc.)
✅ Final performance testing and report
I specialize in MySQL performance optimization and can help you dramatically improve database efficiency by identifying and resolving performance issues. Whether you're running a WordPress site, a Laravel application, or a custom-built platform, I’ll help ensure your database is lean, fast, and scalable.
What This Project Includes:
✅ In-depth analysis of your current database performance
✅ Identification of slow or inefficient queries using tools like EXPLAIN, Slow Query Log, and more
✅ Index optimization to speed up query execution
✅ Schema review and normalization advice (if needed)
✅ Configuration tuning of MySQL settings (my.cnf) for your environment
✅ Query refactoring for better performance
✅ Recommendations or implementation of caching (e.g., query caching, Redis, etc.)
✅ Final performance testing and report
Database Type
MySQL, MongoDBWhat's included $100
These options are included with the project scope.
$100
- Delivery Time 3 days
- Number of Revisions Unlimited
4 reviews
(3)
(1)
(0)
(0)
(0)
This project doesn't have any reviews.
RS
Rhys S.
Sep 17, 2025
Site Audit and Optimization
5 stars all round from me. Pierce is the best Wordpress Maintenance guy I’ve ever come across on UpWork, I strongly recommend him for all your Wordpress needs. BRILLIANT
AR
Alexandra R.
Jul 11, 2023
Website Build
Pierce came recommended by a friend who had successfully worked with him on her company's site. He very clearly understood our brief from the beginning and was able to execute. Very few further revisions were needed and we are very satisfied with the professionalism of our website. Easy to communicate with.
VP
Vanya P.
Sep 1, 2022
Migrate a domain name to Wordpress and set up a template
Pierce is a real pro. Of course he did the work way better than expected - with speed, responsiveness, and quality. But more importantly he helped us think through what it was that we actually needed - so that our website would run smoothly and efficiently - and then did his magic setting us up with all sorts of plugins and details we wouldn't have thought of asking about. Highly recommended - especially for clients who might not be technical and may need a thought-partner in figuring out the best solution. Looking forward to working with him again.
IN
Imtiaz N.
Aug 29, 2022
Looking for someone in Ireland to register an .ie domain name on my behalf
Pierce was absolutely fantastic. He completed the task quickly and efficiently. He is extremely helpful, has great communication and answered all the questions I had. He went above and beyond what was required. I will work with him again. Thank you!
About Pierce
WordPress Developer | Wordpress Designer | Website Designer
56%
Job Success
Kenmare, Ireland - 7:12 am local time
✅ Profile Description:
Hi, I’m Pierce O’Neill, a professional WordPress Developer and Designer with over 10 years of experience creating clean, fast, and responsive websites for businesses of all sizes.
I specialize in custom WordPress solutions—from full site builds and redesigns to troubleshooting tricky bugs, optimizing performance, and maintaining your site long-term.
Whether you're looking for a fresh landing page, a WooCommerce shop, or need to fix a plugin/theme issue, I’m here to help.
🔧 My Expertise Includes:
WordPress Custom Theme Development
Elementor & Page Builder Design (Divi, WPBakery, etc.)
Theme & Plugin Troubleshooting
Mobile-Friendly Design
Speed Optimization (Core Web Vitals)
WooCommerce Setup & Customization
Child Themes & Custom PHP/CSS Edits
Site Migrations, Backups & Security Hardening
Ongoing Maintenance & Support
💡 Why Work With Me?
10+ years of hands-on WordPress development experience
Clear, reliable communication
Ireland-based (GMT+1), fluent in English
Detail-oriented with fast turnaround times
I treat every site like it’s my own
📌 𝗞𝗲𝘆𝘄𝗼𝗿𝗱𝘀:
WordPress Developer, WooCommerce Expert, Custom WordPress Themes, WordPress Plugin Customization, WordPress Performance Optimization, WordPress Security Specialist, and API Integration Expert, Figma to WordPress, WordPress Migration, WordPress Maintenance, WooCommerce Customization, WordPress Theme Customization, E-commerce Solutions, WordPress Speed Optimization, ACF Pro, ACF, ACF Field Group, ACF Option page
Steps for completing your project
After purchasing the project, send requirements so Pierce can start the project.
Delivery time starts when Pierce receives requirements from you.
Pierce works on your project following the steps below.
Revisions may occur after the delivery date.
Initial Assessment & Access Setup
Review the client's goals, challenges, and server specs Set up secure access (SSH, MySQL, or control panel) Take a full database backup before any changes
Performance Analysis
Enable and review the Slow Query Log Use tools like EXPLAIN, SHOW STATUS, and MySQLTuner to analyze performance Identify resource-heavy queries, inefficient indexes, and bottlenecks