Dirtless Databases - How to Keep Your WordPress Database Squeaky Clean

33 %
67 %
Information about Dirtless Databases - How to Keep Your WordPress Database Squeaky Clean
Internet

Published on May 4, 2014

Author: adamsoucie

Source: slideshare.net

Description

Is your site still running slow, like it's just coming out of hibernation? Have you tried every optimization trick from cacheing to throwing cash at it? It might just be your database dragging you down. For both dedicated developers and beginner bloggers, we'll show you MySQL commands, WordPress functions, and easy-to-use plugins that'll get your databases slimmed down and ready for swimsuit season

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-config.php Repairing Broken Tables

define( '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-config.php

define( '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

define( ‘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

Any questions?

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

Add a comment

Related presentations

Online rank tracker!

Online rank tracker!

October 20, 2014

Rank tracker is a tool that helps everyone to find the traffic which a particular ...

Facebook y sus avances

Facebook y sus avances

November 11, 2014

facebook y sus avances

Preguntas Investigación

Preguntas Investigación

November 11, 2014

es una presentación de preguntas interesantes

Cartes interactives, frises chronologiques, diaporamas, carte Google Streetview in...

Related pages

Dirtless Databases - How to Keep Your WordPress Database ...

... 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.
Read more

10 Tips for Keeping a Squeaky Clean WordPress (and ...

If you’ve been using WordPress for ... you make cleaning your databases even easier. Database ... ways to keep your database squeaky clean?
Read more

IDEAS to Host WordPress Meet Up May 3, 2014 - IDEAS, Media ...

... Content and Dirtless Databases: How to Keep Your ... include Clean Content and Dirtless Databases: How to Keep Your WordPress Database Squeaky Clean.
Read more

WP Clean Up — WordPress Plugins - Blog Tool, Publishing ...

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 ...
Read more

WP-Optimize — WordPress Plugins - Blog Tool, Publishing ...

Simple but effective plugin allows you to extensively clean up your WordPress database and optimize it without doing manual queries.
Read more

Mysql Commands Delete Database - WordPress.com

... to create or delete databases. You must call ... ineviways you can keep your database squeaky clean with ... plugins. in his article Clean Up WordPress ...
Read more

10 Tips for Keeping a Squeaky Clean WordPress (and ...

10 Tips for Keeping a Squeaky Clean WordPress (and Multisite!) Database. ... ways you can keep your database squeaky clean with ... in SQL Databases with ...
Read more

How to Backup & Import Large WordPress MySQL Databases ...

How to Backup and Import a Very Large WordPress MySQL Database. ... stopped to keep you from ... For Keeping a Squeaky Clean WordPress Database.
Read more