Skip to content

Instantly share code, notes, and snippets.

@thetwopct

thetwopct/query.sql

Created July 5, 2019 03:56
Show Gist options
  • Save thetwopct/a1fa25ed76578cf3f129b386cb4e0e09 to your computer and use it in GitHub Desktop.
Save thetwopct/a1fa25ed76578cf3f129b386cb4e0e09 to your computer and use it in GitHub Desktop.
Download ZIP
Checking autoloaded data in WordPress MySQL
Raw
query.sql
# Run this in SQL query of PHPmyAdmin
# Show the size of all the autoloaded data - this is loaded on *every* page of your site
SELECT SUM(LENGTH(option_value)) as autoload_size FROM wp_options WHERE autoload='yes';
# Show what is loading in autoload
SELECT LENGTH(option_value),option_name FROM wp_options WHERE autoload='yes' ORDER BY length(option_value) DESC LIMIT 20;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment