~/talk

How to clean up the WordPress Database

Talkat WordCamp Portland 2018 · on Saturday, 2018-11-03· [wordpress, databases]
links:none on file
slides:none on file

Site slow because MySQL loads huge rows not because of hosting; one real case has almost 300 MB of junk in the options table (cleared in five minutes) causing crashes. Use Pingdom/GTmetrix to watch time to first byte and server wait (under 200 ms goal). Inspect with phpMyAdmin or the command line, back up with WP Migrate DB, run SQL to measure wp_options autoload megabytes, and remove large plugin or logging tables; WP‑Optimize helps but isn’t a full fix.

AI-written summary · about

~/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.