WordPress DB Optimization: Large wp_postmeta Rebuild
Budget: $30 – $250 USD
Project Title: Urgent WordPress Database Optimization: Large wp_postmeta Table (>1GB) Requiring InnoDB Alter/Rebuild
Project Overview:
I run a high-traffic WordPress site where the core metadata table, wp_postmeta (or lhp_postmeta in my configuration), is currently >1GB.
We have already performed extensive cleanup (removed orphaned metadata, spam, post revisions, and large plugin remnants from WPML and Imagify). However, the size has not reduced significantly. Our diagnosis suggests the remaining size is due to excessive InnoDB row overhead and fragmented indices, resulting from a high row count (hundreds of thousands of rows of necessary configuration data).
We need an experienced WordPress/MySQL DBA to safely execute a final, high-impact optimization step.
Key Requirement and Goal:
The primary goal is to execute a full table rebuild to eliminate fragmentation and optimize the storage format, thereby significantly reducing the table size.
The successful freelancer must be able to perform and verify the following command:
SQL
ALTER TABLE lhp_postmeta ENGINE=InnoDB ROW_FORMAT=DYNAMIC;
Scope of Work:
Full Backup: Take a complete backup of the entire database before making any changes.
Verification: Verify the current lhp_postmeta table size and its ENGINE (must be InnoDB) and ROW_FORMAT.
Execution: Safely execute the ALTER TABLE command (which will lock the table for a period of time, estimated to be 5–15 minutes).
Post-Optimization Check:
Verify the table size is significantly reduced (Targeting below 500 MB or demonstrating a large reduction).
Verify the WordPress website is fully functional (styles, pages, media attachments, and Elementor content loading correctly).
Reporting: Provide a brief report detailing the size reduction and the steps taken.
Required Skills:
Expert knowledge of WordPress database structure.
Proficiency in MySQL/MariaDB database administration.
Experience with ALTER TABLE for table rebuilding and Innodb optimization.
Ability to work safely with live production databases.
Please provide your estimated fixed price for this job, and confirmation that you understand the task requires ALTER TABLE execution, not just simple DELETE queries.
Project Overview:
I run a high-traffic WordPress site where the core metadata table, wp_postmeta (or lhp_postmeta in my configuration), is currently >1GB.
We have already performed extensive cleanup (removed orphaned metadata, spam, post revisions, and large plugin remnants from WPML and Imagify). However, the size has not reduced significantly. Our diagnosis suggests the remaining size is due to excessive InnoDB row overhead and fragmented indices, resulting from a high row count (hundreds of thousands of rows of necessary configuration data).
We need an experienced WordPress/MySQL DBA to safely execute a final, high-impact optimization step.
Key Requirement and Goal:
The primary goal is to execute a full table rebuild to eliminate fragmentation and optimize the storage format, thereby significantly reducing the table size.
The successful freelancer must be able to perform and verify the following command:
SQL
ALTER TABLE lhp_postmeta ENGINE=InnoDB ROW_FORMAT=DYNAMIC;
Scope of Work:
Full Backup: Take a complete backup of the entire database before making any changes.
Verification: Verify the current lhp_postmeta table size and its ENGINE (must be InnoDB) and ROW_FORMAT.
Execution: Safely execute the ALTER TABLE command (which will lock the table for a period of time, estimated to be 5–15 minutes).
Post-Optimization Check:
Verify the table size is significantly reduced (Targeting below 500 MB or demonstrating a large reduction).
Verify the WordPress website is fully functional (styles, pages, media attachments, and Elementor content loading correctly).
Reporting: Provide a brief report detailing the size reduction and the steps taken.
Required Skills:
Expert knowledge of WordPress database structure.
Proficiency in MySQL/MariaDB database administration.
Experience with ALTER TABLE for table rebuilding and Innodb optimization.
Ability to work safely with live production databases.
Please provide your estimated fixed price for this job, and confirmation that you understand the task requires ALTER TABLE execution, not just simple DELETE queries.
Related categories:
PHP
SQL
WordPress
MySQL
HTML
Database Administration
Database Management
Data Backup