Flexo Host Guide

Category: Wordpress

  • How to Create a WordPress Staging Site

    Test changes safely by creating a staging environment for your WordPress site.

    What is a Staging Site?

    A staging site is a private copy of your live website where you can safely test changes, updates, and new features without affecting your visitors or breaking your live site.

    Environment Purpose Visibility Database
    Production Live site for visitors Public Live data
    Staging Testing changes Private Copy of live
    Development Building features Private Test data

    Why Use a Staging Site?

    Risk-Free Testing

    Scenario Without Staging With Staging
    Plugin update breaks site Visitors see errors Fix before going live
    Theme change looks wrong Brand damage Test privately first
    Code bug crashes site Revenue loss Catch in testing
    Database corruption Data loss Protected live data

    Common Use Cases

    • Test WordPress core, theme, and plugin updates
    • Preview design and layout changes
    • Debug issues without affecting visitors
    • Train team members on new features
    • Test WooCommerce checkout flows
    • Experiment with new plugins

    Method 1: Hostnin WordPress Toolkit

    The fastest way to create a staging site on Hostnin hosting:

    Step-by-Step Instructions

    1. Log into your cPanel dashboard
    2. Navigate to WordPress Toolkit
    3. Find your website and click Clone
    4. Configure staging options:
    Setting Recommended Value
    Subdomain staging.yoursite.com
    Database Create new (auto)
    Files Copy all
    1. Click Start and wait for completion
    2. Access your staging site at the new URL

    Automatic Features

    • Separate database created automatically
    • Search engines blocked by default
    • Easy push changes to live
    • One-click sync from production

    Method 2: WP Staging Plugin

    Free plugin method for any WordPress host:

    Installation

    # Via WP-CLI
wp plugin install wp-staging --activate

    Or install via WordPress dashboard: Plugins → Add New → Search “WP Staging”

    Creating Staging Site

    1. Go to WP Staging → Create New Staging Site
    2. Name your staging site (e.g., “staging”)
    3. Select files and database tables to clone
    4. Click Start Cloning
    5. Access via yoursite.com/staging

    Plugin Comparison

    Feature WP Staging Free WP Staging Pro Hostnin Toolkit
    Create staging ✓ ✓ ✓
    Push to live ✗ ✓ ✓
    Scheduled backups ✗ ✓ ✓
    External database ✗ ✓ ✓
    Price Free ৳6,000/year Included

    Method 3: Manual Staging Setup

    For advanced users who need full control:

    Step 1: Create Subdomain

    In cPanel → Subdomains:

    • Subdomain: staging
    • Domain: yoursite.com
    • Document Root: /staging

    Step 2: Copy Files

    # Via SSH or File Manager
cp -r /public_html/* /staging/

    Step 3: Create Database Copy

    -- In phpMyAdmin
CREATE DATABASE staging_db;
-- Import production database backup

    Step 4: Update wp-config.php

    define('DB_NAME', 'staging_db');
define('DB_USER', 'staging_user');
define('DB_PASSWORD', 'secure_password');
define('WP_HOME', 'https://staging.yoursite.com');
define('WP_SITEURL', 'https://staging.yoursite.com');

    Step 5: Update URLs in Database

    UPDATE wp_options SET option_value = 'https://staging.yoursite.com' 
WHERE option_name IN ('siteurl', 'home');

UPDATE wp_posts SET post_content = REPLACE(post_content, 
'https://yoursite.com', 'https://staging.yoursite.com');

    Protecting Your Staging Site

    Block Search Engines

    Add to staging robots.txt:

    User-agent: *
Disallow: /

    Password Protection (.htaccess)

    AuthType Basic
AuthName "Staging Site"
AuthUserFile /home/user/.htpasswd
Require valid-user

    WordPress Login Protection

    Add to wp-config.php:

    define('WP_ENVIRONMENT_TYPE', 'staging');

    Best Practices

    Practice Why It Matters
    Sync regularly Keep staging current with production
    Use separate database Prevent data conflicts
    Block search engines Avoid duplicate content issues
    Password protect Keep staging private
    Test thoroughly Catch issues before going live
    Document changes Track what was modified

    Pushing Changes to Live

    Hostnin Toolkit Method

    1. Make changes on staging
    2. Test thoroughly
    3. Click Push to Live in WordPress Toolkit
    4. Select what to push (files, database, or both)
    5. Review and confirm

    Manual Push

    1. Backup live site first
    2. Export staging database
    3. Copy modified files to production
    4. Import database changes
    5. Clear all caches

    Troubleshooting

    Issue Solution
    White screen after cloning Check wp-config.php database settings
    Images not loading Update URLs in database
    Login redirect loop Clear cookies, check site URLs
    Mixed content warnings Update hardcoded URLs to HTTPS

    Conclusion

    A staging site is essential for professional WordPress development. Whether you use Hostnin’s built-in tools, a plugin, or manual setup, always test changes in staging before pushing to production.

    Pro Tip: Set up a staging workflow: Development → Staging → Production. This ensures thorough testing and reduces the risk of breaking your live site.

    Last updated: April 2026 | FlexoHost Technical Team

     

    Written by

    FlexoHost Team

    Technical Writer

  • How to Optimize Your WordPress Database

    How to Optimize Your WordPress Database

    Why Database Optimization Matters

    Your WordPress database grows over time with unnecessary data that slows down every page load. A bloated database can add 1-3 seconds to your load time.

    Common Database Bloat Sources

    Source Growth Rate Impact on Speed
    Post revisions High Medium
    Auto-drafts Medium Low
    Spam comments High Medium
    Transient options Very High High
    Orphaned post meta Medium High
    Expired sessions High Medium
    Unused tables Low Medium

    Real-World Impact

    Database Size Query Time Page Load Impact
    <50MB <0.1s Minimal
    50-200MB 0.1-0.5s Noticeable
    200-500MB 0.5-1.5s Significant
    >500MB >1.5s Critical

    Understanding WordPress Tables

    Core Tables

    Table Purpose Bloat Risk
    wp_posts Posts, pages, revisions High
    wp_postmeta Post metadata Very High
    wp_options Settings, transients High
    wp_comments All comments Medium
    wp_commentmeta Comment metadata Medium
    wp_terms Categories, tags Low
    wp_usermeta User metadata Low

    WooCommerce Tables

    Table Purpose Bloat Risk
    wp_woocommerce_sessions Cart sessions Very High
    wp_wc_orders Order data Medium
    wp_wc_order_stats Analytics High

    Method 1: WP-Optimize Plugin

    The easiest way to clean your database:

    Installation

    wp plugin install wp-optimize --activate

    Recommended Cleanup Settings

    Option Action Frequency
    Post revisions Delete all Weekly
    Auto-drafts Delete all Weekly
    Trashed posts Delete all Weekly
    Spam comments Delete all Daily
    Transients Delete expired Daily
    Pingbacks/Trackbacks Delete all Monthly

    Scheduling Automatic Cleanups

    1. Go to WP-Optimize → Settings
    2. Enable scheduled cleanups
    3. Set frequency (weekly recommended)
    4. Select cleanup options
    5. Save changes

    Method 2: Manual SQL Queries

    For advanced users who prefer direct database access:

    Delete Post Revisions

    DELETE FROM wp_posts WHERE post_type = 'revision';

-- Also clean orphaned meta
DELETE FROM wp_postmeta 
WHERE post_id NOT IN (SELECT ID FROM wp_posts);

    Delete Expired Transients

    DELETE FROM wp_options 
WHERE option_name LIKE '%_transient_%' 
AND option_name NOT LIKE '%_transient_timeout_%';

DELETE FROM wp_options 
WHERE option_name LIKE '%_transient_timeout_%' 
AND option_value < UNIX_TIMESTAMP();

    Clean WooCommerce Sessions

    DELETE FROM wp_woocommerce_sessions 
WHERE session_expiry < UNIX_TIMESTAMP();

    Delete Spam and Trash Comments

    DELETE FROM wp_comments WHERE comment_approved = 'spam';
DELETE FROM wp_comments WHERE comment_approved = 'trash';

-- Clean orphaned comment meta
DELETE FROM wp_commentmeta 
WHERE comment_id NOT IN (SELECT comment_ID FROM wp_comments);

    Optimize All Tables

    -- Run in phpMyAdmin
OPTIMIZE TABLE wp_posts, wp_postmeta, wp_options, 
wp_comments, wp_commentmeta, wp_terms, wp_termmeta;

    Method 3: WP-CLI Commands

    For developers and advanced users:

    Database Optimization

    # Optimize all tables
wp db optimize

# Repair tables
wp db repair

# Check database size
wp db size --tables

    Cleanup Commands

    # Delete all transients
wp transient delete --all

# Delete expired transients only
wp transient delete --expired

# Delete all post revisions
wp post delete $(wp post list --post_type='revision' --format=ids)

# Delete spam comments
wp comment delete $(wp comment list --status=spam --format=ids)

    Bulk Operations

    # Delete revisions older than 30 days
wp post delete $(wp post list --post_type='revision' --date_query='[{"before":"30 days ago"}]' --format=ids)

# Export before cleanup (safety)
wp db export backup-before-cleanup.sql

    Method 4: phpMyAdmin

    Step-by-Step Optimization

    1. Log into cPanel
    2. Open phpMyAdmin
    3. Select your WordPress database
    4. Click “Check All” to select all tables
    5. From dropdown, select “Optimize table”
    6. Wait for completion

    Identifying Large Tables

    SELECT 
  table_name AS 'Table',
  ROUND(data_length / 1024 / 1024, 2) AS 'Data (MB)',
  ROUND(index_length / 1024 / 1024, 2) AS 'Index (MB)',
  ROUND((data_length + index_length) / 1024 / 1024, 2) AS 'Total (MB)'
FROM information_schema.TABLES
WHERE table_schema = 'your_database_name'
ORDER BY (data_length + index_length) DESC;

    Prevention: wp-config.php Settings

    Add these settings to prevent future bloat:

    // Limit post revisions (default: unlimited)
define('WP_POST_REVISIONS', 3);

// Empty trash faster (default: 30 days)
define('EMPTY_TRASH_DAYS', 7);

// Increase autosave interval (default: 60 seconds)
define('AUTOSAVE_INTERVAL', 300);

// Disable post revisions entirely (not recommended)
// define('WP_POST_REVISIONS', false);

    Optimization Schedule

    Task Frequency Method Impact
    Delete spam comments Daily Plugin/Cron Medium
    Clear expired transients Daily Plugin/Cron High
    Delete trashed items Weekly Plugin Medium
    Remove post revisions Weekly Plugin/SQL High
    Optimize tables Monthly phpMyAdmin High
    Full database audit Quarterly Manual High

    Before and After Comparison

    Metric Before Optimization After Optimization
    Database Size 450MB 85MB
    Tables 120 95
    Query Time 1.2s 0.15s
    Page Load 4.5s 1.8s
    TTFB 800ms 200ms

    Troubleshooting

    Issue Cause Solution
    Optimization fails Table corruption Run REPAIR TABLE first
    Slow queries persist Missing indexes Add proper indexes
    Database grows back quickly Plugin issue Audit plugin database usage
    Lock timeout errors Large tables Optimize during low traffic

    Best Practices

    Practice Benefit
    Backup before optimization Safety net
    Optimize during low traffic Prevent locks
    Limit revisions in wp-config Prevent bloat
    Use object caching (Redis) Reduce DB queries
    Regular cleanup schedule Maintain performance
    Monitor database size Catch issues early

    Conclusion

    Regular database optimization is essential for WordPress performance. A clean, optimized database can reduce page load times by 50% or more. Set up automated weekly cleanups and monitor your database size to maintain peak performance.

    Pro Tip: Enable Redis object caching to reduce database queries by up to 80%. Most managed WordPress hosts offer Redis as an add-on or included feature.

    Tags

    WordPressDatabasePerformanceMySQL

  • 10 Ways to Speed Up Your WordPress Website in 2025

    Introduction

    A slow website loses visitors. Studies show that 53% of users abandon sites that take longer than 3 seconds to load. In this comprehensive guide, we’ll explore 10 proven techniques to dramatically speed up your WordPress website.

    Why Website Speed Matters

    Before diving into optimization techniques, let’s understand why speed is crucial:

    • SEO Rankings: Google uses page speed as a ranking factor
    • User Experience: Faster sites have lower bounce rates
    • Conversions: Every second of delay reduces conversions by 7%
    • Mobile Users: 73% of mobile users have encountered slow websites

    1. Use LiteSpeed Hosting

    The foundation of a fast website is quality hosting. LiteSpeed servers are up to 20x faster than traditional Apache servers.

    Why LiteSpeed?

    • Built-in caching at server level
    • HTTP/3 and QUIC support
    • Optimized for WordPress
    • Lower resource usage

    Pro Tip: LiteSpeed Enterprise servers provide up to 20x faster performance compared to Apache for WordPress sites.

    2. Enable Caching

    Caching stores static versions of your pages, reducing server load and speeding up delivery.

    Recommended: LiteSpeed Cache Plugin

    # Install via WP-CLI
wp plugin install litespeed-cache --activate

    Key settings to enable:

    • Page Cache: ON
    • Browser Cache: ON
    • Object Cache: ON (if Redis available)
    • Image Optimization: ON

    3. Optimize Images

    Images often account for 50-80% of a webpage’s size. Optimization is critical.

    Best Practices:

    1. Use WebP format – 25-35% smaller than JPEG
    2. Lazy load images – Only load when visible
    3. Resize images – Don’t upload 4000px images for 800px containers
    4. Use CDN – Serve images from edge locations

    Recommended Tools:

    • ShortPixel (best quality)
    • Imagify (easy to use)
    • EWWW Image Optimizer (free option)

    4. Minimize CSS and JavaScript

    Reduce file sizes by removing unnecessary code.

    // Before minification
function calculateTotal(price, quantity) {
    const subtotal = price * quantity;
    const tax = subtotal * 0.1;
    return subtotal + tax;
}

// After minification
function calculateTotal(e,t){const n=e*t;return n+.1*n}

    5. Use a Content Delivery Network (CDN)

    CDNs cache your content on servers worldwide, reducing latency for global visitors.

    CDN Provider Free Tier Best For
    Cloudflare Yes General use
    BunnyCDN No (cheap) Performance
    KeyCDN No Enterprise

    6. Enable GZIP Compression

    GZIP can reduce file sizes by up to 70%.

    Add to your .htaccess:

    <IfModule mod_deflate.c>
  AddOutputFilterByType DEFLATE text/html text/css application/javascript
</IfModule>

    7. Optimize Your Database

    Over time, WordPress databases accumulate overhead.

    Monthly Maintenance:

    • Delete post revisions
    • Remove spam comments
    • Clean transients
    • Optimize tables

    Use WP-Optimize plugin for automated cleanup.

    8. Reduce HTTP Requests

    Each file requires a separate request. Minimize them:

    • Combine CSS files
    • Combine JavaScript files
    • Use CSS sprites for icons
    • Inline critical CSS

    9. Choose a Fast Theme

    Your theme affects everything. Look for:

    • Clean, optimized code
    • No bloated frameworks
    • Minimal external dependencies
    • Good reviews for speed

    Recommended: GeneratePress, Astra, Kadence

    10. Monitor and Test Regularly

    Use these tools to measure progress:

    • Google PageSpeed Insights – Core Web Vitals
    • GTmetrix – Detailed waterfall analysis
    • Pingdom – Global speed testing
    • WebPageTest – Advanced diagnostics

    Conclusion

    Implementing these 10 optimizations can dramatically improve your WordPress site speed. Start with hosting and caching for the biggest impact, then work through the other techniques.

    Need help optimizing your site? Our team offers free performance audits for all Hostnin customers. Contact support to get started.

Powered by
►
Necessary cookies enable essential site features like secure log-ins and consent preference adjustments. They do not store personal data.
None
►
Functional cookies support features like content sharing on social media, collecting feedback, and enabling third-party tools.
None
►
Analytical cookies track visitor interactions, providing insights on metrics like visitor count, bounce rate, and traffic sources.
None
►
Advertisement cookies deliver personalized ads based on your previous visits and analyze the effectiveness of ad campaigns.
None
Powered by