How to Clean the WordPress Database
summary
Shows a clear, repeatable workflow: diagnose slow time to first byte with Pingdom/Gtmetrix, inspect sizes with Server Status, then dive into phpMyAdmin and raw SQL to rank big keys. Demonstrates a real cleanup that reduces an options table from 252 megabytes to 2 megabytes, finds ~400,000 postmeta rows, and removes plugin junk (example: deleting 14,000 radium rows). Targets: autoload options under 2 MB / 500 rows, remove abandoned plugin tables, and use backups (wp-migrate-db) before deleting.
AI-written summary · about
chapters (17)
- 0:00Intro
- 0:50Who am I
- 5:42What is a database
- 7:36Plugins and tables
- 8:29What causes database problems
- 9:51Speed tests
- 12:38Caching
- 15:45Server Status
- 19:59What causes problems
- 21:18Problem plugins
- 25:08Map
- 27:47SQL
- 30:58Post Meta
- 34:06Meta Keys
- 36:08Iceland and InnoDB
- 37:06Converting to utf8
- 38:51Removing revisions
