I will optimize your mysql or mariadb database and fix slow queries
About this Gig
Is your MySQL or MariaDB database slowing down your app, eating CPU or timing out under load?
I am a senior DBA who runs production databases in a regulated financial institution, where slow queries and downtime are not an option. I bring the same discipline to your database.
What I do:
- Analyze the slow query log and performance_schema to find the queries that really cost you
- Read EXPLAIN plans and rewrite or index the worst offenders
- Tune my.cnf (InnoDB buffer pool, redo log, connections, temp tables) for your hardware
- Find unused, duplicate and missing indexes
- Check table bloat, fragmentation and statistics
What you get:
- A written report with findings ranked by impact
- Before/after timings for every query I change
- Ready-to-run SQL and config changes, applied by me or by your team
Works with MySQL 5.7, 8.x, MariaDB, Amazon RDS/Aurora and Google Cloud SQL.
Please message me before ordering so we can confirm access and scope. English, Spanish or Catalan.
Database type:
Centralized database
•
Relational database
Platform:
MariaDB
•
MySQL
Expertise:
SQL
•
Performance
•
Query optimization
My Portfolio
Other Databases Services I Offer
FAQ
Do you need root access to my server?
o. A database user with read access to performance_schema and the slow query log is enough for the Basic package. To apply changes I need a user with the right privileges, or your team applies the scripts I deliver.
Will you change anything in production without asking?
Never. Every change is listed in the report and applied only after you approve it, ideally on staging first.
Do you sign an NDA?
yes, I am happy to sign your NDA before receiving access.
Do you work with managed databases like RDS or Cloud SQL?
Yes. I tune parameter groups instead of my.cnf.

