Published on May 4, 2014
Spring Cleaning Your Site: Dirtless Databases How to Keep Your WordPress Database Squeaky Clean
Adam Soucie • Highforge • Web Developer • Content writer
• All of your site’s data • Pages, posts, comments, etc. • You don’t have a site without it What is WordPress Database?
4 Easy Tips 1. Optimize using MySQL 2. Repair broken tables 3. Prevent/limit revisions 4. Delete excess junk
• Make a database backup • Spend 10 minutes reviewing your site • Set up a development environment if possible BEFORE YOU BEGIN
Optimizing using MySQL 1. Log in to PHPMyAdmin 2. Select “Check Tables Having Overhead” 3. Select “Optimize Table”
• Can be done through PHPMyAdmin • WordPress will repair automatically as of 2.9 • Must be enabled in wp-conﬁg.php Repairing Broken Tables
deﬁne( 'WP_ALLOW_REPAIR', TRUE ); Source: http://premium.wpmudev.org/blog/wordpress-maintenance-101-how-to-optimize-and-repair-database-tables/
Prevent/Limit Revisions 1. Different from autosaves 2. Revisions created every time you save 3. Can be limited or completely prevented 4. Handled in wp-conﬁg.php
deﬁne( 'WP_POST_REVISIONS', X ); where X is the number of revisions or ‘TRUE’ to allow unlimited Source: http://codex.wordpress.org/Revisions
• Expired transients • Spam and unapproved comments • Trashed items (posts, pages, etc.) Cleaning Excess Junk
deﬁne( ‘EMPTY_TRASH_DAYS’, X ); where X is the number of days Source: http://www.wpexplorer.com/optimize-wordpress-database/
The Transients Debate 1. Created with the Transient API 2. Supposed to expire and be deleted 3. Relied upon by lazy developers 4. WordPress only wipes them on Database Upgrades
The Plugins 1. WP-Optimize 2. purge-transients https://github.com/Seebz/Snippets/tree/master/Wordpress/ plugins/purge-transients
Sources: The WordPress Codex WP Tavern (wptavern.com) WP Explorer (wpexplorer.com) Stu Miller (stumiller.me)
More info: www.adamsoucie.com www.highforge.com Illustrations by: Tina Fiume
Rank tracker is a tool that helps everyone to find the traffic which a particular ...
Cartes interactives, frises chronologiques, diaporamas, carte Google Streetview in...
... I gave a talk on keeping the database clean. ... If you have any questions about the information ... How to Keep Your WordPress Database Squeaky Clean.
If you’ve been using WordPress for ... you make cleaning your databases even easier. Database ... ways to keep your database squeaky clean?
... Content and Dirtless Databases: How to Keep Your ... include Clean Content and Dirtless Databases: How to Keep Your WordPress Database Squeaky Clean.
WP Clean Up can help us to clean up the wordpress database by removing ... WP Clean Up" where you can ... to keep your database clean and ...
Simple but effective plugin allows you to extensively clean up your WordPress database and optimize it without doing manual queries.
... to create or delete databases. You must call ... ineviways you can keep your database squeaky clean with ... plugins. in his article Clean Up WordPress ...
10 Tips for Keeping a Squeaky Clean WordPress (and Multisite!) Database. ... ways you can keep your database squeaky clean with ... in SQL Databases with ...
How to Backup and Import a Very Large WordPress MySQL Database. ... stopped to keep you from ... For Keeping a Squeaky Clean WordPress Database.