WordPress clean up

Sometimes the wp_options table can get really big and bloated. This could be related to poorly written WP plugins or either tons of _transient entries left in the database. Transient entries are usually created to simply store cached information.

This is solved with such sql:

DELETE FROM `wp_options` WHERE `option_name` LIKE ('_transient_%');

Or check the number of not needed records with such sql:

SELECT * FROM `wp_options` WHERE `option_name` LIKE ('_transient_%');

Optimize and repair MySQL tables

  1. Visit PHPMYyAdmin
  2. Select database tables with overhead
  3. Choose "Optimize table" or "Repair table"

Delete obsolete WordPress files:

  • wp-atom.php
  • wp-commentsrss2.php
  • wp-feed.php
  • wp-pass.php
  • wp-rdf.php
  • wp-register.php
  • wp-rss.php
  • wp-rss2.php

Leave a Comment