~/talk

How to Clean the WordPress Database

Talkat WordCamp Seattle 2018 · 2018-11-10..11-11· [wordpress, web-performance]
links:none on file
slides:none on file

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

  1. 0:00Intro
  2. 0:50Who am I
  3. 5:42What is a database
  4. 7:36Plugins and tables
  5. 8:29What causes database problems
  6. 9:51Speed tests
  7. 12:38Caching
  8. 15:45Server Status
  9. 19:59What causes problems
  10. 21:18Problem plugins
  11. 25:08Map
  12. 27:47SQL
  13. 30:58Post Meta
  14. 34:06Meta Keys
  15. 36:08Iceland and InnoDB
  16. 37:06Converting to utf8
  17. 38:51Removing revisions
~/search
type to search 6,518 conferences, 143,918 speakers and 192,133 talks
~/help
cmdctrl k
search every conference, speaker and series
/
focus the filter search
h
home
c
conferences
s
speakers
e
series
t
light / dark — the status bar button does the same
← →
on a talk: 5 seconds back / forward
0–9
on a talk: jump to 0%–90% of the recording
?
this help
esc
close this, then clear every filter — or just the search, while you are typing in it

Ignored while you are typing. Pages without a filter rail have no search to focus.