Running on MySQL?

MySQL stalling or out of connections? We sort it.

MySQL usually keeps running long after it should have been tuned. The site stays up, the slow queries pile up in a log nobody reads, and then one afternoon the pool fills and nothing new can get in. We trace what the server is actually doing and make it stop.

  • Since 2015Fixing technology
  • FreeEstimates
  • US teamReal engineers

mysqld.log

still failing

What it is

MySQL at a glance

MySQL is an open-source relational database, first released in 1995 by a small Swedish company called MySQL AB. Sun Microsystems bought the company in 2008, and Oracle picked it up with Sun the year after, which is why the project is now stewarded from Redwood Shores rather than Uppsala.

It is the database sitting under WordPress, Drupal, Magento and a very long list of PHP applications. Rows live inside pluggable storage engines, and almost every site today uses InnoDB, with the old MyISAM engine still lurking in older tables that never got converted. MySQL ships under a dual licence: the GPL version is free to use, and a paid commercial edition exists for shops that cannot accept the GPL terms.

Type
Relational database
First released
1995
License
GPL v2 with commercial options
Maintained by
Oracle Corporation
Typically used for
CMS back ends, PHP applications, web app storage, analytics

The honest version

MySQL pros and cons

No technology is all upside. This is where MySQL earns its place and where it tends to cause trouble.

Where MySQL is strong

  • It is everywhereMySQL is the default database on the LAMP stack and comes preinstalled or one click away on virtually every shared host, VPS and cloud provider.
  • Replication that actually worksPrimary and replica setups have been solid for years, with well-understood tooling for read scaling, reporting copies and warm standbys.
  • A grown-up ecosystemDecades of books, blog posts, monitoring tools, DBAs and Stack Overflow answers mean whatever you have hit, somebody has written about it.
  • The tuning knobs are knownBuffer pool size, log file size, query cache, connection limits: the levers that matter are documented to death, and good defaults for a given workload are not a mystery.
  • Works with every CMS and frameworkWordPress, Drupal, Magento, Laravel, Django, Rails: all of them run against MySQL out of the box, with no adapter hunting required.

Where MySQL bites

  • The defaults assume a laptopA fresh install sets innodb_buffer_pool_size at a value suited to a developer's machine, not a production server with gigabytes of RAM going unused.
  • MyISAM leftoversOlder databases still carry MyISAM tables that nobody got around to converting. They don't do transactions, they corrupt on crash, and they quietly block modern features.
  • Slow queries hide in the logThe slow query log is often switched off, or switched on and never looked at. Queries that take seconds can sit there for months while the site gets steadily worse.
  • Split licensing since the Oracle takeoverThe community edition is GPL and free; the enterprise edition, monitoring tools and some storage features sit behind a paid Oracle contract. The line between them is not always obvious.
  • MariaDB has driftedThe MariaDB fork started as a drop-in replacement and is no longer quite that. Features, optimiser behaviour and some SQL syntax now differ, so what runs on one does not always run on the other.

Sound familiar?

Common MySQL problems we fix

The MySQL problems that bring people to us, and what you have once each one is fixed.

ERROR 1040: Too many connections

The app can't open a connection

Every PHP worker and cron job grabs its own connection and holds it, until max_connections is reached and everything else is refused.

Pooled, with sensible limits

Slow query: 24.8s

A query that used to be fine is dragging

A missing index, a growing table, or a WHERE clause that the optimiser can no longer satisfy without scanning the lot.

Rewritten, indexed and measured

MySQL 5.7 end of life

Still on MySQL 5.7 after support ended

Extended support ran out in October 2023 and nobody has been brave enough to move to 8.0 because of character set and auth plugin changes.

Upgraded to 8.0 on a rehearsed plan

Table ... is marked as crashed

A table is corrupt and refuses to open

Usually an old MyISAM table after a power loss or disk issue, sometimes an InnoDB file with buffer pool corruption after a bad shutdown.

Repaired, with the cause removed

MySQL server has gone away

Long-running jobs keep getting cut off

Timeouts, max_allowed_packet set too small, or the server killed under memory pressure mid-query.

Settings matched to the real workload

last verified restore: never

The dumps run but nobody restores them

A nightly mysqldump that fails silently, or sits on the same disk as the database it is meant to protect.

Backups tested on a schedule

What we do

MySQL help, from one fix to full care

Call us for a single slow query, or hand us the whole server.

Rescue
Locked up, refusing connections or sitting on a crashed table. We get it serving again, then dig into why it stopped.
Performance
Buffer pool sizing, index work, slow query review and connection pooling, with hard numbers before and after.
Version upgrades
MySQL 5.7 to 8.0, or moving between MySQL and MariaDB, rehearsed on a copy so the live cutover is quiet.
Backup and recovery
Point-in-time binlog backups, off-server copies, and restores that have actually been run end to end.
Migrations
Moving between hosts or into managed services like RDS, Aurora or Cloud SQL, with no surprises for the application.
Managed Tech
Monitoring, patching, maintenance and a team to call, on an ongoing basis.

How it works

From first message to fixed

  1. Look Free estimate

    Tell us what's going wrong. We look at it, then tell you plainly what's wrong and what it will cost.

  2. Fix

    We fix the cause, not the symptom. If something is down, getting it back up comes first.

  3. Harden

    Backups, monitoring, updates and access, so the same problem can't quietly come back.

  4. Hand back or stay on

    You get a plain-language write-up. Or we stay on for hosting, upkeep and new work.

Often found together

Running MySQL alongside something else?

We work on the whole stack, so the problem can be wherever it actually is.

Questions

MySQL questions

Something else? Call+1 737 727 7327

Why am I getting 'too many connections' errors?

Your application is opening more connections than max_connections allows and holding them open. Raising the limit buys an hour or two before it happens again. The real answer is almost always a connection pool in front of MySQL and application code that releases connections when it is done with them.

How do I speed up a slow MySQL query?

Start by capturing it, either from the slow query log or with EXPLAIN. Most slow queries turn out to be missing an index, scanning more rows than they should, or built in a way the optimiser can't use. The fix is usually a targeted index, a rewritten WHERE clause, or occasionally a schema change, not more hardware.

Is it safe to upgrade from MySQL 5.7 to 8?

Yes, if it is rehearsed. The 8.0 jump changes default character sets to utf8mb4, switches the authentication plugin, and removes a handful of deprecated features. We run the upgrade against a copy of your data first, retest the application against it, then schedule the real cutover.

Should we switch from MySQL to MariaDB or PostgreSQL?

Only if there is a reason beyond preference. MariaDB is close to MySQL but no longer a free swap. PostgreSQL has stricter data handling and better handling of complex queries but requires application changes. We will tell you plainly whether a switch is worth the work in your case.

Can you fix a corrupted MySQL table?

Usually, yes. For MyISAM tables that come up as crashed, REPAIR TABLE or myisamchk often brings them back. For InnoDB corruption we recover from binlogs and backups rather than trusting a half-broken tablespace. Either way, we also find out what caused it so it does not keep happening.

How much does MySQL help cost?

Estimates are free. Describe the symptom and the environment, and you get a price before any work begins.

Free estimate

MySQL giving you trouble?

Tell us what you're running and what's going wrong. A person reads it and comes back with an estimate.

  • No charge to find out what it will take
  • If it's urgent, say so

Replies come from a person. By sending, you authorize us to email you back. No marketing.