This databases guide walks UK Plesk users through Optimising Database Performance on Plesk Obsidian. Steps apply to any managed Plesk hosting plan — including smartxhosting.uk/web-apps where Plesk is bundled with EU data-centre hosting, free SSL, daily backups, WP Toolkit and UK business-hours support.
Why Database Performance Matters · Signs of Database Performance Issues · Checking Database Size in phpMyAdmin · Optimising Tables in phpMyAdmin · WordPress-Specific Database Cleanup · Using Redis Object Caching · General Performance Tips · When to Contact Support · FAQ
Plesk provides full database management:
On smartxhosting.uk managed Plesk, regular off-server database backups run automatically.
Plesk provides full database management:
On smartxhosting.uk managed Plesk, regular off-server database backups run automatically.
Plesk provides full database management:
On smartxhosting.uk managed Plesk, regular off-server database backups run automatically.
Plesk PHP management:
Plesk provides full database management:
On smartxhosting.uk managed Plesk, regular off-server database backups run automatically.
This section covers the practical aspects of optimising database performance in Plesk Obsidian for UK users.
The feature is accessed from the main Plesk panel — typically via a left-sidebar entry or a per-domain settings tab. Behaviour is consistent across Plesk Linux (smartxhosting.uk default) and Plesk Windows with minor path differences.
For managed Plesk hosting with UK support and VAT invoices, see smartxhosting.uk/web-apps. Under UK GDPR, include any personal data processed through this feature in your data-processing inventory.
Plesk performance and caching:
.htaccess for static assets.This section covers the practical aspects of optimising database performance in Plesk Obsidian for UK users.
The feature is accessed from the main Plesk panel — typically via a left-sidebar entry or a per-domain settings tab. Behaviour is consistent across Plesk Linux (smartxhosting.uk default) and Plesk Windows with minor path differences.
For managed Plesk hosting with UK support and VAT invoices, see smartxhosting.uk/web-apps. Under UK GDPR, include any personal data processed through this feature in your data-processing inventory.
Q: Do I need a specific Plesk licence for this feature?
A: Most features described here are included on all managed smartxhosting.uk Plesk hosting plans. Advanced features (WP Toolkit Deluxe, Developer Pack) may require plan upgrade.
Q: Does this work on both Linux and Windows Plesk?
A: Yes — Plesk Obsidian is cross-platform. smartxhosting.uk runs Plesk on Linux; feature parity is close on Windows but file paths and service names differ.
Q: Is this guide for Plesk Obsidian or an older version?
A: Plesk Obsidian (18.x) is assumed throughout. smartxhosting.uk keeps Plesk on the latest stable branch, so UK customers are always on Obsidian.
Q: How does this feature interact with UK GDPR?
A: Any personal data processed via this feature falls under UK GDPR. Ensure your privacy notice reflects the processing, apply encryption where applicable, and document the processing in your data-processing inventory.
Q: Can I automate this via the Plesk API?
A: Yes — Plesk exposes a CLI and XML/REST APIs for automation. smartxhosting.uk managed hosting allows API access for tasks that do not require root.
Q: How do I access Plesk if I am a smartxhosting.uk customer?
A: Log in to smartxhosting.uk client area → Services → Login to Plesk. SSO takes you straight into the panel.