Walkthrough · Advanced · an hour
How to Optimize a MySQL Database
Hold query speed steady while the data accumulates year on year — a hands-on walkthrough in plain words that names the classic mistake before you reach it.
The short answer
One line covers it: hold query speed steady while the data accumulates year on year — a advanced-level job of roughly an hour.
Below is the full run of steps, the error most people trip over, and the short cut worth remembering. On Hosting & Domains plans several steps are already automated away — the guide marks each one.
By the Hosting & Domains team · Reviewed 18 August 2026
Advanced
Skill rating
an hour
Time budget
5
Steps in total
24/7
Support on call
No technical background needed. This walkthrough was written for first-timers, proven on our own hardware, and honest about which parts are genuinely tricky rather than merely unfamiliar.
First rule: read the snag section before you start, not afterwards. It was distilled from the tickets of everyone who tried the other order.
How the work divides up
Over the whole job, you will profile before you touch anything, index the columns queries filter on, clear the application debris, compact the tables and let ram absorb the repeat reads.
Every stage is a few minutes of unhurried clicking — the total depends mostly on how well you already know the control panel. The detailed instructions are further down; read the whole path once before you begin.
The well-worn snag
Indexing every column in sight. Each index taxes every write and takes storage, so indexes belong on measured hot paths rather than scattered across the schema as a blanket precaution.
Forewarned is genuinely forearmed here. This one mistake accounts for most of the frustration the topic ever causes — and it disappears entirely once somebody points it out.
A habit worth borrowing
On WordPress, auditing autoloaded options is the single richest check there is. Plugins leave bulky settings marked autoload, which means they load on every request, so trimming that set speeds up literally every page.
Habits this small are what separate the people who find hosting effortless from the people who find it draining. The same tools on both sides — a different way of working.
The parts that look after themselves here
Some steps in this guide exist only because hosting traditionally forced them on you. Here the SSL issues itself, the copy is taken daily without being asked, and one-click installers remove the manual setup. What is left is the part that was always genuinely yours.
Stopped mid-guide at an awkward hour? That is exactly what round-the-clock support is for — say which step you are on and we take it from there.
A quick platform makes for a short guide
Tutorials written against imaginary hosting go stale fast. Ours are written against the real thing: the same panel, installer and defaults waiting in your account.
Mailboxes at your own name are part of the plan — mail is included, not sold back to you at the checkout.
- Every step checked exactly as published
- The snag named before it arrives
- The dull steps taken out of your way
- People reachable at any hour you stall
Why Hosting & Domains
Standard on every plan
5 steps, nothing padded
Each stage is a few minutes of steady clicking, and the fiddly moments are labelled fiddly.
Help that keeps your hours, not ours
Stuck on step three at midnight? Support answers at any hour, mid-walkthrough included.
The dull parts automated
SSL, backups and installs look after themselves here, leaving the guide to cover only what is genuinely yours.
Honest about how big it is
Hold query speed steady while the data accumulates year on year is a advanced-level job — set aside an hour, with the platform-absorbed steps marked.
Taken from real tickets
These guides came out of the support queue, so every snag flagged is one people genuinely hit.
Every undo written out
Any step that could bite is marked, together with the exact way to wind it back.
Quick Start
Order placed to site online
- 1
Profile before you touch anything
Query monitoring, whether application-level tooling or slow-query logs where they are available, identifies the real offenders. Optimising without measuring is only rearranging furniture.
- 2
Index the columns queries filter on
Columns that keep appearing in WHERE and JOIN clauses deserve indexes. That is the textbook trade of a full-table scan for an instant lookup. Apply them through phpMyAdmin, with a backup first.
- 3
Clear the application debris
Revisions, transients, session rows and orphaned metadata. Cleaning up on the application side shrinks the heap every query has to wade through to reach your data.
- 4
Compact the tables
OPTIMIZE TABLE, or the panel's equivalent, reorganises storage after heavy churn. A modest gain, but a real one on tables carrying years of deletions.
- 5
Let RAM absorb the repeat reads
Redis object caching returns repeated queries from RAM. Often the greatest database optimisation is the set of queries that stop reaching the database at all.
Built In
Fitted to every plan
- A daily copy, with restores you run yourself from the panel
- SSH, Git and Composer on the developer plans
- No set-up charge at any point, and no joining fee
- DDoS filtering absorbed at the network edge
- Staging copies for trying a change before it goes live
- A renewal figure identical to the one you registered at
- Mailboxes that answer at the name you hold
- Free SSL on every plan, reissued before the old one lapses
- Spam and virus screening on every mailbox by default
- WordPress Toolkit, with the updates seen to for you
Frequently Asked
The questions that come up most
Can any of this break something?
Observing and measuring risks nothing. Structural work, indexes and optimisation passes, is safe under the usual precaution of a backup taken moments beforehand. The panel restore turns any mistake into a five-minute rewind.
Would more caching not fix this?
For anonymous visitors, yes, since the cache absorbs most of the query cost. But admin screens, checkouts and signed-in sessions still ride straight on the database, so tune it once those paths begin to drag. Shops and membership sites reach that wall first.
How quickly can a site be live?
Quickly — minutes rather than days. The account opens the moment payment clears, the domain (free for the first year on annual plans) attaches straight away, and the one-click installer has WordPress or any of 240+ applications running before your coffee cools. Site already somewhere else? Send the details and we move it free, normally within a day.
What is the refund position if I change my mind?
Shared, business, WordPress and WooCommerce hosting get thirty days, and reseller gets seven. VPS and dedicated servers are built to order the moment payment lands, so they sit outside the guarantee — as do domain registrations, where the registry charges the instant the name is secured. Inside the window one request returns the hosting fee, with no retention script to sit through.
Keep reading
How to Lazy Load Images and Video
Withhold offscreen media until the reader has nearly scrolled to it — beginner level, about 15 minutes.
How to Understand Website Firewalls
Understand what a web application firewall does, where it sits, and what you might ever change — intermediate level, about 20 minutes of reading.
Database (Glossary)
The plain-English definition this page rests on, with a worked example.
Email Hosting
Proper mailboxes at your own name, for one flat rate.
Secure Hosting
Imunify360, isolated accounts and hardened defaults for security-first builds.
Changing hosts? Run through our checklist first.
A plain order of work for a move nobody visiting will notice: which files go over first, how to carry the mail across without losing a message, when exactly to repoint DNS, and the two mistakes behind nearly every outage we are asked to rescue.
Start on a plan priced without games.
Every plan carries the essentials other hosts bill as extras — and support that answers.
View Email Hosting plans