How-to · Advanced · an hour
How to Optimize a MySQL Database
Everything you need to keep queries quick as the data piles up year after year — the steps in order, the snag to watch, and the tip our support desk gives everybody.
Straight answer first
In a line: keep queries quick as the data piles up year after year — a advanced-level task that takes an hour.
The walkthrough below covers every step, the mistake most people make, and the shortcut worth keeping. On Hosting Seller plans several of these steps are already done for you, and we say where.
Written by the Hosting Seller staff · Checked 1 August 2026
Advanced
Skill needed
5
Stages to finish
Free
Help included
Tested
On our own kit
You do not need to be technical for this. The walkthrough is written for first-timers, tested on our own platform, and honest about which parts are genuinely fiddly and which are merely unfamiliar.
Rule of the road: read the snag section before you begin rather than after. It is harvested from the tickets of people who did it the other way round.
The shape of the work
From start to finish, you will measure before you change anything, index the columns you search on, clear out the application clutter, defragment the tables and answer repeat reads from memory.
Each stage is a few minutes of steady clicking — the time it takes depends mostly on how familiar the control panel already feels. The detailed steps sit further down this page; skim the whole route once before you begin.
The classic snag
Indexing every column in sight. Each index taxes every write and takes up storage, so indexes belong on measured hot paths rather than sprinkled across the schema as a general precaution.
Forewarned really is forearmed here. This one mistake accounts for most of the frustration the subject produces, and it is entirely avoidable once somebody names it.
The trick worth borrowing
On WordPress, auditing the autoloaded options is the highest-yield single check. Plugins leave sizeable settings marked autoload, which means they are read on every request, and trimming that set speeds up literally every page.
Small habits like this are the real difference between people who find hosting easy and people who find it stressful. The tools are identical; the working method is not.
What runs by itself here
Several steps in this guide exist only because hosting historically made you do them. On our plans SSL issues itself, backups run daily without being asked, and one-click installers replace the manual setup entirely. What is left is the part that is genuinely yours.
Stuck halfway through at an odd hour? That is exactly what round-the-clock human support is for — tell us where you are in this guide and we will pick it up from there.
A good platform makes every guide shorter
Every walkthrough on our how-to shelf is tested on the platform we actually run — cPanel, LiteSpeed, NVMe, one-click installs — so the instructions match your screen instead of gesturing vaguely at it.
What you pay on day one is what you pay at renewal, so the year-two invoice holds no surprises worth opening early.
- Step by step, tested exactly as printed
- The snag flagged before you reach it
- The dull steps are already automated
- People on hand at any hour if you stall
Why Hosting Seller
On every plan, as standard
5 steps, no filler
Each stage is a few minutes of steady clicking, with the fiddly parts marked as fiddly.
Help on the counter
Stuck on step three at midnight? Support answers at any hour, mid-guide included.
Automation where it belongs
SSL, backups and installs run themselves here, so the guide covers only what is genuinely yours to do.
Scoped honestly
Keep queries quick as the data piles up year after year is a advanced-level task — this guide budgets an hour and says which steps the platform absorbs.
Written from real tickets
Our guides come off the support desk, so the snags flagged here are the ones people genuinely hit.
The undo is always named
Where a step could bite, the guide says so and tells you how to put it back again.
First Steps
From choosing to live
- 1
Measure before you change anything
Query monitoring — application-level tools, or slow-query logs where they are available — names the actual offenders. Optimising without measuring is just redecorating.
- 2
Index the columns you search on
Columns appearing in frequent WHERE and JOIN clauses want indexes. That is the classic conversion of a full-table scan into an instant lookup. Add them in phpMyAdmin, after a backup.
- 3
Clear out the application clutter
Revisions, transients, session rows and orphaned metadata. Application-level cleanup shrinks the pile that every single query has to wade through to reach your data.
- 4
Defragment the tables
OPTIMIZE TABLE, or the panel's equivalent, tidies storage after heavy churn. Modest in effect, but real on tables with a long history of deletions behind them.
- 5
Answer repeat reads from memory
Redis object caching serves repeated queries out of memory. The biggest database optimisation is often the queries that stop reaching the database at all.
In the Box
Packed with every plan
- Nothing added at setup — no joining fee, ever
- DDoS filtering handled out at the network edge
- The renewal price printed on the tag matches the order price
- Mailboxes that carry your own domain name
- A free SSL certificate on every plan, reissued before it lapses
- Webmail in the browser plus IMAP, POP and SMTP for your own client
- Staging copies so changes get tested before they go live
- cPanel, the panel the rest of the trade already knows
- The Softaculous installer for one-click application setup
- Spam and virus filtering fitted to every mailbox
Across the Counter
The questions we get asked most
How risky is this?
Reading and measuring carry no risk at all. Structural changes — indexes, optimisation passes — are safe with the standard precaution of a backup taken seconds beforehand. The panel restore turns any misstep into a five-minute rewind.
Why not just add more caching?
Caching hides query cost for anonymous visitors, but the database still decides how fast admin, checkout and logged-in pages feel. Optimise when those uncached paths drag — stores and membership sites notice it first.
How quickly can I be up and running?
Minutes, not days. The account opens the moment the order clears, the domain — free for year one on annual plans — attaches straight away, and the one-click installer puts WordPress or any of 400+ applications on the page before you leave your chair. Already have a site elsewhere? Hand it over and we move it free, usually inside a day.
Is there a refund if it does not suit?
Yes — thirty days. Put the hosting through real work, and if it is not right, ask for the money back and you get it; there is no retention script to survive first. Domain registrations are the one carve-out, because registries take that fee the moment the name is placed.
What if the site outgrows the plan I bought?
You move up in place. Plan changes are made from the client area with no migration and no downtime, and the range runs from small shared accounts through VPS to whole dedicated servers. Growing becomes a line change on your account rather than a hunt for a new host.
Does hosting come with mailboxes?
It does — mailboxes on your own domain ship with every hosting plan, with webmail, IMAP, POP and SMTP access and spam filtering fitted as standard. There is also standalone email hosting for domains whose website lives somewhere else entirely.
Are backups included, and can I put one back myself?
A backup is taken daily on every plan, and the restore is yours to run from the panel in minutes — files, databases or both, at three in the morning without waiting on a ticket. Keeping your own copy offsite as well is never a bad habit, and nothing here stops you.
Read next
How to Build a Landing Page That Converts
One page with one job, and the numbers to show it is doing it — beginner level, about an afternoon.
How to Block Unwanted Visitors by IP
Turn a persistent nuisance away at the door, knowing what the tool can and cannot do — intermediate level, about 10 minutes.
SSL Certificates
SSL free on every plan, with wildcard and EV on the shelf if needed.
VPS Hosting
KVM virtual servers with root access, DDoS filtering and one flat price.
Packing up and moving host? Take our checklist.
A plain running order for a move nobody notices: what to copy first, how to carry email across without dropping a single message, when to point DNS, and the two slips behind nearly every hour of downtime we get called about.
Get online, with no games at checkout.
Every plan carries the essentials other hosts ring up as extras — and support that actually replies.
See the plans