Open Lance

Data & Analytics

Hire MySQL Experts for Query and Schema Tuning

MySQL experts tune and maintain MySQL databases behind web apps, WordPress sites and e-commerce stores.

Post a job How hiring works

The role

What MySQL experts do

A MySQL specialist analyses slow query logs, adds indexes, designs schemas, configures replication and backups, and upgrades versions. For WordPress and WooCommerce, they often clean up bloated tables and plugin queries.

Typical deliverables

  • Slow query analysis and indexing
  • Schema design and cleanup
  • Backups and replication
  • Version upgrades
  • Database tuning for WordPress or WooCommerce

Tools you will see

  • MySQL
  • MariaDB
  • Slow query log
  • EXPLAIN
  • Percona Toolkit
  • Amazon RDS

Choosing

How to choose MySQL experts

What to look for

  • Evidence of measurable query improvements.
  • Safe approaches to schema changes on live tables.
  • Tested backup and restore plans.
  • Experience with your application platform.

Questions to ask

  1. 1How would you identify slow queries?
  2. 2How do you add indexes without locking the site?
  3. 3How are backups tested?
  4. 4What would change in upgrading our MySQL version?

Planning

Before you post the job

Test first

Try changes on a copy of the database before production.

What drives cost

Database size, traffic, replication and upgrade needs.

Hiring on Open Lance

  • Posting a job and reviewing proposals are free.
  • Each milestone is funded into escrow before work starts and paid when you approve it.
  • Hire fixed-price, hourly, as a monthly Dedicated Hire, or buy a packaged Drop-In.
  • Client fees are shown before you pay and added on top of the work.

How escrow and approval work · Pricing

FAQ

Questions about hiring MySQL experts

MySQL or MariaDB?

MariaDB began as a fork of MySQL. They are similar but have diverged in some features.

Why is WordPress slow at the database?

Often large option tables, missing indexes or heavy plugin queries.

MySQL or PostgreSQL?

Both are reliable. PostgreSQL offers more advanced features; MySQL is common in PHP applications.

Related

Related skills

Before you hireWriting the job postReading the proposalsSetting milestones

Post a job for MySQL experts

Describe the work and compare proposals. You only fund the first milestone once you have chosen someone.

Post a job