I will fix mysql slow queries and replication issues

China

I speak English

MySQL and Redis DBA, SQL Optimization and Data Recovery

Senior DBA with over 10 years in MySQL, Redis and Oracle. I diagnose slow SQL, replication lag, locking and memory issues, and plan database recoveries and changes. MySQL: EXPLAIN/index tuning, GTID ...
About this Gig

Slow MySQL queries, replication lag or recurring database errors? I am a DBA with over 10 years of experience.


I can help with:

- Slow SQL, EXPLAIN plans, index design, joins and deep pagination.

- Lock waits, deadlocks, long transactions, high CPU and memory use.

- GTID replication, replica errors, lag and consistency checks.

- Performance Schema analysis and practical monitoring improvements.


Basic delivers diagnosis of one agreed issue and a prioritized action plan. Standard covers one targeted fix or up to three agreed SQL queries on one instance. Premium covers one defined performance or replication project, up to three nodes.


You receive findings, agreed changes where included, validation results and handover notes. Production changes require an agreed backup, rollback and maintenance plan.


Please message me before ordering with the MySQL version, topology, symptoms and goal. Performance depends on the workload and environment. Recovery, major migrations and ongoing support are scoped separately.

Expertise:

Administrator

•

Backup & recovery

Database type:

Relational database