How to Fix a Slow Database (2026): Confirm, Then Clean

Disclosure: WebFin is reader-supported. If you buy hosting through links on this page, we may earn a commission at no extra cost to you. Commissions vary between providers and our ratings do not — here’s our full disclosure.

A slow database shows up in a specific way: cached pages are fine, and everything else drags. The dashboard is sluggish, search takes seconds and a cart or a member page feels heavy. The home page looks fast, because a visitor is served a stored copy. Before optimizing anything, confirm that the database is the problem, because the same symptoms come from a heavy page or a crowded server.

How to Fix a Slow Database: The Short Answer

Compare a cached page with an uncached one to confirm the database is involved. Back up. Then clean in this order: autoloaded options, post revisions, expired transients, orphaned metadata, and tables that only grow, such as plugin logs. Optimize the tables, enable object caching if your host offers it, and only then think about indexes or a bigger plan.

See Kinsta Plans →
Application performance monitoring is included in the plan, which names the slow query instead of leaving you to guess. Starter is $35.00 a month flat.

Step 1: Confirm It Is the Database

Load a cached article, then load the search results page or a logged-in dashboard. If the first is quick and the second is slow, the work happens after the cache. That points at queries.

Then count the queries. A query monitoring plugin shows how many run per page and which take longest. Hosts with application performance monitoring, such as Kinsta, show the same thing from the server side. Our guide to testing your site speed properly covers measuring both cases without fooling yourself.

⚠️ If both pages are slow, look at the server or the plan first. A crowded shared account produces the same feeling, and our guide to checking whether your host is throttling you shows where the faults appear.

How to tell a slow database from a slow server or a heavy page

Step 2: Back Up Before You Delete Anything

Every step below removes rows. Take a database copy off the server first, and know how to put it back. Our guide to backing up a WordPress site covers the four parts of a site, and the database is the one that matters here.

Cleanup plugins are convenient and blunt. Read what each option deletes before running it, and run one thing at a time so you can tell what helped.

Step 3: The Usual Suspects, in Order

Autoloaded options. WordPress loads part of the options table on every single request. Plugins that store large blobs there make every page slower, including cached ones building for the first time. This is the first place to look and the one most guides skip.

Post revisions. A long-running site keeps dozens of revisions per post, each with its own metadata rows. Limit them in wp-config.php and delete the old ones.

Expired transients. Temporary cached values that never got cleaned up, sometimes tens of thousands of rows.

Orphaned metadata. Rows in post and user metadata left behind by plugins you removed. They are never read and always scanned.

Tables that only grow. Activity logs, 404 logs, analytics tables, abandoned carts, session tables. These are the ones that turn a 30 MB database into a gigabyte.

Six common causes of database bloat in the order to check them

Step 4: Optimize, Then Cache

After deleting rows, run the optimize operation on the affected tables so the space is actually reclaimed. Most hosting panels expose this in their database tool, and cleanup plugins offer it too.

Then look at object caching. Redis or Memcached keeps query results in memory, which removes repeated work on uncached pages. Managed platforms and servers commonly offer one, and shared plans commonly do not. That is one reason the same site feels different on a VPS. Our guide to reducing TTFB covers where object caching sits among the other layers.

See Cloudways Plans →
A server you size yourself, with SSH and database access on every tier, from $14.00 a month billed by the hour.

Step 5: Indexes and Queries

If monitoring names one slow query, that is the fix. Add an index on the column it filters, or change the plugin setting that runs the query on every page. Adding indexes by hand is a developer task, and it belongs on a staging copy first.

Meta queries are the usual culprits, because they scan a table that grows with every post and every user. A site whose search filters by several custom fields does exactly that on each request. Our list of hosting for membership sites covers as the uncached case.

Step 6: When It Is the Plan

Database size and table count have ceilings on shared hosting. Bluehost, a Newfold Digital brand, publishes 5 GB for a single database and 5,000 tables or 10 GB across all of them, which is the kind of limit a bloated site meets before it runs out of disk.

A shared database server is also shared: your queries wait behind other accounts’, and no amount of cleaning changes that. If the site is clean and still slow, the next step is a server, as our guide to moving from shared to VPS covers.

Host and planLimitWhere it's stated
Bluehost shared50,000 inodes — soft limitHosting Inode Limit article
Bluehost shared200,000 inodes — AUP thresholdServer Resource Limitations
Bluehost shared1,000,000 inodes — TOS violationHosting Inode Limit article
Bluehost shared5,000 tables or 10 GB, all databasesServer Resource Limitations
Bluehost shared5 GB per single databaseServer Resource Limitations
Bluehost Starter100 MB per mailboxShared hosting prices page
WP Engine Startup25,000 monthly visits, then overage handlingPlan pages
WP Engine, by tier25,000 to 400,000 monthly visitsPlan pages
Rocket.net Starter25,000 monthly visits, 1 site, 10 GB storagePlan pages
Namecheap EasyWP50,000 / 200,000 / 500,000 monthly visits by tierPlan pages
Kinsta Starter25,000 monthly visitsPlan pages
Scala Hosting VPSPriced per unit: $3 per core, $1 per gigabytePlan pages; adjustable anytime
HostGator sharedWeekly backups described as a courtesy, not guaranteedHosting terms
Liquid WebDedicated resources at every tier; no shared planPlan pages
InterServer StandardUnlimited storage, bandwidth, email and websitesOne plan, no tiers
GreenGeeks LiteOne website onlyPlan pages
IONOS PlusOne email account bundled per planPlan pages
Hostinger, all plansNot publishedHostinger support article, 28 Aug 2026
Bluehost Starter10 GB NVMe storagePlan pages, as listed in a 2026 audit
InMotion CoreOne site, 10 email accounts, SSD storage; NVMe from LaunchTechRadar and a 2026 review
SiteGround sharedShell access by tier — not recordedNot stated on the plan pages we read, 20 Sep 2026
Bluehost sharedShell access by tier — not recordedNot stated on the plan pages we read, 20 Sep 2026
Hostinger, all plansShell access by tier — not recordedNot stated on the plan pages we read, 20 Sep 2026
Cloudways serversSearch service (OpenSearch, Elasticsearch) — not recordedNot stated on the plan pages we read, 20 Sep 2026
AzureB1S virtual machine free for 12 months for new customersagentdeals 2026
Bluehost cPanelIncluded on shared plans: Hosting tab → Quick Links → cPanel, or Websites → Overview; also domain/cpanel or :2083; no separate login; Bluehost Cloud does not include cPanel; Softaculous in cPanelBluehost knowledge base (official)
Bluehost emailFree cPanel mailboxes with every hosting plan; 30-day Professional Email trial with new hostingHostAdvice guide, 2026
Bluehost migrationFree for qualifying WordPress sites within 30 days of signup via the Bluehost Site Migrator plugin; one site per hosting purchase; malware-free; reviewed by experts; otherwise paid professional migration; about 2–3 days; WordPress.org sites on new shared accountsBluehost knowledge base and migration page (official); TechRadar
Bluehost SSLFree SSL listed among standard hosting features; Premium SSL optional at $89.88Truehost 2026; our tables
Bluehost statusOfficial status page at pulse.bluehost.com/status: operational, degraded, partial and major outage levels; uptime statistics and incident history; uptime guarantee varies by productBluehost (official)
Cloudflare Pages (free)Unmetered bandwidth for static assets; 500 builds a month, one at a time; up to 100 custom domains per project; 20,000 files per site; Workers recommended for new SSR projectsGuptaDeepak, Puter, bootstrap.build 2026
Cloudflare RegistrarAt-cost registration and renewal, no upsells, free WHOIS privacy and DNSSEC, 400+ TLDs; Cloudflare nameservers required; 60-day transfer lock; minimal support on free accountsdomains.cloudflare.com (official); StartupOwl, Mystrika 2026
ContaboThrottles port speed after 10 days over the traffic allowance instead of charging overageLearnWithHasan, 2026
DigitalOceanPowered-off Droplets still bill; 99.99% SLA publishedCostBench, LinuxTeck, 2026
DigitalOcean App PlatformThree free static sites, 1 GiB outbound transfer each a monthagentdeals 2026
DreamHost Email3-month free trial with every web hosting plan; unlimited on DreamPress, VPS and DedicatedDreamHost email page, Oct 2026
DreamHost statusHelp article 'Current Status Notifications' points to the official status page; contact technical support if your site has issues while systems show operational; incident history on StatusGatorDreamHost help center (official); StatusGator
DreamHost VPSManaged; unmetered bandwidth; daily backups; 30-day refund; no four-year termFitGap; Website Builder Expert
DynadotFree WHOIS privacy on every domainDomainOffer, 2026
FatCowOne shared plan; 30-day money-back; no free migrationWebsiteSetup review
GitHub PagesFree for public repositories; about 100 GB bandwidth a month (soft); 1 GB site size; about 10 builds an hourPuter, bootstrap.build 2026
GoDaddy Website BuilderFree plan with GoDaddy branding; SEO tools from Premium; free domain on annual plansTechRadar and Website Builder Expert, 2026
GoDaddy Windows HostingPlesk; supports latest .NET Framework 3.5 and 4.8, .NET Core 8 and 9; end-of-life .NET versions removed from Q2 2025GoDaddy help center (official)
Google Cloud$300 credit for new customers (90 days); always-free tier incl. 1 e2-micro VM a month (us-west1, us-east1, us-central1), 30 GB HDD, 5 GB Cloud Storage; 1 GB free egress a month from North AmericaGoogle Cloud free page (official); FreeTier.co and NicheeLab guides, 2026
Heroku / Fly.io free tiersHeroku free tier removed 2022; Fly.io no free tier for new accounts since Oct 2024agentdeals 2026
HetznerFour pricing actions in 2026: setup fees (Feb), +30–37% (1 Apr), dedicated setup fees (29 Apr), and cloud rises of +33% to +169% by line (15 Jun)PrivateDevOps, Jun 2026; Hetzner price page
HostGator statusOfficial status page at hostgator.com/status: component indicators, uptime statistics, incident history, maintenance labelled separately; if operational but site down, clear cache, try another network, check DNS, then contact chat or phoneHostGator (official)
HostGator VPSSelf-managed and managed lines; discount on the first invoice only; cPanel priced separately; free migration from third-party hosts; 30-day refund windowHostGator VPS pages and price chart (official)
Hostinger Cloud limitsStartup 4 GB / 4 cores; Professional 6 GB / 5 cores; Enterprise 12 GB / 6 cores; Enterprise Plus 15 GB / 8 coresHostinger support (official)
Hostinger migrationFree website migration via a Migration Request Form; Hostinger handles it; unlimited for all customers; usually under 48 hoursHostinger compare page (official, Jul 2026); WebsitePlanet; CrazyEgg
Hostinger PremiumUp to 100 mailboxes as a free Business Email trial, usually for the first year; then they renew as paid Business Starter ($1.59 a mailbox a month)DEV guide, Aug 2026; Hostinger support (official); TechRadar
Hostinger statusOfficial status page with components: datacenters (US, UK, NL, DE, FR, LT, SG, IN, BR and more), hPanel, Mail, DNS, CDN, VPS API; tracked by StatusGator, IncidentHub and OpenStatusStatusGator; IncidentHub; OpenStatus, Oct 2026
Hostinger Website BuilderNo free plan; 14-day trial; Business needed for full AI tools and ecommerceStartups.co.uk and Website Builder Expert, 2026
HoverFounded 2008 by Tucows (Canada); free WHOIS privacy; no pre-checked add-ons; ICANN-accredited (IANA ID 69)ProfileTree; DomainOffer, 2026
InMotion Hosting PlusPython, Node.js, Ruby and Git on shared plansInMotion pricing page (official)
InMotion VPSLaunch Assist free server setup on all VPS; management options self, core and fullCB Insights 2026
InterServer VPSPrice lock; 30-day refund; US-only locations; older hardware per a competitorwhtop; Expanse (competitor), Aug 2026
IONOS dedicatedConfigurable hardware, choice of data center, RAID options, unlimited bandwidth on listed plansGeekchamp; Cybernews
IONOS domainsFree WHOIS privacy; Wildcard SSL for the initial domain contractDomainOffer; Thewearify citing IONOS's .com page
IONOS MyWebsite NowFree domain year one, SSL, email inbox (2 GB Starter, 12 GB+ higher); one site per subscription; 24/7 phone support; store versions cost moreExpertMarket; TechRadar; ionos.ca
IONOS statusOfficial IONOS US status page with components including Control Panel, DNS, VPS, Webmail, SSL and Customer Hotline, tracked by StatusGatorStatusGator
iPageOne main shared plan; free SSL; free domain year one; 30-day money-backDiggityMarketing, LarryLudwig 2026
Kinsta infrastructureGoogle Cloud C2 VMs and Premium Tier network for all sites; C3D in some data centers ('Boosted'), 20–50% faster response than C2 in Kinsta's tests; 37 locations on its 2026 page (older pages list 27 to 36)Kinsta (official)
Linode (Akamai Cloud)Owned by Akamai since 2022; linode.com redirects to akamai.com; Linux-only KVM; 24/7 phone reportedLearnWithHasan, 2026
Liquid Web dedicated100% network uptime SLA; backups included on all plans; managed and self-managed optionsBluehost blog; Cybernews; Geekchamp
Magento 2.4.x requirements8 GB RAM recommended (4 GB works with performance issues); PHP 8.3; OpenSearch; current releases need OpenSearch 3; Magento 2.4.6 regular support ended 11 Aug 2026; MySQL 8.0 support ended 30 Apr 2026; Elasticsearch 7.17 ended 15 Jan 2026Cloudways support doc; Findstack citing Adobe's requirements page (18 Aug 2026); EveryHost 2026
Magento hostsCloudways: one-click Magento install; Liquid Web: Magento among its managed applications; hosting.com: Magento among supported applications (stack unverified)Cloudways support; Findstack, Aug 2026
Microsoft Azure$200 credit for 30 days (unused credit lost); 12 months of free services for new customers; always free App Service: 10 apps, 1 GB, 1 hour of compute a dayAzure free-services page and Microsoft Learn (official); agentdeals 2026
Namecheap Private Email60-day free trial; storage 5 / 10 / 15 GB a mailbox; plans renamed Launch / Expand / Scale from 2 June 2026Namecheap email page and KB
Namecheap Reseller limitsNebula: 30 email accounts in total, 50 messages an hour per domain; Galaxy: 200 an hour, unlimited mailboxes; WHMCS license prices rose Jan 8, 2026Namecheap knowledge base and blog (official)
Namecheap statusKnowledge base article points to Namecheap's status page for maintenance and hosting server noticesNamecheap (official)
Namecheap StellarBackups about twice a week, not guaranteed; Plus and Business get daily AutoBackupNamecheap shared hosting page, Oct 2026
Netlify (free)Credit-based since 2026: 300 credits a month, hard cap; site pauses when credits run outbootstrap.build, agentdeals 2026
Oracle CloudAlways Free: Ampere A1 4 OCPU/24 GB per Oracle docs as read; cut to 2 OCPU/12 GB for free-only accounts per InfoQ (Jul 2026); 2 AMD micro VMs; 200 GB block storage; $300 credit for 30 days; idle reclamation; frequent out-of-capacity errorsOracle docs; InfoQ; TerminalBytes; Oracle community, 2026
OVHcloud VPSAnti-DDoS, daily backup, unlimited traffic in EU/NA; APAC quotas (VPS-1: 500 GB); self-managed; 99.9% SLA advertisediTechGuides, Aug 2026; OVHcloud US announcement, Sep 2025
PHP versionsEach branch: 2 years active + 2 years security. 8.1 end of life 31 Dec 2025; 8.2 security until 31 Dec 2026; 8.3 security until 31 Dec 2027; 8.4 active until 31 Dec 2026, security until 31 Dec 2028; 8.5 active, security until 2029php.net supported-versions (official); Remi's repository blog, Jan 2026
PorkbunFree WHOIS privacy, free Let's Encrypt SSL (incl. wildcard), up to 20 email forwards, URL forwarding, DNS on Cloudflare; email hosting $2 an inbox a month, annualAffNinja and Hostinger's registrar guide, 2026
PressableWP Cloud (WordPress.com infrastructure); CDN, daily and hourly backups, staging, Jetpack Security, WAF, free migrations; 24/7 WordPress support; no email hosting; WordPress onlyCloudTweaks; whtop; Blogrecode 2026
PythonAnywhereFree Beginner: 1 web app on a pythonanywhere.com subdomain, 100 CPU-seconds a day, 512 MB disk, outbound access limited to allowed sites; Developer $10 a monthFly.io comparison (Sep 2026, a competitor); agentdeals 2026
Railway$5 one-time trial credit for 30 days, then per-second billingagentdeals 2026
Render (free web service)Spins down after 15 minutes idle, about a minute to wake; 750 free instance hours a month; free Postgres expires after 30 days; 512 MB RAMFly.io comparison (Sep 2026); agentdeals 2026
SiteGroundNo VPS or dedicated servers; cloud hosting with auto-scaling insteadCyberInsider; Bitcatcha; FitGap 2026
SiteGround emailUnlimited email accounts on shared plans; no email-only plansTooltester; Bitcatcha; CyberInsider 2026
SiteGround migrationFree professional migration on select plans only (plans not specified in source)CrazyEgg
SiteGround statusstatus.siteground.com, per a third-party guide; confirm through SiteGround's help centerGMapsWidget (third-party)
Vercel HobbyFree for personal, non-commercial use; 100 GB bandwidth; site pauses above limitsPuter, bootstrap.build 2026
Vultr33 regions; hourly billing capped at 672 hours a month; no free tier or trialFrontDesk Review, CostBench, 2026
Windows hosting marketAccuWeb ended Windows personal hosting Sep 2025; Reg.ru ended Windows shared plans Feb 2026; Windows costs more due to Microsoft licenseswhtop; TechRadar
WP Engine statusOfficial status page with components: North America, Europe, Asia/Pacific, CDN, SSL, Mail, Backups, User Portal, SFTP, chat, phone and ticket support; no published maintenance feed; 8+ years of history on StatusGatorStatusGator
GitHub Student Developer Pack: DigitalOceanEnded: the $200 credit closed after 31 Jul 2026; redeemed credits expired 1 Aug 2026Capital & Compute citing the pack changelog, Sep 2026
GitHub Student Developer Pack: NamecheapFree .me domain for one year with an SSL certificate; verification lasts two yearsGitHub Education pack page, 2026
Storage, site count and inode limits as stated in each provider's own documentation, which sometimes contradicts the marketing page. Checked 11 October 2026.

Habits That Keep It Fast

Limit revisions. Set a cap once in wp-config.php: three or five keeps the history useful without the rows.

Prune logs monthly. Any plugin that writes a row per visit needs a retention setting, and most have one turned off by default.

Delete plugins you stopped using. Deactivating leaves the tables and the metadata behind.

Watch the size. Note the database size once a month. A number that doubles without new content is a plugin misbehaving. Our guide to setting up automatic backups makes the safety net automatic while you investigate.

Monthly habits that stop a WordPress database growing out of control

What a Cleanup Actually Changed

Expect the dashboard and search to improve, because those pages were doing the extra work. Expect cached article pages to look the same, because they were never touching the database in the first place.

If nothing improved, the cleanup was not the problem. Put the effort into monitoring instead: one named slow query is worth more than a hundred thousand deleted rows, and that is what application performance monitoring is for.

Two Cases Where Cleaning Will Not Help

A store with real order history. Orders, customers and subscriptions are the business, and they are supposed to grow. The answer is indexes, object caching and a bigger server rather than deletion, which our list of hosting for ecommerce covers.

A long archive. A publication with twenty thousand posts has a large database legitimately. Our list of hosting for news sites covers planning for that rather than fighting it.

One Number Worth Writing Down

Before you clean anything, note two figures: the size of the database and the number of queries on your slowest uncached page. After the cleanup, note them again.

Without those, a cleanup is a feeling rather than a result, and the next plugin that bloats the options table will go unnoticed for months. Our guide to setting up a staging site covers doing the risky part on a copy first.

Moreover, this guide covers related questions: How to Move Away From an EIG Brand.

How We Research

This guide describes procedures rather than measurements, and it runs no tests. The database and table limits named here come from the providers’ own documentation, read on 20 September 2026, and sit in our tables.

Individual plugins and their table designs are outside what we review, because the behavior depends on the plugin rather than the host. The criteria behind our scores are on our about page, and our guide to fixing a 500 error covers the case where the site fails outright rather than dragging.

Slow Database FAQ

How do I know the database is the problem?

Compare a cached page with an uncached one. If the article loads quickly and the search results or dashboard drag, the work happens after the cache. That points at queries.

What causes a WordPress database to get slow?

Autoloaded options holding large values, post revisions, expired transients, orphaned metadata from removed plugins, and tables that only grow such as activity or 404 logs.

Does optimizing tables actually help?

It reclaims space after you delete rows, which is worth doing as the last step of a cleanup. On its own, without deleting anything, it changes very little.

Will object caching fix a slow site?

It removes repeated query work on uncached pages, which helps dashboards, carts and member areas. Managed platforms and servers commonly offer Redis or Memcached, and shared plans commonly do not.

How big is too big for a database?

It depends on the plan rather than on WordPress. Bluehost publishes 5 GB for a single database and 5,000 tables or 10 GB across all of them, and a bloated site can meet those before it runs out of disk space.

The Verdict

Confirm the diagnosis first, because a heavy page and a crowded server feel identical from the outside. Then work in order: autoloaded options, revisions, transients, orphaned metadata, growing tables. Back up before each step and change one thing at a time.

If the database is clean and the site is still slow, the problem is capacity rather than housekeeping. That means object caching, an index on the query monitoring named, or a server of your own. Our list of hosting for developers records which hosts put database access and object caching within reach.

See Scala Hosting Plans →
Daily backups and cloning in its own panel, plus a VPS priced at $36.00 a year per processor core and $12.00 per gigabyte of memory.
Scroll to Top