Key-value store for site settings, plugin options, and transient data.<\/p>
option_id<\/code><\/td>bigint(20) unsigned<\/td>NO<\/td>auto_increment<\/td>Unique identifier<\/td><\/tr>option_name<\/code><\/td>varchar(191)<\/td>NO<\/td>”<\/td>Option key (unique)<\/td><\/tr>option_value<\/code><\/td>longtext<\/td>NO<\/td>NULL<\/td>Option value (can be serialized)<\/td><\/tr>autoload<\/code><\/td>varchar(20)<\/td>NO<\/td>‘yes’<\/td>Whether to load on every page<\/td><\/tr><\/tbody><\/table><\/figure>Indexes<\/h2>Key Name<\/th>Columns<\/th>Unique<\/th>Purpose<\/th><\/tr><\/thead>PRIMARY<\/code><\/td>option_id<\/td>Yes<\/td>Primary key<\/td><\/tr>option_name<\/code><\/td>option_name<\/td>Yes<\/td>Unique constraint + lookup<\/td><\/tr>autoload<\/code><\/td>autoload<\/td>No<\/td>Filter autoloaded options<\/td><\/tr><\/tbody><\/table><\/figure>Foreign Key Relationships<\/h2>None\u2014standalone configuration table.<\/p>Autoload Behavior<\/h2>Options with autoload = 'yes'<\/code> are loaded into memory on every WordPress request via:<\/p>php<\/span><\/use><\/svg><\/button><\/div>wp_load_alloptions()<\/code><\/pre><\/div>This is cached in object cache. Setting autoload = 'no'<\/code> for rarely-used options improves performance.<\/p>Core Option Categories<\/h2>Site Settings<\/h3>Option<\/th>Description<\/th><\/tr><\/thead>siteurl<\/code><\/td>WordPress installation URL<\/td><\/tr>home<\/code><\/td>Site homepage URL<\/td><\/tr>blogname<\/code><\/td>Site title<\/td><\/tr>blogdescription<\/code><\/td>Site tagline<\/td><\/tr>admin_email<\/code><\/td>Admin email address<\/td><\/tr>timezone_string<\/code><\/td>Timezone setting<\/td><\/tr>date_format<\/code><\/td>Date display format<\/td><\/tr>time_format<\/code><\/td>Time display format<\/td><\/tr><\/tbody><\/table><\/figure>Reading\/Writing<\/h3>Option<\/th>Description<\/th><\/tr><\/thead>posts_per_page<\/code><\/td>Posts per archive page<\/td><\/tr>posts_per_rss<\/code><\/td>Posts per RSS feed<\/td><\/tr>show_on_front<\/code><\/td>‘posts’ or ‘page’<\/td><\/tr>page_on_front<\/code><\/td>Static front page ID<\/td><\/tr>page_for_posts<\/code><\/td>Blog page ID<\/td><\/tr>default_category<\/code><\/td>Default post category<\/td><\/tr>default_comment_status<\/code><\/td>Default comment status<\/td><\/tr><\/tbody><\/table><\/figure>Permalinks<\/h3>Option<\/th>Description<\/th><\/tr><\/thead>permalink_structure<\/code><\/td>Permalink pattern<\/td><\/tr>category_base<\/code><\/td>Category URL prefix<\/td><\/tr>tag_base<\/code><\/td>Tag URL prefix<\/td><\/tr>rewrite_rules<\/code><\/td>Serialized rewrite rules<\/td><\/tr><\/tbody><\/table><\/figure>Theme\/Appearance<\/h3>Option<\/th>Description<\/th><\/tr><\/thead>template<\/code><\/td>Active theme directory<\/td><\/tr>stylesheet<\/code><\/td>Active child theme directory<\/td><\/tr>current_theme<\/code><\/td>Theme display name<\/td><\/tr>sidebars_widgets<\/code><\/td>Widget assignments<\/td><\/tr>theme_mods_{theme}<\/code><\/td>Theme customization<\/td><\/tr>nav_menu_options<\/code><\/td>Navigation menu settings<\/td><\/tr><\/tbody><\/table><\/figure>Cron & Transients<\/h3>Pattern<\/th>Description<\/th><\/tr><\/thead>cron<\/code><\/td>Scheduled tasks<\/td><\/tr>_transient_{name}<\/code><\/td>Cached data<\/td><\/tr>_transient_timeout_{name}<\/code><\/td>Transient expiration<\/td><\/tr>_site_transient_{name}<\/code><\/td>Network transient<\/td><\/tr><\/tbody><\/table><\/figure>Plugin Settings<\/h3>Plugins typically use patterns like:<\/p>{plugin_slug}_settings<\/code><\/li>{plugin_slug}_options<\/code><\/li>{plugin_slug}_version<\/code><\/li><\/ul>Common Queries<\/h2>Get option value<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_value \nFROM wp_options \nWHERE option_name = 'siteurl';<\/code><\/pre><\/div>Get all autoloaded options<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_name, option_value \nFROM wp_options \nWHERE autoload = 'yes';<\/code><\/pre><\/div>Calculate autoload size<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT \n SUM(LENGTH(option_value)) as total_bytes,\n COUNT(*) as option_count\nFROM wp_options \nWHERE autoload = 'yes';<\/code><\/pre><\/div>Find large options<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_name, LENGTH(option_value) as size_bytes\nFROM wp_options \nORDER BY size_bytes DESC \nLIMIT 20;<\/code><\/pre><\/div>Find expired transients<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT o.option_name, o.option_value\nFROM wp_options o\nJOIN wp_options t ON t.option_name = CONCAT('_transient_timeout_', \n SUBSTRING(o.option_name, 12))\nWHERE o.option_name LIKE '_transient_%'\n AND o.option_name NOT LIKE '_transient_timeout_%'\n AND t.option_value < UNIX_TIMESTAMP();<\/code><\/pre><\/div>Delete expired transients<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>DELETE a, b FROM wp_options a\nLEFT JOIN wp_options b ON b.option_name = CONCAT('_transient_timeout_', \n SUBSTRING(a.option_name, 12))\nWHERE a.option_name LIKE '_transient_%'\n AND a.option_name NOT LIKE '_transient_timeout_%'\n AND b.option_value IS NOT NULL\n AND b.option_value < UNIX_TIMESTAMP();<\/code><\/pre><\/div>Optimize autoload<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>-- Find options that shouldn't autoload\nSELECT option_name, LENGTH(option_value) as size\nFROM wp_options \nWHERE autoload = 'yes' \n AND LENGTH(option_value) > 10000\nORDER BY size DESC;\n\n-- Disable autoload for specific option\nUPDATE wp_options \nSET autoload = 'no' \nWHERE option_name = 'large_serialized_option';<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_option( $option, $default )<\/code> – Get option value<\/li>add_option( $option, $value, $deprecated, $autoload )<\/code> – Add option<\/li>update_option( $option, $value, $autoload )<\/code> – Update\/add option<\/li>delete_option( $option )<\/code> – Delete option<\/li>set_transient( $name, $value, $expiration )<\/code> – Set transient<\/li>get_transient( $name )<\/code> – Get transient<\/li>delete_transient( $name )<\/code> – Delete transient<\/li><\/ul>Performance Notes<\/h2>Autoload Optimization<\/h3>Large sites should audit autoloaded options:<\/p>sql<\/span><\/use><\/svg><\/button><\/div>SELECT SUM(LENGTH(option_value))\/1024 as kb FROM wp_options WHERE autoload='yes';<\/code><\/pre><\/div>Target: Keep autoload under 1MB total.<\/p>Transient Cleanup<\/h3>Transients without expiration never auto-delete. Periodically clean:<\/p>php<\/span>
option_name<\/code><\/td>varchar(191)<\/td>NO<\/td>”<\/td>Option key (unique)<\/td><\/tr>option_value<\/code><\/td>longtext<\/td>NO<\/td>NULL<\/td>Option value (can be serialized)<\/td><\/tr>autoload<\/code><\/td>varchar(20)<\/td>NO<\/td>‘yes’<\/td>Whether to load on every page<\/td><\/tr><\/tbody><\/table><\/figure>Indexes<\/h2>Key Name<\/th>Columns<\/th>Unique<\/th>Purpose<\/th><\/tr><\/thead>PRIMARY<\/code><\/td>option_id<\/td>Yes<\/td>Primary key<\/td><\/tr>option_name<\/code><\/td>option_name<\/td>Yes<\/td>Unique constraint + lookup<\/td><\/tr>autoload<\/code><\/td>autoload<\/td>No<\/td>Filter autoloaded options<\/td><\/tr><\/tbody><\/table><\/figure>Foreign Key Relationships<\/h2>None\u2014standalone configuration table.<\/p>Autoload Behavior<\/h2>Options with autoload = 'yes'<\/code> are loaded into memory on every WordPress request via:<\/p>php<\/span><\/use><\/svg><\/button><\/div>wp_load_alloptions()<\/code><\/pre><\/div>This is cached in object cache. Setting autoload = 'no'<\/code> for rarely-used options improves performance.<\/p>Core Option Categories<\/h2>Site Settings<\/h3>Option<\/th>Description<\/th><\/tr><\/thead>siteurl<\/code><\/td>WordPress installation URL<\/td><\/tr>home<\/code><\/td>Site homepage URL<\/td><\/tr>blogname<\/code><\/td>Site title<\/td><\/tr>blogdescription<\/code><\/td>Site tagline<\/td><\/tr>admin_email<\/code><\/td>Admin email address<\/td><\/tr>timezone_string<\/code><\/td>Timezone setting<\/td><\/tr>date_format<\/code><\/td>Date display format<\/td><\/tr>time_format<\/code><\/td>Time display format<\/td><\/tr><\/tbody><\/table><\/figure>Reading\/Writing<\/h3>Option<\/th>Description<\/th><\/tr><\/thead>posts_per_page<\/code><\/td>Posts per archive page<\/td><\/tr>posts_per_rss<\/code><\/td>Posts per RSS feed<\/td><\/tr>show_on_front<\/code><\/td>‘posts’ or ‘page’<\/td><\/tr>page_on_front<\/code><\/td>Static front page ID<\/td><\/tr>page_for_posts<\/code><\/td>Blog page ID<\/td><\/tr>default_category<\/code><\/td>Default post category<\/td><\/tr>default_comment_status<\/code><\/td>Default comment status<\/td><\/tr><\/tbody><\/table><\/figure>Permalinks<\/h3>Option<\/th>Description<\/th><\/tr><\/thead>permalink_structure<\/code><\/td>Permalink pattern<\/td><\/tr>category_base<\/code><\/td>Category URL prefix<\/td><\/tr>tag_base<\/code><\/td>Tag URL prefix<\/td><\/tr>rewrite_rules<\/code><\/td>Serialized rewrite rules<\/td><\/tr><\/tbody><\/table><\/figure>Theme\/Appearance<\/h3>Option<\/th>Description<\/th><\/tr><\/thead>template<\/code><\/td>Active theme directory<\/td><\/tr>stylesheet<\/code><\/td>Active child theme directory<\/td><\/tr>current_theme<\/code><\/td>Theme display name<\/td><\/tr>sidebars_widgets<\/code><\/td>Widget assignments<\/td><\/tr>theme_mods_{theme}<\/code><\/td>Theme customization<\/td><\/tr>nav_menu_options<\/code><\/td>Navigation menu settings<\/td><\/tr><\/tbody><\/table><\/figure>Cron & Transients<\/h3>Pattern<\/th>Description<\/th><\/tr><\/thead>cron<\/code><\/td>Scheduled tasks<\/td><\/tr>_transient_{name}<\/code><\/td>Cached data<\/td><\/tr>_transient_timeout_{name}<\/code><\/td>Transient expiration<\/td><\/tr>_site_transient_{name}<\/code><\/td>Network transient<\/td><\/tr><\/tbody><\/table><\/figure>Plugin Settings<\/h3>Plugins typically use patterns like:<\/p>{plugin_slug}_settings<\/code><\/li>{plugin_slug}_options<\/code><\/li>{plugin_slug}_version<\/code><\/li><\/ul>Common Queries<\/h2>Get option value<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_value \nFROM wp_options \nWHERE option_name = 'siteurl';<\/code><\/pre><\/div>Get all autoloaded options<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_name, option_value \nFROM wp_options \nWHERE autoload = 'yes';<\/code><\/pre><\/div>Calculate autoload size<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT \n SUM(LENGTH(option_value)) as total_bytes,\n COUNT(*) as option_count\nFROM wp_options \nWHERE autoload = 'yes';<\/code><\/pre><\/div>Find large options<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_name, LENGTH(option_value) as size_bytes\nFROM wp_options \nORDER BY size_bytes DESC \nLIMIT 20;<\/code><\/pre><\/div>Find expired transients<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT o.option_name, o.option_value\nFROM wp_options o\nJOIN wp_options t ON t.option_name = CONCAT('_transient_timeout_', \n SUBSTRING(o.option_name, 12))\nWHERE o.option_name LIKE '_transient_%'\n AND o.option_name NOT LIKE '_transient_timeout_%'\n AND t.option_value < UNIX_TIMESTAMP();<\/code><\/pre><\/div>Delete expired transients<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>DELETE a, b FROM wp_options a\nLEFT JOIN wp_options b ON b.option_name = CONCAT('_transient_timeout_', \n SUBSTRING(a.option_name, 12))\nWHERE a.option_name LIKE '_transient_%'\n AND a.option_name NOT LIKE '_transient_timeout_%'\n AND b.option_value IS NOT NULL\n AND b.option_value < UNIX_TIMESTAMP();<\/code><\/pre><\/div>Optimize autoload<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>-- Find options that shouldn't autoload\nSELECT option_name, LENGTH(option_value) as size\nFROM wp_options \nWHERE autoload = 'yes' \n AND LENGTH(option_value) > 10000\nORDER BY size DESC;\n\n-- Disable autoload for specific option\nUPDATE wp_options \nSET autoload = 'no' \nWHERE option_name = 'large_serialized_option';<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_option( $option, $default )<\/code> – Get option value<\/li>add_option( $option, $value, $deprecated, $autoload )<\/code> – Add option<\/li>update_option( $option, $value, $autoload )<\/code> – Update\/add option<\/li>delete_option( $option )<\/code> – Delete option<\/li>set_transient( $name, $value, $expiration )<\/code> – Set transient<\/li>get_transient( $name )<\/code> – Get transient<\/li>delete_transient( $name )<\/code> – Delete transient<\/li><\/ul>Performance Notes<\/h2>Autoload Optimization<\/h3>Large sites should audit autoloaded options:<\/p>sql<\/span><\/use><\/svg><\/button><\/div>SELECT SUM(LENGTH(option_value))\/1024 as kb FROM wp_options WHERE autoload='yes';<\/code><\/pre><\/div>Target: Keep autoload under 1MB total.<\/p>Transient Cleanup<\/h3>Transients without expiration never auto-delete. Periodically clean:<\/p>php<\/span>
option_value<\/code><\/td>longtext<\/td>NO<\/td>NULL<\/td>Option value (can be serialized)<\/td><\/tr>autoload<\/code><\/td>varchar(20)<\/td>NO<\/td>‘yes’<\/td>Whether to load on every page<\/td><\/tr><\/tbody><\/table><\/figure>Indexes<\/h2>Key Name<\/th>Columns<\/th>Unique<\/th>Purpose<\/th><\/tr><\/thead>PRIMARY<\/code><\/td>option_id<\/td>Yes<\/td>Primary key<\/td><\/tr>option_name<\/code><\/td>option_name<\/td>Yes<\/td>Unique constraint + lookup<\/td><\/tr>autoload<\/code><\/td>autoload<\/td>No<\/td>Filter autoloaded options<\/td><\/tr><\/tbody><\/table><\/figure>Foreign Key Relationships<\/h2>None\u2014standalone configuration table.<\/p>Autoload Behavior<\/h2>Options with autoload = 'yes'<\/code> are loaded into memory on every WordPress request via:<\/p>php<\/span><\/use><\/svg><\/button><\/div>wp_load_alloptions()<\/code><\/pre><\/div>This is cached in object cache. Setting autoload = 'no'<\/code> for rarely-used options improves performance.<\/p>Core Option Categories<\/h2>Site Settings<\/h3>Option<\/th>Description<\/th><\/tr><\/thead>siteurl<\/code><\/td>WordPress installation URL<\/td><\/tr>home<\/code><\/td>Site homepage URL<\/td><\/tr>blogname<\/code><\/td>Site title<\/td><\/tr>blogdescription<\/code><\/td>Site tagline<\/td><\/tr>admin_email<\/code><\/td>Admin email address<\/td><\/tr>timezone_string<\/code><\/td>Timezone setting<\/td><\/tr>date_format<\/code><\/td>Date display format<\/td><\/tr>time_format<\/code><\/td>Time display format<\/td><\/tr><\/tbody><\/table><\/figure>Reading\/Writing<\/h3>Option<\/th>Description<\/th><\/tr><\/thead>posts_per_page<\/code><\/td>Posts per archive page<\/td><\/tr>posts_per_rss<\/code><\/td>Posts per RSS feed<\/td><\/tr>show_on_front<\/code><\/td>‘posts’ or ‘page’<\/td><\/tr>page_on_front<\/code><\/td>Static front page ID<\/td><\/tr>page_for_posts<\/code><\/td>Blog page ID<\/td><\/tr>default_category<\/code><\/td>Default post category<\/td><\/tr>default_comment_status<\/code><\/td>Default comment status<\/td><\/tr><\/tbody><\/table><\/figure>Permalinks<\/h3>Option<\/th>Description<\/th><\/tr><\/thead>permalink_structure<\/code><\/td>Permalink pattern<\/td><\/tr>category_base<\/code><\/td>Category URL prefix<\/td><\/tr>tag_base<\/code><\/td>Tag URL prefix<\/td><\/tr>rewrite_rules<\/code><\/td>Serialized rewrite rules<\/td><\/tr><\/tbody><\/table><\/figure>Theme\/Appearance<\/h3>Option<\/th>Description<\/th><\/tr><\/thead>template<\/code><\/td>Active theme directory<\/td><\/tr>stylesheet<\/code><\/td>Active child theme directory<\/td><\/tr>current_theme<\/code><\/td>Theme display name<\/td><\/tr>sidebars_widgets<\/code><\/td>Widget assignments<\/td><\/tr>theme_mods_{theme}<\/code><\/td>Theme customization<\/td><\/tr>nav_menu_options<\/code><\/td>Navigation menu settings<\/td><\/tr><\/tbody><\/table><\/figure>Cron & Transients<\/h3>Pattern<\/th>Description<\/th><\/tr><\/thead>cron<\/code><\/td>Scheduled tasks<\/td><\/tr>_transient_{name}<\/code><\/td>Cached data<\/td><\/tr>_transient_timeout_{name}<\/code><\/td>Transient expiration<\/td><\/tr>_site_transient_{name}<\/code><\/td>Network transient<\/td><\/tr><\/tbody><\/table><\/figure>Plugin Settings<\/h3>Plugins typically use patterns like:<\/p>{plugin_slug}_settings<\/code><\/li>{plugin_slug}_options<\/code><\/li>{plugin_slug}_version<\/code><\/li><\/ul>Common Queries<\/h2>Get option value<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_value \nFROM wp_options \nWHERE option_name = 'siteurl';<\/code><\/pre><\/div>Get all autoloaded options<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_name, option_value \nFROM wp_options \nWHERE autoload = 'yes';<\/code><\/pre><\/div>Calculate autoload size<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT \n SUM(LENGTH(option_value)) as total_bytes,\n COUNT(*) as option_count\nFROM wp_options \nWHERE autoload = 'yes';<\/code><\/pre><\/div>Find large options<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_name, LENGTH(option_value) as size_bytes\nFROM wp_options \nORDER BY size_bytes DESC \nLIMIT 20;<\/code><\/pre><\/div>Find expired transients<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT o.option_name, o.option_value\nFROM wp_options o\nJOIN wp_options t ON t.option_name = CONCAT('_transient_timeout_', \n SUBSTRING(o.option_name, 12))\nWHERE o.option_name LIKE '_transient_%'\n AND o.option_name NOT LIKE '_transient_timeout_%'\n AND t.option_value < UNIX_TIMESTAMP();<\/code><\/pre><\/div>Delete expired transients<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>DELETE a, b FROM wp_options a\nLEFT JOIN wp_options b ON b.option_name = CONCAT('_transient_timeout_', \n SUBSTRING(a.option_name, 12))\nWHERE a.option_name LIKE '_transient_%'\n AND a.option_name NOT LIKE '_transient_timeout_%'\n AND b.option_value IS NOT NULL\n AND b.option_value < UNIX_TIMESTAMP();<\/code><\/pre><\/div>Optimize autoload<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>-- Find options that shouldn't autoload\nSELECT option_name, LENGTH(option_value) as size\nFROM wp_options \nWHERE autoload = 'yes' \n AND LENGTH(option_value) > 10000\nORDER BY size DESC;\n\n-- Disable autoload for specific option\nUPDATE wp_options \nSET autoload = 'no' \nWHERE option_name = 'large_serialized_option';<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_option( $option, $default )<\/code> – Get option value<\/li>add_option( $option, $value, $deprecated, $autoload )<\/code> – Add option<\/li>update_option( $option, $value, $autoload )<\/code> – Update\/add option<\/li>delete_option( $option )<\/code> – Delete option<\/li>set_transient( $name, $value, $expiration )<\/code> – Set transient<\/li>get_transient( $name )<\/code> – Get transient<\/li>delete_transient( $name )<\/code> – Delete transient<\/li><\/ul>Performance Notes<\/h2>Autoload Optimization<\/h3>Large sites should audit autoloaded options:<\/p>sql<\/span><\/use><\/svg><\/button><\/div>SELECT SUM(LENGTH(option_value))\/1024 as kb FROM wp_options WHERE autoload='yes';<\/code><\/pre><\/div>Target: Keep autoload under 1MB total.<\/p>Transient Cleanup<\/h3>Transients without expiration never auto-delete. Periodically clean:<\/p>php<\/span>
autoload<\/code><\/td>varchar(20)<\/td>NO<\/td>‘yes’<\/td>Whether to load on every page<\/td><\/tr><\/tbody><\/table><\/figure>Indexes<\/h2>Key Name<\/th>Columns<\/th>Unique<\/th>Purpose<\/th><\/tr><\/thead>PRIMARY<\/code><\/td>option_id<\/td>Yes<\/td>Primary key<\/td><\/tr>option_name<\/code><\/td>option_name<\/td>Yes<\/td>Unique constraint + lookup<\/td><\/tr>autoload<\/code><\/td>autoload<\/td>No<\/td>Filter autoloaded options<\/td><\/tr><\/tbody><\/table><\/figure>Foreign Key Relationships<\/h2>None\u2014standalone configuration table.<\/p>Autoload Behavior<\/h2>Options with autoload = 'yes'<\/code> are loaded into memory on every WordPress request via:<\/p>php<\/span><\/use><\/svg><\/button><\/div>wp_load_alloptions()<\/code><\/pre><\/div>This is cached in object cache. Setting autoload = 'no'<\/code> for rarely-used options improves performance.<\/p>Core Option Categories<\/h2>Site Settings<\/h3>Option<\/th>Description<\/th><\/tr><\/thead>siteurl<\/code><\/td>WordPress installation URL<\/td><\/tr>home<\/code><\/td>Site homepage URL<\/td><\/tr>blogname<\/code><\/td>Site title<\/td><\/tr>blogdescription<\/code><\/td>Site tagline<\/td><\/tr>admin_email<\/code><\/td>Admin email address<\/td><\/tr>timezone_string<\/code><\/td>Timezone setting<\/td><\/tr>date_format<\/code><\/td>Date display format<\/td><\/tr>time_format<\/code><\/td>Time display format<\/td><\/tr><\/tbody><\/table><\/figure>Reading\/Writing<\/h3>Option<\/th>Description<\/th><\/tr><\/thead>posts_per_page<\/code><\/td>Posts per archive page<\/td><\/tr>posts_per_rss<\/code><\/td>Posts per RSS feed<\/td><\/tr>show_on_front<\/code><\/td>‘posts’ or ‘page’<\/td><\/tr>page_on_front<\/code><\/td>Static front page ID<\/td><\/tr>page_for_posts<\/code><\/td>Blog page ID<\/td><\/tr>default_category<\/code><\/td>Default post category<\/td><\/tr>default_comment_status<\/code><\/td>Default comment status<\/td><\/tr><\/tbody><\/table><\/figure>Permalinks<\/h3>Option<\/th>Description<\/th><\/tr><\/thead>permalink_structure<\/code><\/td>Permalink pattern<\/td><\/tr>category_base<\/code><\/td>Category URL prefix<\/td><\/tr>tag_base<\/code><\/td>Tag URL prefix<\/td><\/tr>rewrite_rules<\/code><\/td>Serialized rewrite rules<\/td><\/tr><\/tbody><\/table><\/figure>Theme\/Appearance<\/h3>Option<\/th>Description<\/th><\/tr><\/thead>template<\/code><\/td>Active theme directory<\/td><\/tr>stylesheet<\/code><\/td>Active child theme directory<\/td><\/tr>current_theme<\/code><\/td>Theme display name<\/td><\/tr>sidebars_widgets<\/code><\/td>Widget assignments<\/td><\/tr>theme_mods_{theme}<\/code><\/td>Theme customization<\/td><\/tr>nav_menu_options<\/code><\/td>Navigation menu settings<\/td><\/tr><\/tbody><\/table><\/figure>Cron & Transients<\/h3>Pattern<\/th>Description<\/th><\/tr><\/thead>cron<\/code><\/td>Scheduled tasks<\/td><\/tr>_transient_{name}<\/code><\/td>Cached data<\/td><\/tr>_transient_timeout_{name}<\/code><\/td>Transient expiration<\/td><\/tr>_site_transient_{name}<\/code><\/td>Network transient<\/td><\/tr><\/tbody><\/table><\/figure>Plugin Settings<\/h3>Plugins typically use patterns like:<\/p>{plugin_slug}_settings<\/code><\/li>{plugin_slug}_options<\/code><\/li>{plugin_slug}_version<\/code><\/li><\/ul>Common Queries<\/h2>Get option value<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_value \nFROM wp_options \nWHERE option_name = 'siteurl';<\/code><\/pre><\/div>Get all autoloaded options<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_name, option_value \nFROM wp_options \nWHERE autoload = 'yes';<\/code><\/pre><\/div>Calculate autoload size<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT \n SUM(LENGTH(option_value)) as total_bytes,\n COUNT(*) as option_count\nFROM wp_options \nWHERE autoload = 'yes';<\/code><\/pre><\/div>Find large options<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_name, LENGTH(option_value) as size_bytes\nFROM wp_options \nORDER BY size_bytes DESC \nLIMIT 20;<\/code><\/pre><\/div>Find expired transients<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT o.option_name, o.option_value\nFROM wp_options o\nJOIN wp_options t ON t.option_name = CONCAT('_transient_timeout_', \n SUBSTRING(o.option_name, 12))\nWHERE o.option_name LIKE '_transient_%'\n AND o.option_name NOT LIKE '_transient_timeout_%'\n AND t.option_value < UNIX_TIMESTAMP();<\/code><\/pre><\/div>Delete expired transients<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>DELETE a, b FROM wp_options a\nLEFT JOIN wp_options b ON b.option_name = CONCAT('_transient_timeout_', \n SUBSTRING(a.option_name, 12))\nWHERE a.option_name LIKE '_transient_%'\n AND a.option_name NOT LIKE '_transient_timeout_%'\n AND b.option_value IS NOT NULL\n AND b.option_value < UNIX_TIMESTAMP();<\/code><\/pre><\/div>Optimize autoload<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>-- Find options that shouldn't autoload\nSELECT option_name, LENGTH(option_value) as size\nFROM wp_options \nWHERE autoload = 'yes' \n AND LENGTH(option_value) > 10000\nORDER BY size DESC;\n\n-- Disable autoload for specific option\nUPDATE wp_options \nSET autoload = 'no' \nWHERE option_name = 'large_serialized_option';<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_option( $option, $default )<\/code> – Get option value<\/li>add_option( $option, $value, $deprecated, $autoload )<\/code> – Add option<\/li>update_option( $option, $value, $autoload )<\/code> – Update\/add option<\/li>delete_option( $option )<\/code> – Delete option<\/li>set_transient( $name, $value, $expiration )<\/code> – Set transient<\/li>get_transient( $name )<\/code> – Get transient<\/li>delete_transient( $name )<\/code> – Delete transient<\/li><\/ul>Performance Notes<\/h2>Autoload Optimization<\/h3>Large sites should audit autoloaded options:<\/p>sql<\/span><\/use><\/svg><\/button><\/div>SELECT SUM(LENGTH(option_value))\/1024 as kb FROM wp_options WHERE autoload='yes';<\/code><\/pre><\/div>Target: Keep autoload under 1MB total.<\/p>Transient Cleanup<\/h3>Transients without expiration never auto-delete. Periodically clean:<\/p>php<\/span>
PRIMARY<\/code><\/td>option_id<\/td>Yes<\/td>Primary key<\/td><\/tr>option_name<\/code><\/td>option_name<\/td>Yes<\/td>Unique constraint + lookup<\/td><\/tr>autoload<\/code><\/td>autoload<\/td>No<\/td>Filter autoloaded options<\/td><\/tr><\/tbody><\/table><\/figure>Foreign Key Relationships<\/h2>None\u2014standalone configuration table.<\/p>Autoload Behavior<\/h2>Options with autoload = 'yes'<\/code> are loaded into memory on every WordPress request via:<\/p>php<\/span><\/use><\/svg><\/button><\/div>wp_load_alloptions()<\/code><\/pre><\/div>This is cached in object cache. Setting autoload = 'no'<\/code> for rarely-used options improves performance.<\/p>Core Option Categories<\/h2>Site Settings<\/h3>Option<\/th>Description<\/th><\/tr><\/thead>siteurl<\/code><\/td>WordPress installation URL<\/td><\/tr>home<\/code><\/td>Site homepage URL<\/td><\/tr>blogname<\/code><\/td>Site title<\/td><\/tr>blogdescription<\/code><\/td>Site tagline<\/td><\/tr>admin_email<\/code><\/td>Admin email address<\/td><\/tr>timezone_string<\/code><\/td>Timezone setting<\/td><\/tr>date_format<\/code><\/td>Date display format<\/td><\/tr>time_format<\/code><\/td>Time display format<\/td><\/tr><\/tbody><\/table><\/figure>Reading\/Writing<\/h3>Option<\/th>Description<\/th><\/tr><\/thead>posts_per_page<\/code><\/td>Posts per archive page<\/td><\/tr>posts_per_rss<\/code><\/td>Posts per RSS feed<\/td><\/tr>show_on_front<\/code><\/td>‘posts’ or ‘page’<\/td><\/tr>page_on_front<\/code><\/td>Static front page ID<\/td><\/tr>page_for_posts<\/code><\/td>Blog page ID<\/td><\/tr>default_category<\/code><\/td>Default post category<\/td><\/tr>default_comment_status<\/code><\/td>Default comment status<\/td><\/tr><\/tbody><\/table><\/figure>Permalinks<\/h3>Option<\/th>Description<\/th><\/tr><\/thead>permalink_structure<\/code><\/td>Permalink pattern<\/td><\/tr>category_base<\/code><\/td>Category URL prefix<\/td><\/tr>tag_base<\/code><\/td>Tag URL prefix<\/td><\/tr>rewrite_rules<\/code><\/td>Serialized rewrite rules<\/td><\/tr><\/tbody><\/table><\/figure>Theme\/Appearance<\/h3>Option<\/th>Description<\/th><\/tr><\/thead>template<\/code><\/td>Active theme directory<\/td><\/tr>stylesheet<\/code><\/td>Active child theme directory<\/td><\/tr>current_theme<\/code><\/td>Theme display name<\/td><\/tr>sidebars_widgets<\/code><\/td>Widget assignments<\/td><\/tr>theme_mods_{theme}<\/code><\/td>Theme customization<\/td><\/tr>nav_menu_options<\/code><\/td>Navigation menu settings<\/td><\/tr><\/tbody><\/table><\/figure>Cron & Transients<\/h3>Pattern<\/th>Description<\/th><\/tr><\/thead>cron<\/code><\/td>Scheduled tasks<\/td><\/tr>_transient_{name}<\/code><\/td>Cached data<\/td><\/tr>_transient_timeout_{name}<\/code><\/td>Transient expiration<\/td><\/tr>_site_transient_{name}<\/code><\/td>Network transient<\/td><\/tr><\/tbody><\/table><\/figure>Plugin Settings<\/h3>Plugins typically use patterns like:<\/p>{plugin_slug}_settings<\/code><\/li>{plugin_slug}_options<\/code><\/li>{plugin_slug}_version<\/code><\/li><\/ul>Common Queries<\/h2>Get option value<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_value \nFROM wp_options \nWHERE option_name = 'siteurl';<\/code><\/pre><\/div>Get all autoloaded options<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_name, option_value \nFROM wp_options \nWHERE autoload = 'yes';<\/code><\/pre><\/div>Calculate autoload size<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT \n SUM(LENGTH(option_value)) as total_bytes,\n COUNT(*) as option_count\nFROM wp_options \nWHERE autoload = 'yes';<\/code><\/pre><\/div>Find large options<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_name, LENGTH(option_value) as size_bytes\nFROM wp_options \nORDER BY size_bytes DESC \nLIMIT 20;<\/code><\/pre><\/div>Find expired transients<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT o.option_name, o.option_value\nFROM wp_options o\nJOIN wp_options t ON t.option_name = CONCAT('_transient_timeout_', \n SUBSTRING(o.option_name, 12))\nWHERE o.option_name LIKE '_transient_%'\n AND o.option_name NOT LIKE '_transient_timeout_%'\n AND t.option_value < UNIX_TIMESTAMP();<\/code><\/pre><\/div>Delete expired transients<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>DELETE a, b FROM wp_options a\nLEFT JOIN wp_options b ON b.option_name = CONCAT('_transient_timeout_', \n SUBSTRING(a.option_name, 12))\nWHERE a.option_name LIKE '_transient_%'\n AND a.option_name NOT LIKE '_transient_timeout_%'\n AND b.option_value IS NOT NULL\n AND b.option_value < UNIX_TIMESTAMP();<\/code><\/pre><\/div>Optimize autoload<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>-- Find options that shouldn't autoload\nSELECT option_name, LENGTH(option_value) as size\nFROM wp_options \nWHERE autoload = 'yes' \n AND LENGTH(option_value) > 10000\nORDER BY size DESC;\n\n-- Disable autoload for specific option\nUPDATE wp_options \nSET autoload = 'no' \nWHERE option_name = 'large_serialized_option';<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_option( $option, $default )<\/code> – Get option value<\/li>add_option( $option, $value, $deprecated, $autoload )<\/code> – Add option<\/li>update_option( $option, $value, $autoload )<\/code> – Update\/add option<\/li>delete_option( $option )<\/code> – Delete option<\/li>set_transient( $name, $value, $expiration )<\/code> – Set transient<\/li>get_transient( $name )<\/code> – Get transient<\/li>delete_transient( $name )<\/code> – Delete transient<\/li><\/ul>Performance Notes<\/h2>Autoload Optimization<\/h3>Large sites should audit autoloaded options:<\/p>sql<\/span><\/use><\/svg><\/button><\/div>SELECT SUM(LENGTH(option_value))\/1024 as kb FROM wp_options WHERE autoload='yes';<\/code><\/pre><\/div>Target: Keep autoload under 1MB total.<\/p>Transient Cleanup<\/h3>Transients without expiration never auto-delete. Periodically clean:<\/p>php<\/span>
option_name<\/code><\/td>option_name<\/td>Yes<\/td>Unique constraint + lookup<\/td><\/tr>autoload<\/code><\/td>autoload<\/td>No<\/td>Filter autoloaded options<\/td><\/tr><\/tbody><\/table><\/figure>Foreign Key Relationships<\/h2>None\u2014standalone configuration table.<\/p>Autoload Behavior<\/h2>Options with autoload = 'yes'<\/code> are loaded into memory on every WordPress request via:<\/p>php<\/span><\/use><\/svg><\/button><\/div>wp_load_alloptions()<\/code><\/pre><\/div>This is cached in object cache. Setting autoload = 'no'<\/code> for rarely-used options improves performance.<\/p>Core Option Categories<\/h2>Site Settings<\/h3>Option<\/th>Description<\/th><\/tr><\/thead>siteurl<\/code><\/td>WordPress installation URL<\/td><\/tr>home<\/code><\/td>Site homepage URL<\/td><\/tr>blogname<\/code><\/td>Site title<\/td><\/tr>blogdescription<\/code><\/td>Site tagline<\/td><\/tr>admin_email<\/code><\/td>Admin email address<\/td><\/tr>timezone_string<\/code><\/td>Timezone setting<\/td><\/tr>date_format<\/code><\/td>Date display format<\/td><\/tr>time_format<\/code><\/td>Time display format<\/td><\/tr><\/tbody><\/table><\/figure>Reading\/Writing<\/h3>Option<\/th>Description<\/th><\/tr><\/thead>posts_per_page<\/code><\/td>Posts per archive page<\/td><\/tr>posts_per_rss<\/code><\/td>Posts per RSS feed<\/td><\/tr>show_on_front<\/code><\/td>‘posts’ or ‘page’<\/td><\/tr>page_on_front<\/code><\/td>Static front page ID<\/td><\/tr>page_for_posts<\/code><\/td>Blog page ID<\/td><\/tr>default_category<\/code><\/td>Default post category<\/td><\/tr>default_comment_status<\/code><\/td>Default comment status<\/td><\/tr><\/tbody><\/table><\/figure>Permalinks<\/h3>Option<\/th>Description<\/th><\/tr><\/thead>permalink_structure<\/code><\/td>Permalink pattern<\/td><\/tr>category_base<\/code><\/td>Category URL prefix<\/td><\/tr>tag_base<\/code><\/td>Tag URL prefix<\/td><\/tr>rewrite_rules<\/code><\/td>Serialized rewrite rules<\/td><\/tr><\/tbody><\/table><\/figure>Theme\/Appearance<\/h3>Option<\/th>Description<\/th><\/tr><\/thead>template<\/code><\/td>Active theme directory<\/td><\/tr>stylesheet<\/code><\/td>Active child theme directory<\/td><\/tr>current_theme<\/code><\/td>Theme display name<\/td><\/tr>sidebars_widgets<\/code><\/td>Widget assignments<\/td><\/tr>theme_mods_{theme}<\/code><\/td>Theme customization<\/td><\/tr>nav_menu_options<\/code><\/td>Navigation menu settings<\/td><\/tr><\/tbody><\/table><\/figure>Cron & Transients<\/h3>Pattern<\/th>Description<\/th><\/tr><\/thead>cron<\/code><\/td>Scheduled tasks<\/td><\/tr>_transient_{name}<\/code><\/td>Cached data<\/td><\/tr>_transient_timeout_{name}<\/code><\/td>Transient expiration<\/td><\/tr>_site_transient_{name}<\/code><\/td>Network transient<\/td><\/tr><\/tbody><\/table><\/figure>Plugin Settings<\/h3>Plugins typically use patterns like:<\/p>{plugin_slug}_settings<\/code><\/li>{plugin_slug}_options<\/code><\/li>{plugin_slug}_version<\/code><\/li><\/ul>Common Queries<\/h2>Get option value<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_value \nFROM wp_options \nWHERE option_name = 'siteurl';<\/code><\/pre><\/div>Get all autoloaded options<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_name, option_value \nFROM wp_options \nWHERE autoload = 'yes';<\/code><\/pre><\/div>Calculate autoload size<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT \n SUM(LENGTH(option_value)) as total_bytes,\n COUNT(*) as option_count\nFROM wp_options \nWHERE autoload = 'yes';<\/code><\/pre><\/div>Find large options<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_name, LENGTH(option_value) as size_bytes\nFROM wp_options \nORDER BY size_bytes DESC \nLIMIT 20;<\/code><\/pre><\/div>Find expired transients<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT o.option_name, o.option_value\nFROM wp_options o\nJOIN wp_options t ON t.option_name = CONCAT('_transient_timeout_', \n SUBSTRING(o.option_name, 12))\nWHERE o.option_name LIKE '_transient_%'\n AND o.option_name NOT LIKE '_transient_timeout_%'\n AND t.option_value < UNIX_TIMESTAMP();<\/code><\/pre><\/div>Delete expired transients<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>DELETE a, b FROM wp_options a\nLEFT JOIN wp_options b ON b.option_name = CONCAT('_transient_timeout_', \n SUBSTRING(a.option_name, 12))\nWHERE a.option_name LIKE '_transient_%'\n AND a.option_name NOT LIKE '_transient_timeout_%'\n AND b.option_value IS NOT NULL\n AND b.option_value < UNIX_TIMESTAMP();<\/code><\/pre><\/div>Optimize autoload<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>-- Find options that shouldn't autoload\nSELECT option_name, LENGTH(option_value) as size\nFROM wp_options \nWHERE autoload = 'yes' \n AND LENGTH(option_value) > 10000\nORDER BY size DESC;\n\n-- Disable autoload for specific option\nUPDATE wp_options \nSET autoload = 'no' \nWHERE option_name = 'large_serialized_option';<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_option( $option, $default )<\/code> – Get option value<\/li>add_option( $option, $value, $deprecated, $autoload )<\/code> – Add option<\/li>update_option( $option, $value, $autoload )<\/code> – Update\/add option<\/li>delete_option( $option )<\/code> – Delete option<\/li>set_transient( $name, $value, $expiration )<\/code> – Set transient<\/li>get_transient( $name )<\/code> – Get transient<\/li>delete_transient( $name )<\/code> – Delete transient<\/li><\/ul>Performance Notes<\/h2>Autoload Optimization<\/h3>Large sites should audit autoloaded options:<\/p>sql<\/span><\/use><\/svg><\/button><\/div>SELECT SUM(LENGTH(option_value))\/1024 as kb FROM wp_options WHERE autoload='yes';<\/code><\/pre><\/div>Target: Keep autoload under 1MB total.<\/p>Transient Cleanup<\/h3>Transients without expiration never auto-delete. Periodically clean:<\/p>php<\/span>
autoload<\/code><\/td>autoload<\/td>No<\/td>Filter autoloaded options<\/td><\/tr><\/tbody><\/table><\/figure>Foreign Key Relationships<\/h2>None\u2014standalone configuration table.<\/p>Autoload Behavior<\/h2>Options with autoload = 'yes'<\/code> are loaded into memory on every WordPress request via:<\/p>php<\/span><\/use><\/svg><\/button><\/div>wp_load_alloptions()<\/code><\/pre><\/div>This is cached in object cache. Setting autoload = 'no'<\/code> for rarely-used options improves performance.<\/p>Core Option Categories<\/h2>Site Settings<\/h3>Option<\/th>Description<\/th><\/tr><\/thead>siteurl<\/code><\/td>WordPress installation URL<\/td><\/tr>home<\/code><\/td>Site homepage URL<\/td><\/tr>blogname<\/code><\/td>Site title<\/td><\/tr>blogdescription<\/code><\/td>Site tagline<\/td><\/tr>admin_email<\/code><\/td>Admin email address<\/td><\/tr>timezone_string<\/code><\/td>Timezone setting<\/td><\/tr>date_format<\/code><\/td>Date display format<\/td><\/tr>time_format<\/code><\/td>Time display format<\/td><\/tr><\/tbody><\/table><\/figure>Reading\/Writing<\/h3>Option<\/th>Description<\/th><\/tr><\/thead>posts_per_page<\/code><\/td>Posts per archive page<\/td><\/tr>posts_per_rss<\/code><\/td>Posts per RSS feed<\/td><\/tr>show_on_front<\/code><\/td>‘posts’ or ‘page’<\/td><\/tr>page_on_front<\/code><\/td>Static front page ID<\/td><\/tr>page_for_posts<\/code><\/td>Blog page ID<\/td><\/tr>default_category<\/code><\/td>Default post category<\/td><\/tr>default_comment_status<\/code><\/td>Default comment status<\/td><\/tr><\/tbody><\/table><\/figure>Permalinks<\/h3>Option<\/th>Description<\/th><\/tr><\/thead>permalink_structure<\/code><\/td>Permalink pattern<\/td><\/tr>category_base<\/code><\/td>Category URL prefix<\/td><\/tr>tag_base<\/code><\/td>Tag URL prefix<\/td><\/tr>rewrite_rules<\/code><\/td>Serialized rewrite rules<\/td><\/tr><\/tbody><\/table><\/figure>Theme\/Appearance<\/h3>Option<\/th>Description<\/th><\/tr><\/thead>template<\/code><\/td>Active theme directory<\/td><\/tr>stylesheet<\/code><\/td>Active child theme directory<\/td><\/tr>current_theme<\/code><\/td>Theme display name<\/td><\/tr>sidebars_widgets<\/code><\/td>Widget assignments<\/td><\/tr>theme_mods_{theme}<\/code><\/td>Theme customization<\/td><\/tr>nav_menu_options<\/code><\/td>Navigation menu settings<\/td><\/tr><\/tbody><\/table><\/figure>Cron & Transients<\/h3>Pattern<\/th>Description<\/th><\/tr><\/thead>cron<\/code><\/td>Scheduled tasks<\/td><\/tr>_transient_{name}<\/code><\/td>Cached data<\/td><\/tr>_transient_timeout_{name}<\/code><\/td>Transient expiration<\/td><\/tr>_site_transient_{name}<\/code><\/td>Network transient<\/td><\/tr><\/tbody><\/table><\/figure>Plugin Settings<\/h3>Plugins typically use patterns like:<\/p>{plugin_slug}_settings<\/code><\/li>{plugin_slug}_options<\/code><\/li>{plugin_slug}_version<\/code><\/li><\/ul>Common Queries<\/h2>Get option value<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_value \nFROM wp_options \nWHERE option_name = 'siteurl';<\/code><\/pre><\/div>Get all autoloaded options<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_name, option_value \nFROM wp_options \nWHERE autoload = 'yes';<\/code><\/pre><\/div>Calculate autoload size<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT \n SUM(LENGTH(option_value)) as total_bytes,\n COUNT(*) as option_count\nFROM wp_options \nWHERE autoload = 'yes';<\/code><\/pre><\/div>Find large options<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_name, LENGTH(option_value) as size_bytes\nFROM wp_options \nORDER BY size_bytes DESC \nLIMIT 20;<\/code><\/pre><\/div>Find expired transients<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT o.option_name, o.option_value\nFROM wp_options o\nJOIN wp_options t ON t.option_name = CONCAT('_transient_timeout_', \n SUBSTRING(o.option_name, 12))\nWHERE o.option_name LIKE '_transient_%'\n AND o.option_name NOT LIKE '_transient_timeout_%'\n AND t.option_value < UNIX_TIMESTAMP();<\/code><\/pre><\/div>Delete expired transients<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>DELETE a, b FROM wp_options a\nLEFT JOIN wp_options b ON b.option_name = CONCAT('_transient_timeout_', \n SUBSTRING(a.option_name, 12))\nWHERE a.option_name LIKE '_transient_%'\n AND a.option_name NOT LIKE '_transient_timeout_%'\n AND b.option_value IS NOT NULL\n AND b.option_value < UNIX_TIMESTAMP();<\/code><\/pre><\/div>Optimize autoload<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>-- Find options that shouldn't autoload\nSELECT option_name, LENGTH(option_value) as size\nFROM wp_options \nWHERE autoload = 'yes' \n AND LENGTH(option_value) > 10000\nORDER BY size DESC;\n\n-- Disable autoload for specific option\nUPDATE wp_options \nSET autoload = 'no' \nWHERE option_name = 'large_serialized_option';<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_option( $option, $default )<\/code> – Get option value<\/li>add_option( $option, $value, $deprecated, $autoload )<\/code> – Add option<\/li>update_option( $option, $value, $autoload )<\/code> – Update\/add option<\/li>delete_option( $option )<\/code> – Delete option<\/li>set_transient( $name, $value, $expiration )<\/code> – Set transient<\/li>get_transient( $name )<\/code> – Get transient<\/li>delete_transient( $name )<\/code> – Delete transient<\/li><\/ul>Performance Notes<\/h2>Autoload Optimization<\/h3>Large sites should audit autoloaded options:<\/p>sql<\/span><\/use><\/svg><\/button><\/div>SELECT SUM(LENGTH(option_value))\/1024 as kb FROM wp_options WHERE autoload='yes';<\/code><\/pre><\/div>Target: Keep autoload under 1MB total.<\/p>Transient Cleanup<\/h3>Transients without expiration never auto-delete. Periodically clean:<\/p>php<\/span>
None\u2014standalone configuration table.<\/p>
Options with autoload = 'yes'<\/code> are loaded into memory on every WordPress request via:<\/p>php<\/span><\/use><\/svg><\/button><\/div>wp_load_alloptions()<\/code><\/pre><\/div>This is cached in object cache. Setting autoload = 'no'<\/code> for rarely-used options improves performance.<\/p>Core Option Categories<\/h2>Site Settings<\/h3>Option<\/th>Description<\/th><\/tr><\/thead>siteurl<\/code><\/td>WordPress installation URL<\/td><\/tr>home<\/code><\/td>Site homepage URL<\/td><\/tr>blogname<\/code><\/td>Site title<\/td><\/tr>blogdescription<\/code><\/td>Site tagline<\/td><\/tr>admin_email<\/code><\/td>Admin email address<\/td><\/tr>timezone_string<\/code><\/td>Timezone setting<\/td><\/tr>date_format<\/code><\/td>Date display format<\/td><\/tr>time_format<\/code><\/td>Time display format<\/td><\/tr><\/tbody><\/table><\/figure>Reading\/Writing<\/h3>Option<\/th>Description<\/th><\/tr><\/thead>posts_per_page<\/code><\/td>Posts per archive page<\/td><\/tr>posts_per_rss<\/code><\/td>Posts per RSS feed<\/td><\/tr>show_on_front<\/code><\/td>‘posts’ or ‘page’<\/td><\/tr>page_on_front<\/code><\/td>Static front page ID<\/td><\/tr>page_for_posts<\/code><\/td>Blog page ID<\/td><\/tr>default_category<\/code><\/td>Default post category<\/td><\/tr>default_comment_status<\/code><\/td>Default comment status<\/td><\/tr><\/tbody><\/table><\/figure>Permalinks<\/h3>Option<\/th>Description<\/th><\/tr><\/thead>permalink_structure<\/code><\/td>Permalink pattern<\/td><\/tr>category_base<\/code><\/td>Category URL prefix<\/td><\/tr>tag_base<\/code><\/td>Tag URL prefix<\/td><\/tr>rewrite_rules<\/code><\/td>Serialized rewrite rules<\/td><\/tr><\/tbody><\/table><\/figure>Theme\/Appearance<\/h3>Option<\/th>Description<\/th><\/tr><\/thead>template<\/code><\/td>Active theme directory<\/td><\/tr>stylesheet<\/code><\/td>Active child theme directory<\/td><\/tr>current_theme<\/code><\/td>Theme display name<\/td><\/tr>sidebars_widgets<\/code><\/td>Widget assignments<\/td><\/tr>theme_mods_{theme}<\/code><\/td>Theme customization<\/td><\/tr>nav_menu_options<\/code><\/td>Navigation menu settings<\/td><\/tr><\/tbody><\/table><\/figure>Cron & Transients<\/h3>Pattern<\/th>Description<\/th><\/tr><\/thead>cron<\/code><\/td>Scheduled tasks<\/td><\/tr>_transient_{name}<\/code><\/td>Cached data<\/td><\/tr>_transient_timeout_{name}<\/code><\/td>Transient expiration<\/td><\/tr>_site_transient_{name}<\/code><\/td>Network transient<\/td><\/tr><\/tbody><\/table><\/figure>Plugin Settings<\/h3>Plugins typically use patterns like:<\/p>{plugin_slug}_settings<\/code><\/li>{plugin_slug}_options<\/code><\/li>{plugin_slug}_version<\/code><\/li><\/ul>Common Queries<\/h2>Get option value<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_value \nFROM wp_options \nWHERE option_name = 'siteurl';<\/code><\/pre><\/div>Get all autoloaded options<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_name, option_value \nFROM wp_options \nWHERE autoload = 'yes';<\/code><\/pre><\/div>Calculate autoload size<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT \n SUM(LENGTH(option_value)) as total_bytes,\n COUNT(*) as option_count\nFROM wp_options \nWHERE autoload = 'yes';<\/code><\/pre><\/div>Find large options<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_name, LENGTH(option_value) as size_bytes\nFROM wp_options \nORDER BY size_bytes DESC \nLIMIT 20;<\/code><\/pre><\/div>Find expired transients<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT o.option_name, o.option_value\nFROM wp_options o\nJOIN wp_options t ON t.option_name = CONCAT('_transient_timeout_', \n SUBSTRING(o.option_name, 12))\nWHERE o.option_name LIKE '_transient_%'\n AND o.option_name NOT LIKE '_transient_timeout_%'\n AND t.option_value < UNIX_TIMESTAMP();<\/code><\/pre><\/div>Delete expired transients<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>DELETE a, b FROM wp_options a\nLEFT JOIN wp_options b ON b.option_name = CONCAT('_transient_timeout_', \n SUBSTRING(a.option_name, 12))\nWHERE a.option_name LIKE '_transient_%'\n AND a.option_name NOT LIKE '_transient_timeout_%'\n AND b.option_value IS NOT NULL\n AND b.option_value < UNIX_TIMESTAMP();<\/code><\/pre><\/div>Optimize autoload<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>-- Find options that shouldn't autoload\nSELECT option_name, LENGTH(option_value) as size\nFROM wp_options \nWHERE autoload = 'yes' \n AND LENGTH(option_value) > 10000\nORDER BY size DESC;\n\n-- Disable autoload for specific option\nUPDATE wp_options \nSET autoload = 'no' \nWHERE option_name = 'large_serialized_option';<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_option( $option, $default )<\/code> – Get option value<\/li>add_option( $option, $value, $deprecated, $autoload )<\/code> – Add option<\/li>update_option( $option, $value, $autoload )<\/code> – Update\/add option<\/li>delete_option( $option )<\/code> – Delete option<\/li>set_transient( $name, $value, $expiration )<\/code> – Set transient<\/li>get_transient( $name )<\/code> – Get transient<\/li>delete_transient( $name )<\/code> – Delete transient<\/li><\/ul>Performance Notes<\/h2>Autoload Optimization<\/h3>Large sites should audit autoloaded options:<\/p>sql<\/span><\/use><\/svg><\/button><\/div>SELECT SUM(LENGTH(option_value))\/1024 as kb FROM wp_options WHERE autoload='yes';<\/code><\/pre><\/div>Target: Keep autoload under 1MB total.<\/p>Transient Cleanup<\/h3>Transients without expiration never auto-delete. Periodically clean:<\/p>php<\/span>
autoload = 'yes'<\/code> are loaded into memory on every WordPress request via:<\/p>php<\/span><\/use><\/svg><\/button><\/div>wp_load_alloptions()<\/code><\/pre><\/div>This is cached in object cache. Setting autoload = 'no'<\/code> for rarely-used options improves performance.<\/p>Core Option Categories<\/h2>Site Settings<\/h3>Option<\/th>Description<\/th><\/tr><\/thead>siteurl<\/code><\/td>WordPress installation URL<\/td><\/tr>home<\/code><\/td>Site homepage URL<\/td><\/tr>blogname<\/code><\/td>Site title<\/td><\/tr>blogdescription<\/code><\/td>Site tagline<\/td><\/tr>admin_email<\/code><\/td>Admin email address<\/td><\/tr>timezone_string<\/code><\/td>Timezone setting<\/td><\/tr>date_format<\/code><\/td>Date display format<\/td><\/tr>time_format<\/code><\/td>Time display format<\/td><\/tr><\/tbody><\/table><\/figure>Reading\/Writing<\/h3>Option<\/th>Description<\/th><\/tr><\/thead>posts_per_page<\/code><\/td>Posts per archive page<\/td><\/tr>posts_per_rss<\/code><\/td>Posts per RSS feed<\/td><\/tr>show_on_front<\/code><\/td>‘posts’ or ‘page’<\/td><\/tr>page_on_front<\/code><\/td>Static front page ID<\/td><\/tr>page_for_posts<\/code><\/td>Blog page ID<\/td><\/tr>default_category<\/code><\/td>Default post category<\/td><\/tr>default_comment_status<\/code><\/td>Default comment status<\/td><\/tr><\/tbody><\/table><\/figure>Permalinks<\/h3>Option<\/th>Description<\/th><\/tr><\/thead>permalink_structure<\/code><\/td>Permalink pattern<\/td><\/tr>category_base<\/code><\/td>Category URL prefix<\/td><\/tr>tag_base<\/code><\/td>Tag URL prefix<\/td><\/tr>rewrite_rules<\/code><\/td>Serialized rewrite rules<\/td><\/tr><\/tbody><\/table><\/figure>Theme\/Appearance<\/h3>Option<\/th>Description<\/th><\/tr><\/thead>template<\/code><\/td>Active theme directory<\/td><\/tr>stylesheet<\/code><\/td>Active child theme directory<\/td><\/tr>current_theme<\/code><\/td>Theme display name<\/td><\/tr>sidebars_widgets<\/code><\/td>Widget assignments<\/td><\/tr>theme_mods_{theme}<\/code><\/td>Theme customization<\/td><\/tr>nav_menu_options<\/code><\/td>Navigation menu settings<\/td><\/tr><\/tbody><\/table><\/figure>Cron & Transients<\/h3>Pattern<\/th>Description<\/th><\/tr><\/thead>cron<\/code><\/td>Scheduled tasks<\/td><\/tr>_transient_{name}<\/code><\/td>Cached data<\/td><\/tr>_transient_timeout_{name}<\/code><\/td>Transient expiration<\/td><\/tr>_site_transient_{name}<\/code><\/td>Network transient<\/td><\/tr><\/tbody><\/table><\/figure>Plugin Settings<\/h3>Plugins typically use patterns like:<\/p>{plugin_slug}_settings<\/code><\/li>{plugin_slug}_options<\/code><\/li>{plugin_slug}_version<\/code><\/li><\/ul>Common Queries<\/h2>Get option value<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_value \nFROM wp_options \nWHERE option_name = 'siteurl';<\/code><\/pre><\/div>Get all autoloaded options<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_name, option_value \nFROM wp_options \nWHERE autoload = 'yes';<\/code><\/pre><\/div>Calculate autoload size<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT \n SUM(LENGTH(option_value)) as total_bytes,\n COUNT(*) as option_count\nFROM wp_options \nWHERE autoload = 'yes';<\/code><\/pre><\/div>Find large options<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_name, LENGTH(option_value) as size_bytes\nFROM wp_options \nORDER BY size_bytes DESC \nLIMIT 20;<\/code><\/pre><\/div>Find expired transients<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT o.option_name, o.option_value\nFROM wp_options o\nJOIN wp_options t ON t.option_name = CONCAT('_transient_timeout_', \n SUBSTRING(o.option_name, 12))\nWHERE o.option_name LIKE '_transient_%'\n AND o.option_name NOT LIKE '_transient_timeout_%'\n AND t.option_value < UNIX_TIMESTAMP();<\/code><\/pre><\/div>Delete expired transients<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>DELETE a, b FROM wp_options a\nLEFT JOIN wp_options b ON b.option_name = CONCAT('_transient_timeout_', \n SUBSTRING(a.option_name, 12))\nWHERE a.option_name LIKE '_transient_%'\n AND a.option_name NOT LIKE '_transient_timeout_%'\n AND b.option_value IS NOT NULL\n AND b.option_value < UNIX_TIMESTAMP();<\/code><\/pre><\/div>Optimize autoload<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>-- Find options that shouldn't autoload\nSELECT option_name, LENGTH(option_value) as size\nFROM wp_options \nWHERE autoload = 'yes' \n AND LENGTH(option_value) > 10000\nORDER BY size DESC;\n\n-- Disable autoload for specific option\nUPDATE wp_options \nSET autoload = 'no' \nWHERE option_name = 'large_serialized_option';<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_option( $option, $default )<\/code> – Get option value<\/li>add_option( $option, $value, $deprecated, $autoload )<\/code> – Add option<\/li>update_option( $option, $value, $autoload )<\/code> – Update\/add option<\/li>delete_option( $option )<\/code> – Delete option<\/li>set_transient( $name, $value, $expiration )<\/code> – Set transient<\/li>get_transient( $name )<\/code> – Get transient<\/li>delete_transient( $name )<\/code> – Delete transient<\/li><\/ul>Performance Notes<\/h2>Autoload Optimization<\/h3>Large sites should audit autoloaded options:<\/p>sql<\/span><\/use><\/svg><\/button><\/div>SELECT SUM(LENGTH(option_value))\/1024 as kb FROM wp_options WHERE autoload='yes';<\/code><\/pre><\/div>Target: Keep autoload under 1MB total.<\/p>Transient Cleanup<\/h3>Transients without expiration never auto-delete. Periodically clean:<\/p>php<\/span>
wp_load_alloptions()<\/code><\/pre><\/div>This is cached in object cache. Setting autoload = 'no'<\/code> for rarely-used options improves performance.<\/p>Core Option Categories<\/h2>Site Settings<\/h3>Option<\/th>Description<\/th><\/tr><\/thead>siteurl<\/code><\/td>WordPress installation URL<\/td><\/tr>home<\/code><\/td>Site homepage URL<\/td><\/tr>blogname<\/code><\/td>Site title<\/td><\/tr>blogdescription<\/code><\/td>Site tagline<\/td><\/tr>admin_email<\/code><\/td>Admin email address<\/td><\/tr>timezone_string<\/code><\/td>Timezone setting<\/td><\/tr>date_format<\/code><\/td>Date display format<\/td><\/tr>time_format<\/code><\/td>Time display format<\/td><\/tr><\/tbody><\/table><\/figure>Reading\/Writing<\/h3>Option<\/th>Description<\/th><\/tr><\/thead>posts_per_page<\/code><\/td>Posts per archive page<\/td><\/tr>posts_per_rss<\/code><\/td>Posts per RSS feed<\/td><\/tr>show_on_front<\/code><\/td>‘posts’ or ‘page’<\/td><\/tr>page_on_front<\/code><\/td>Static front page ID<\/td><\/tr>page_for_posts<\/code><\/td>Blog page ID<\/td><\/tr>default_category<\/code><\/td>Default post category<\/td><\/tr>default_comment_status<\/code><\/td>Default comment status<\/td><\/tr><\/tbody><\/table><\/figure>Permalinks<\/h3>Option<\/th>Description<\/th><\/tr><\/thead>permalink_structure<\/code><\/td>Permalink pattern<\/td><\/tr>category_base<\/code><\/td>Category URL prefix<\/td><\/tr>tag_base<\/code><\/td>Tag URL prefix<\/td><\/tr>rewrite_rules<\/code><\/td>Serialized rewrite rules<\/td><\/tr><\/tbody><\/table><\/figure>Theme\/Appearance<\/h3>Option<\/th>Description<\/th><\/tr><\/thead>template<\/code><\/td>Active theme directory<\/td><\/tr>stylesheet<\/code><\/td>Active child theme directory<\/td><\/tr>current_theme<\/code><\/td>Theme display name<\/td><\/tr>sidebars_widgets<\/code><\/td>Widget assignments<\/td><\/tr>theme_mods_{theme}<\/code><\/td>Theme customization<\/td><\/tr>nav_menu_options<\/code><\/td>Navigation menu settings<\/td><\/tr><\/tbody><\/table><\/figure>Cron & Transients<\/h3>Pattern<\/th>Description<\/th><\/tr><\/thead>cron<\/code><\/td>Scheduled tasks<\/td><\/tr>_transient_{name}<\/code><\/td>Cached data<\/td><\/tr>_transient_timeout_{name}<\/code><\/td>Transient expiration<\/td><\/tr>_site_transient_{name}<\/code><\/td>Network transient<\/td><\/tr><\/tbody><\/table><\/figure>Plugin Settings<\/h3>Plugins typically use patterns like:<\/p>{plugin_slug}_settings<\/code><\/li>{plugin_slug}_options<\/code><\/li>{plugin_slug}_version<\/code><\/li><\/ul>Common Queries<\/h2>Get option value<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_value \nFROM wp_options \nWHERE option_name = 'siteurl';<\/code><\/pre><\/div>Get all autoloaded options<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_name, option_value \nFROM wp_options \nWHERE autoload = 'yes';<\/code><\/pre><\/div>Calculate autoload size<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT \n SUM(LENGTH(option_value)) as total_bytes,\n COUNT(*) as option_count\nFROM wp_options \nWHERE autoload = 'yes';<\/code><\/pre><\/div>Find large options<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_name, LENGTH(option_value) as size_bytes\nFROM wp_options \nORDER BY size_bytes DESC \nLIMIT 20;<\/code><\/pre><\/div>Find expired transients<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT o.option_name, o.option_value\nFROM wp_options o\nJOIN wp_options t ON t.option_name = CONCAT('_transient_timeout_', \n SUBSTRING(o.option_name, 12))\nWHERE o.option_name LIKE '_transient_%'\n AND o.option_name NOT LIKE '_transient_timeout_%'\n AND t.option_value < UNIX_TIMESTAMP();<\/code><\/pre><\/div>Delete expired transients<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>DELETE a, b FROM wp_options a\nLEFT JOIN wp_options b ON b.option_name = CONCAT('_transient_timeout_', \n SUBSTRING(a.option_name, 12))\nWHERE a.option_name LIKE '_transient_%'\n AND a.option_name NOT LIKE '_transient_timeout_%'\n AND b.option_value IS NOT NULL\n AND b.option_value < UNIX_TIMESTAMP();<\/code><\/pre><\/div>Optimize autoload<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>-- Find options that shouldn't autoload\nSELECT option_name, LENGTH(option_value) as size\nFROM wp_options \nWHERE autoload = 'yes' \n AND LENGTH(option_value) > 10000\nORDER BY size DESC;\n\n-- Disable autoload for specific option\nUPDATE wp_options \nSET autoload = 'no' \nWHERE option_name = 'large_serialized_option';<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_option( $option, $default )<\/code> – Get option value<\/li>add_option( $option, $value, $deprecated, $autoload )<\/code> – Add option<\/li>update_option( $option, $value, $autoload )<\/code> – Update\/add option<\/li>delete_option( $option )<\/code> – Delete option<\/li>set_transient( $name, $value, $expiration )<\/code> – Set transient<\/li>get_transient( $name )<\/code> – Get transient<\/li>delete_transient( $name )<\/code> – Delete transient<\/li><\/ul>Performance Notes<\/h2>Autoload Optimization<\/h3>Large sites should audit autoloaded options:<\/p>sql<\/span><\/use><\/svg><\/button><\/div>SELECT SUM(LENGTH(option_value))\/1024 as kb FROM wp_options WHERE autoload='yes';<\/code><\/pre><\/div>Target: Keep autoload under 1MB total.<\/p>Transient Cleanup<\/h3>Transients without expiration never auto-delete. Periodically clean:<\/p>php<\/span>
This is cached in object cache. Setting autoload = 'no'<\/code> for rarely-used options improves performance.<\/p>Core Option Categories<\/h2>Site Settings<\/h3>Option<\/th>Description<\/th><\/tr><\/thead>siteurl<\/code><\/td>WordPress installation URL<\/td><\/tr>home<\/code><\/td>Site homepage URL<\/td><\/tr>blogname<\/code><\/td>Site title<\/td><\/tr>blogdescription<\/code><\/td>Site tagline<\/td><\/tr>admin_email<\/code><\/td>Admin email address<\/td><\/tr>timezone_string<\/code><\/td>Timezone setting<\/td><\/tr>date_format<\/code><\/td>Date display format<\/td><\/tr>time_format<\/code><\/td>Time display format<\/td><\/tr><\/tbody><\/table><\/figure>Reading\/Writing<\/h3>Option<\/th>Description<\/th><\/tr><\/thead>posts_per_page<\/code><\/td>Posts per archive page<\/td><\/tr>posts_per_rss<\/code><\/td>Posts per RSS feed<\/td><\/tr>show_on_front<\/code><\/td>‘posts’ or ‘page’<\/td><\/tr>page_on_front<\/code><\/td>Static front page ID<\/td><\/tr>page_for_posts<\/code><\/td>Blog page ID<\/td><\/tr>default_category<\/code><\/td>Default post category<\/td><\/tr>default_comment_status<\/code><\/td>Default comment status<\/td><\/tr><\/tbody><\/table><\/figure>Permalinks<\/h3>Option<\/th>Description<\/th><\/tr><\/thead>permalink_structure<\/code><\/td>Permalink pattern<\/td><\/tr>category_base<\/code><\/td>Category URL prefix<\/td><\/tr>tag_base<\/code><\/td>Tag URL prefix<\/td><\/tr>rewrite_rules<\/code><\/td>Serialized rewrite rules<\/td><\/tr><\/tbody><\/table><\/figure>Theme\/Appearance<\/h3>Option<\/th>Description<\/th><\/tr><\/thead>template<\/code><\/td>Active theme directory<\/td><\/tr>stylesheet<\/code><\/td>Active child theme directory<\/td><\/tr>current_theme<\/code><\/td>Theme display name<\/td><\/tr>sidebars_widgets<\/code><\/td>Widget assignments<\/td><\/tr>theme_mods_{theme}<\/code><\/td>Theme customization<\/td><\/tr>nav_menu_options<\/code><\/td>Navigation menu settings<\/td><\/tr><\/tbody><\/table><\/figure>Cron & Transients<\/h3>Pattern<\/th>Description<\/th><\/tr><\/thead>cron<\/code><\/td>Scheduled tasks<\/td><\/tr>_transient_{name}<\/code><\/td>Cached data<\/td><\/tr>_transient_timeout_{name}<\/code><\/td>Transient expiration<\/td><\/tr>_site_transient_{name}<\/code><\/td>Network transient<\/td><\/tr><\/tbody><\/table><\/figure>Plugin Settings<\/h3>Plugins typically use patterns like:<\/p>{plugin_slug}_settings<\/code><\/li>{plugin_slug}_options<\/code><\/li>{plugin_slug}_version<\/code><\/li><\/ul>Common Queries<\/h2>Get option value<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_value \nFROM wp_options \nWHERE option_name = 'siteurl';<\/code><\/pre><\/div>Get all autoloaded options<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_name, option_value \nFROM wp_options \nWHERE autoload = 'yes';<\/code><\/pre><\/div>Calculate autoload size<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT \n SUM(LENGTH(option_value)) as total_bytes,\n COUNT(*) as option_count\nFROM wp_options \nWHERE autoload = 'yes';<\/code><\/pre><\/div>Find large options<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_name, LENGTH(option_value) as size_bytes\nFROM wp_options \nORDER BY size_bytes DESC \nLIMIT 20;<\/code><\/pre><\/div>Find expired transients<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT o.option_name, o.option_value\nFROM wp_options o\nJOIN wp_options t ON t.option_name = CONCAT('_transient_timeout_', \n SUBSTRING(o.option_name, 12))\nWHERE o.option_name LIKE '_transient_%'\n AND o.option_name NOT LIKE '_transient_timeout_%'\n AND t.option_value < UNIX_TIMESTAMP();<\/code><\/pre><\/div>Delete expired transients<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>DELETE a, b FROM wp_options a\nLEFT JOIN wp_options b ON b.option_name = CONCAT('_transient_timeout_', \n SUBSTRING(a.option_name, 12))\nWHERE a.option_name LIKE '_transient_%'\n AND a.option_name NOT LIKE '_transient_timeout_%'\n AND b.option_value IS NOT NULL\n AND b.option_value < UNIX_TIMESTAMP();<\/code><\/pre><\/div>Optimize autoload<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>-- Find options that shouldn't autoload\nSELECT option_name, LENGTH(option_value) as size\nFROM wp_options \nWHERE autoload = 'yes' \n AND LENGTH(option_value) > 10000\nORDER BY size DESC;\n\n-- Disable autoload for specific option\nUPDATE wp_options \nSET autoload = 'no' \nWHERE option_name = 'large_serialized_option';<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_option( $option, $default )<\/code> – Get option value<\/li>add_option( $option, $value, $deprecated, $autoload )<\/code> – Add option<\/li>update_option( $option, $value, $autoload )<\/code> – Update\/add option<\/li>delete_option( $option )<\/code> – Delete option<\/li>set_transient( $name, $value, $expiration )<\/code> – Set transient<\/li>get_transient( $name )<\/code> – Get transient<\/li>delete_transient( $name )<\/code> – Delete transient<\/li><\/ul>Performance Notes<\/h2>Autoload Optimization<\/h3>Large sites should audit autoloaded options:<\/p>sql<\/span><\/use><\/svg><\/button><\/div>SELECT SUM(LENGTH(option_value))\/1024 as kb FROM wp_options WHERE autoload='yes';<\/code><\/pre><\/div>Target: Keep autoload under 1MB total.<\/p>Transient Cleanup<\/h3>Transients without expiration never auto-delete. Periodically clean:<\/p>php<\/span>
autoload = 'no'<\/code> for rarely-used options improves performance.<\/p>Core Option Categories<\/h2>Site Settings<\/h3>Option<\/th>Description<\/th><\/tr><\/thead>siteurl<\/code><\/td>WordPress installation URL<\/td><\/tr>home<\/code><\/td>Site homepage URL<\/td><\/tr>blogname<\/code><\/td>Site title<\/td><\/tr>blogdescription<\/code><\/td>Site tagline<\/td><\/tr>admin_email<\/code><\/td>Admin email address<\/td><\/tr>timezone_string<\/code><\/td>Timezone setting<\/td><\/tr>date_format<\/code><\/td>Date display format<\/td><\/tr>time_format<\/code><\/td>Time display format<\/td><\/tr><\/tbody><\/table><\/figure>Reading\/Writing<\/h3>Option<\/th>Description<\/th><\/tr><\/thead>posts_per_page<\/code><\/td>Posts per archive page<\/td><\/tr>posts_per_rss<\/code><\/td>Posts per RSS feed<\/td><\/tr>show_on_front<\/code><\/td>‘posts’ or ‘page’<\/td><\/tr>page_on_front<\/code><\/td>Static front page ID<\/td><\/tr>page_for_posts<\/code><\/td>Blog page ID<\/td><\/tr>default_category<\/code><\/td>Default post category<\/td><\/tr>default_comment_status<\/code><\/td>Default comment status<\/td><\/tr><\/tbody><\/table><\/figure>Permalinks<\/h3>Option<\/th>Description<\/th><\/tr><\/thead>permalink_structure<\/code><\/td>Permalink pattern<\/td><\/tr>category_base<\/code><\/td>Category URL prefix<\/td><\/tr>tag_base<\/code><\/td>Tag URL prefix<\/td><\/tr>rewrite_rules<\/code><\/td>Serialized rewrite rules<\/td><\/tr><\/tbody><\/table><\/figure>Theme\/Appearance<\/h3>Option<\/th>Description<\/th><\/tr><\/thead>template<\/code><\/td>Active theme directory<\/td><\/tr>stylesheet<\/code><\/td>Active child theme directory<\/td><\/tr>current_theme<\/code><\/td>Theme display name<\/td><\/tr>sidebars_widgets<\/code><\/td>Widget assignments<\/td><\/tr>theme_mods_{theme}<\/code><\/td>Theme customization<\/td><\/tr>nav_menu_options<\/code><\/td>Navigation menu settings<\/td><\/tr><\/tbody><\/table><\/figure>Cron & Transients<\/h3>Pattern<\/th>Description<\/th><\/tr><\/thead>cron<\/code><\/td>Scheduled tasks<\/td><\/tr>_transient_{name}<\/code><\/td>Cached data<\/td><\/tr>_transient_timeout_{name}<\/code><\/td>Transient expiration<\/td><\/tr>_site_transient_{name}<\/code><\/td>Network transient<\/td><\/tr><\/tbody><\/table><\/figure>Plugin Settings<\/h3>Plugins typically use patterns like:<\/p>{plugin_slug}_settings<\/code><\/li>{plugin_slug}_options<\/code><\/li>{plugin_slug}_version<\/code><\/li><\/ul>Common Queries<\/h2>Get option value<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_value \nFROM wp_options \nWHERE option_name = 'siteurl';<\/code><\/pre><\/div>Get all autoloaded options<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_name, option_value \nFROM wp_options \nWHERE autoload = 'yes';<\/code><\/pre><\/div>Calculate autoload size<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT \n SUM(LENGTH(option_value)) as total_bytes,\n COUNT(*) as option_count\nFROM wp_options \nWHERE autoload = 'yes';<\/code><\/pre><\/div>Find large options<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_name, LENGTH(option_value) as size_bytes\nFROM wp_options \nORDER BY size_bytes DESC \nLIMIT 20;<\/code><\/pre><\/div>Find expired transients<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT o.option_name, o.option_value\nFROM wp_options o\nJOIN wp_options t ON t.option_name = CONCAT('_transient_timeout_', \n SUBSTRING(o.option_name, 12))\nWHERE o.option_name LIKE '_transient_%'\n AND o.option_name NOT LIKE '_transient_timeout_%'\n AND t.option_value < UNIX_TIMESTAMP();<\/code><\/pre><\/div>Delete expired transients<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>DELETE a, b FROM wp_options a\nLEFT JOIN wp_options b ON b.option_name = CONCAT('_transient_timeout_', \n SUBSTRING(a.option_name, 12))\nWHERE a.option_name LIKE '_transient_%'\n AND a.option_name NOT LIKE '_transient_timeout_%'\n AND b.option_value IS NOT NULL\n AND b.option_value < UNIX_TIMESTAMP();<\/code><\/pre><\/div>Optimize autoload<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>-- Find options that shouldn't autoload\nSELECT option_name, LENGTH(option_value) as size\nFROM wp_options \nWHERE autoload = 'yes' \n AND LENGTH(option_value) > 10000\nORDER BY size DESC;\n\n-- Disable autoload for specific option\nUPDATE wp_options \nSET autoload = 'no' \nWHERE option_name = 'large_serialized_option';<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_option( $option, $default )<\/code> – Get option value<\/li>add_option( $option, $value, $deprecated, $autoload )<\/code> – Add option<\/li>update_option( $option, $value, $autoload )<\/code> – Update\/add option<\/li>delete_option( $option )<\/code> – Delete option<\/li>set_transient( $name, $value, $expiration )<\/code> – Set transient<\/li>get_transient( $name )<\/code> – Get transient<\/li>delete_transient( $name )<\/code> – Delete transient<\/li><\/ul>Performance Notes<\/h2>Autoload Optimization<\/h3>Large sites should audit autoloaded options:<\/p>sql<\/span><\/use><\/svg><\/button><\/div>SELECT SUM(LENGTH(option_value))\/1024 as kb FROM wp_options WHERE autoload='yes';<\/code><\/pre><\/div>Target: Keep autoload under 1MB total.<\/p>Transient Cleanup<\/h3>Transients without expiration never auto-delete. Periodically clean:<\/p>php<\/span>
siteurl<\/code><\/td>WordPress installation URL<\/td><\/tr>home<\/code><\/td>Site homepage URL<\/td><\/tr>blogname<\/code><\/td>Site title<\/td><\/tr>blogdescription<\/code><\/td>Site tagline<\/td><\/tr>admin_email<\/code><\/td>Admin email address<\/td><\/tr>timezone_string<\/code><\/td>Timezone setting<\/td><\/tr>date_format<\/code><\/td>Date display format<\/td><\/tr>time_format<\/code><\/td>Time display format<\/td><\/tr><\/tbody><\/table><\/figure>Reading\/Writing<\/h3>Option<\/th>Description<\/th><\/tr><\/thead>posts_per_page<\/code><\/td>Posts per archive page<\/td><\/tr>posts_per_rss<\/code><\/td>Posts per RSS feed<\/td><\/tr>show_on_front<\/code><\/td>‘posts’ or ‘page’<\/td><\/tr>page_on_front<\/code><\/td>Static front page ID<\/td><\/tr>page_for_posts<\/code><\/td>Blog page ID<\/td><\/tr>default_category<\/code><\/td>Default post category<\/td><\/tr>default_comment_status<\/code><\/td>Default comment status<\/td><\/tr><\/tbody><\/table><\/figure>Permalinks<\/h3>Option<\/th>Description<\/th><\/tr><\/thead>permalink_structure<\/code><\/td>Permalink pattern<\/td><\/tr>category_base<\/code><\/td>Category URL prefix<\/td><\/tr>tag_base<\/code><\/td>Tag URL prefix<\/td><\/tr>rewrite_rules<\/code><\/td>Serialized rewrite rules<\/td><\/tr><\/tbody><\/table><\/figure>Theme\/Appearance<\/h3>Option<\/th>Description<\/th><\/tr><\/thead>template<\/code><\/td>Active theme directory<\/td><\/tr>stylesheet<\/code><\/td>Active child theme directory<\/td><\/tr>current_theme<\/code><\/td>Theme display name<\/td><\/tr>sidebars_widgets<\/code><\/td>Widget assignments<\/td><\/tr>theme_mods_{theme}<\/code><\/td>Theme customization<\/td><\/tr>nav_menu_options<\/code><\/td>Navigation menu settings<\/td><\/tr><\/tbody><\/table><\/figure>Cron & Transients<\/h3>Pattern<\/th>Description<\/th><\/tr><\/thead>cron<\/code><\/td>Scheduled tasks<\/td><\/tr>_transient_{name}<\/code><\/td>Cached data<\/td><\/tr>_transient_timeout_{name}<\/code><\/td>Transient expiration<\/td><\/tr>_site_transient_{name}<\/code><\/td>Network transient<\/td><\/tr><\/tbody><\/table><\/figure>Plugin Settings<\/h3>Plugins typically use patterns like:<\/p>{plugin_slug}_settings<\/code><\/li>{plugin_slug}_options<\/code><\/li>{plugin_slug}_version<\/code><\/li><\/ul>Common Queries<\/h2>Get option value<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_value \nFROM wp_options \nWHERE option_name = 'siteurl';<\/code><\/pre><\/div>Get all autoloaded options<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_name, option_value \nFROM wp_options \nWHERE autoload = 'yes';<\/code><\/pre><\/div>Calculate autoload size<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT \n SUM(LENGTH(option_value)) as total_bytes,\n COUNT(*) as option_count\nFROM wp_options \nWHERE autoload = 'yes';<\/code><\/pre><\/div>Find large options<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_name, LENGTH(option_value) as size_bytes\nFROM wp_options \nORDER BY size_bytes DESC \nLIMIT 20;<\/code><\/pre><\/div>Find expired transients<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT o.option_name, o.option_value\nFROM wp_options o\nJOIN wp_options t ON t.option_name = CONCAT('_transient_timeout_', \n SUBSTRING(o.option_name, 12))\nWHERE o.option_name LIKE '_transient_%'\n AND o.option_name NOT LIKE '_transient_timeout_%'\n AND t.option_value < UNIX_TIMESTAMP();<\/code><\/pre><\/div>Delete expired transients<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>DELETE a, b FROM wp_options a\nLEFT JOIN wp_options b ON b.option_name = CONCAT('_transient_timeout_', \n SUBSTRING(a.option_name, 12))\nWHERE a.option_name LIKE '_transient_%'\n AND a.option_name NOT LIKE '_transient_timeout_%'\n AND b.option_value IS NOT NULL\n AND b.option_value < UNIX_TIMESTAMP();<\/code><\/pre><\/div>Optimize autoload<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>-- Find options that shouldn't autoload\nSELECT option_name, LENGTH(option_value) as size\nFROM wp_options \nWHERE autoload = 'yes' \n AND LENGTH(option_value) > 10000\nORDER BY size DESC;\n\n-- Disable autoload for specific option\nUPDATE wp_options \nSET autoload = 'no' \nWHERE option_name = 'large_serialized_option';<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_option( $option, $default )<\/code> – Get option value<\/li>add_option( $option, $value, $deprecated, $autoload )<\/code> – Add option<\/li>update_option( $option, $value, $autoload )<\/code> – Update\/add option<\/li>delete_option( $option )<\/code> – Delete option<\/li>set_transient( $name, $value, $expiration )<\/code> – Set transient<\/li>get_transient( $name )<\/code> – Get transient<\/li>delete_transient( $name )<\/code> – Delete transient<\/li><\/ul>Performance Notes<\/h2>Autoload Optimization<\/h3>Large sites should audit autoloaded options:<\/p>sql<\/span><\/use><\/svg><\/button><\/div>SELECT SUM(LENGTH(option_value))\/1024 as kb FROM wp_options WHERE autoload='yes';<\/code><\/pre><\/div>Target: Keep autoload under 1MB total.<\/p>Transient Cleanup<\/h3>Transients without expiration never auto-delete. Periodically clean:<\/p>php<\/span>
home<\/code><\/td>Site homepage URL<\/td><\/tr>blogname<\/code><\/td>Site title<\/td><\/tr>blogdescription<\/code><\/td>Site tagline<\/td><\/tr>admin_email<\/code><\/td>Admin email address<\/td><\/tr>timezone_string<\/code><\/td>Timezone setting<\/td><\/tr>date_format<\/code><\/td>Date display format<\/td><\/tr>time_format<\/code><\/td>Time display format<\/td><\/tr><\/tbody><\/table><\/figure>Reading\/Writing<\/h3>Option<\/th>Description<\/th><\/tr><\/thead>posts_per_page<\/code><\/td>Posts per archive page<\/td><\/tr>posts_per_rss<\/code><\/td>Posts per RSS feed<\/td><\/tr>show_on_front<\/code><\/td>‘posts’ or ‘page’<\/td><\/tr>page_on_front<\/code><\/td>Static front page ID<\/td><\/tr>page_for_posts<\/code><\/td>Blog page ID<\/td><\/tr>default_category<\/code><\/td>Default post category<\/td><\/tr>default_comment_status<\/code><\/td>Default comment status<\/td><\/tr><\/tbody><\/table><\/figure>Permalinks<\/h3>Option<\/th>Description<\/th><\/tr><\/thead>permalink_structure<\/code><\/td>Permalink pattern<\/td><\/tr>category_base<\/code><\/td>Category URL prefix<\/td><\/tr>tag_base<\/code><\/td>Tag URL prefix<\/td><\/tr>rewrite_rules<\/code><\/td>Serialized rewrite rules<\/td><\/tr><\/tbody><\/table><\/figure>Theme\/Appearance<\/h3>Option<\/th>Description<\/th><\/tr><\/thead>template<\/code><\/td>Active theme directory<\/td><\/tr>stylesheet<\/code><\/td>Active child theme directory<\/td><\/tr>current_theme<\/code><\/td>Theme display name<\/td><\/tr>sidebars_widgets<\/code><\/td>Widget assignments<\/td><\/tr>theme_mods_{theme}<\/code><\/td>Theme customization<\/td><\/tr>nav_menu_options<\/code><\/td>Navigation menu settings<\/td><\/tr><\/tbody><\/table><\/figure>Cron & Transients<\/h3>Pattern<\/th>Description<\/th><\/tr><\/thead>cron<\/code><\/td>Scheduled tasks<\/td><\/tr>_transient_{name}<\/code><\/td>Cached data<\/td><\/tr>_transient_timeout_{name}<\/code><\/td>Transient expiration<\/td><\/tr>_site_transient_{name}<\/code><\/td>Network transient<\/td><\/tr><\/tbody><\/table><\/figure>Plugin Settings<\/h3>Plugins typically use patterns like:<\/p>{plugin_slug}_settings<\/code><\/li>{plugin_slug}_options<\/code><\/li>{plugin_slug}_version<\/code><\/li><\/ul>Common Queries<\/h2>Get option value<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_value \nFROM wp_options \nWHERE option_name = 'siteurl';<\/code><\/pre><\/div>Get all autoloaded options<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_name, option_value \nFROM wp_options \nWHERE autoload = 'yes';<\/code><\/pre><\/div>Calculate autoload size<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT \n SUM(LENGTH(option_value)) as total_bytes,\n COUNT(*) as option_count\nFROM wp_options \nWHERE autoload = 'yes';<\/code><\/pre><\/div>Find large options<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_name, LENGTH(option_value) as size_bytes\nFROM wp_options \nORDER BY size_bytes DESC \nLIMIT 20;<\/code><\/pre><\/div>Find expired transients<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT o.option_name, o.option_value\nFROM wp_options o\nJOIN wp_options t ON t.option_name = CONCAT('_transient_timeout_', \n SUBSTRING(o.option_name, 12))\nWHERE o.option_name LIKE '_transient_%'\n AND o.option_name NOT LIKE '_transient_timeout_%'\n AND t.option_value < UNIX_TIMESTAMP();<\/code><\/pre><\/div>Delete expired transients<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>DELETE a, b FROM wp_options a\nLEFT JOIN wp_options b ON b.option_name = CONCAT('_transient_timeout_', \n SUBSTRING(a.option_name, 12))\nWHERE a.option_name LIKE '_transient_%'\n AND a.option_name NOT LIKE '_transient_timeout_%'\n AND b.option_value IS NOT NULL\n AND b.option_value < UNIX_TIMESTAMP();<\/code><\/pre><\/div>Optimize autoload<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>-- Find options that shouldn't autoload\nSELECT option_name, LENGTH(option_value) as size\nFROM wp_options \nWHERE autoload = 'yes' \n AND LENGTH(option_value) > 10000\nORDER BY size DESC;\n\n-- Disable autoload for specific option\nUPDATE wp_options \nSET autoload = 'no' \nWHERE option_name = 'large_serialized_option';<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_option( $option, $default )<\/code> – Get option value<\/li>add_option( $option, $value, $deprecated, $autoload )<\/code> – Add option<\/li>update_option( $option, $value, $autoload )<\/code> – Update\/add option<\/li>delete_option( $option )<\/code> – Delete option<\/li>set_transient( $name, $value, $expiration )<\/code> – Set transient<\/li>get_transient( $name )<\/code> – Get transient<\/li>delete_transient( $name )<\/code> – Delete transient<\/li><\/ul>Performance Notes<\/h2>Autoload Optimization<\/h3>Large sites should audit autoloaded options:<\/p>sql<\/span><\/use><\/svg><\/button><\/div>SELECT SUM(LENGTH(option_value))\/1024 as kb FROM wp_options WHERE autoload='yes';<\/code><\/pre><\/div>Target: Keep autoload under 1MB total.<\/p>Transient Cleanup<\/h3>Transients without expiration never auto-delete. Periodically clean:<\/p>php<\/span>
blogname<\/code><\/td>Site title<\/td><\/tr>blogdescription<\/code><\/td>Site tagline<\/td><\/tr>admin_email<\/code><\/td>Admin email address<\/td><\/tr>timezone_string<\/code><\/td>Timezone setting<\/td><\/tr>date_format<\/code><\/td>Date display format<\/td><\/tr>time_format<\/code><\/td>Time display format<\/td><\/tr><\/tbody><\/table><\/figure>Reading\/Writing<\/h3>Option<\/th>Description<\/th><\/tr><\/thead>posts_per_page<\/code><\/td>Posts per archive page<\/td><\/tr>posts_per_rss<\/code><\/td>Posts per RSS feed<\/td><\/tr>show_on_front<\/code><\/td>‘posts’ or ‘page’<\/td><\/tr>page_on_front<\/code><\/td>Static front page ID<\/td><\/tr>page_for_posts<\/code><\/td>Blog page ID<\/td><\/tr>default_category<\/code><\/td>Default post category<\/td><\/tr>default_comment_status<\/code><\/td>Default comment status<\/td><\/tr><\/tbody><\/table><\/figure>Permalinks<\/h3>Option<\/th>Description<\/th><\/tr><\/thead>permalink_structure<\/code><\/td>Permalink pattern<\/td><\/tr>category_base<\/code><\/td>Category URL prefix<\/td><\/tr>tag_base<\/code><\/td>Tag URL prefix<\/td><\/tr>rewrite_rules<\/code><\/td>Serialized rewrite rules<\/td><\/tr><\/tbody><\/table><\/figure>Theme\/Appearance<\/h3>Option<\/th>Description<\/th><\/tr><\/thead>template<\/code><\/td>Active theme directory<\/td><\/tr>stylesheet<\/code><\/td>Active child theme directory<\/td><\/tr>current_theme<\/code><\/td>Theme display name<\/td><\/tr>sidebars_widgets<\/code><\/td>Widget assignments<\/td><\/tr>theme_mods_{theme}<\/code><\/td>Theme customization<\/td><\/tr>nav_menu_options<\/code><\/td>Navigation menu settings<\/td><\/tr><\/tbody><\/table><\/figure>Cron & Transients<\/h3>Pattern<\/th>Description<\/th><\/tr><\/thead>cron<\/code><\/td>Scheduled tasks<\/td><\/tr>_transient_{name}<\/code><\/td>Cached data<\/td><\/tr>_transient_timeout_{name}<\/code><\/td>Transient expiration<\/td><\/tr>_site_transient_{name}<\/code><\/td>Network transient<\/td><\/tr><\/tbody><\/table><\/figure>Plugin Settings<\/h3>Plugins typically use patterns like:<\/p>{plugin_slug}_settings<\/code><\/li>{plugin_slug}_options<\/code><\/li>{plugin_slug}_version<\/code><\/li><\/ul>Common Queries<\/h2>Get option value<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_value \nFROM wp_options \nWHERE option_name = 'siteurl';<\/code><\/pre><\/div>Get all autoloaded options<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_name, option_value \nFROM wp_options \nWHERE autoload = 'yes';<\/code><\/pre><\/div>Calculate autoload size<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT \n SUM(LENGTH(option_value)) as total_bytes,\n COUNT(*) as option_count\nFROM wp_options \nWHERE autoload = 'yes';<\/code><\/pre><\/div>Find large options<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_name, LENGTH(option_value) as size_bytes\nFROM wp_options \nORDER BY size_bytes DESC \nLIMIT 20;<\/code><\/pre><\/div>Find expired transients<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT o.option_name, o.option_value\nFROM wp_options o\nJOIN wp_options t ON t.option_name = CONCAT('_transient_timeout_', \n SUBSTRING(o.option_name, 12))\nWHERE o.option_name LIKE '_transient_%'\n AND o.option_name NOT LIKE '_transient_timeout_%'\n AND t.option_value < UNIX_TIMESTAMP();<\/code><\/pre><\/div>Delete expired transients<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>DELETE a, b FROM wp_options a\nLEFT JOIN wp_options b ON b.option_name = CONCAT('_transient_timeout_', \n SUBSTRING(a.option_name, 12))\nWHERE a.option_name LIKE '_transient_%'\n AND a.option_name NOT LIKE '_transient_timeout_%'\n AND b.option_value IS NOT NULL\n AND b.option_value < UNIX_TIMESTAMP();<\/code><\/pre><\/div>Optimize autoload<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>-- Find options that shouldn't autoload\nSELECT option_name, LENGTH(option_value) as size\nFROM wp_options \nWHERE autoload = 'yes' \n AND LENGTH(option_value) > 10000\nORDER BY size DESC;\n\n-- Disable autoload for specific option\nUPDATE wp_options \nSET autoload = 'no' \nWHERE option_name = 'large_serialized_option';<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_option( $option, $default )<\/code> – Get option value<\/li>add_option( $option, $value, $deprecated, $autoload )<\/code> – Add option<\/li>update_option( $option, $value, $autoload )<\/code> – Update\/add option<\/li>delete_option( $option )<\/code> – Delete option<\/li>set_transient( $name, $value, $expiration )<\/code> – Set transient<\/li>get_transient( $name )<\/code> – Get transient<\/li>delete_transient( $name )<\/code> – Delete transient<\/li><\/ul>Performance Notes<\/h2>Autoload Optimization<\/h3>Large sites should audit autoloaded options:<\/p>sql<\/span><\/use><\/svg><\/button><\/div>SELECT SUM(LENGTH(option_value))\/1024 as kb FROM wp_options WHERE autoload='yes';<\/code><\/pre><\/div>Target: Keep autoload under 1MB total.<\/p>Transient Cleanup<\/h3>Transients without expiration never auto-delete. Periodically clean:<\/p>php<\/span>
blogdescription<\/code><\/td>Site tagline<\/td><\/tr>admin_email<\/code><\/td>Admin email address<\/td><\/tr>timezone_string<\/code><\/td>Timezone setting<\/td><\/tr>date_format<\/code><\/td>Date display format<\/td><\/tr>time_format<\/code><\/td>Time display format<\/td><\/tr><\/tbody><\/table><\/figure>Reading\/Writing<\/h3>Option<\/th>Description<\/th><\/tr><\/thead>posts_per_page<\/code><\/td>Posts per archive page<\/td><\/tr>posts_per_rss<\/code><\/td>Posts per RSS feed<\/td><\/tr>show_on_front<\/code><\/td>‘posts’ or ‘page’<\/td><\/tr>page_on_front<\/code><\/td>Static front page ID<\/td><\/tr>page_for_posts<\/code><\/td>Blog page ID<\/td><\/tr>default_category<\/code><\/td>Default post category<\/td><\/tr>default_comment_status<\/code><\/td>Default comment status<\/td><\/tr><\/tbody><\/table><\/figure>Permalinks<\/h3>Option<\/th>Description<\/th><\/tr><\/thead>permalink_structure<\/code><\/td>Permalink pattern<\/td><\/tr>category_base<\/code><\/td>Category URL prefix<\/td><\/tr>tag_base<\/code><\/td>Tag URL prefix<\/td><\/tr>rewrite_rules<\/code><\/td>Serialized rewrite rules<\/td><\/tr><\/tbody><\/table><\/figure>Theme\/Appearance<\/h3>Option<\/th>Description<\/th><\/tr><\/thead>template<\/code><\/td>Active theme directory<\/td><\/tr>stylesheet<\/code><\/td>Active child theme directory<\/td><\/tr>current_theme<\/code><\/td>Theme display name<\/td><\/tr>sidebars_widgets<\/code><\/td>Widget assignments<\/td><\/tr>theme_mods_{theme}<\/code><\/td>Theme customization<\/td><\/tr>nav_menu_options<\/code><\/td>Navigation menu settings<\/td><\/tr><\/tbody><\/table><\/figure>Cron & Transients<\/h3>Pattern<\/th>Description<\/th><\/tr><\/thead>cron<\/code><\/td>Scheduled tasks<\/td><\/tr>_transient_{name}<\/code><\/td>Cached data<\/td><\/tr>_transient_timeout_{name}<\/code><\/td>Transient expiration<\/td><\/tr>_site_transient_{name}<\/code><\/td>Network transient<\/td><\/tr><\/tbody><\/table><\/figure>Plugin Settings<\/h3>Plugins typically use patterns like:<\/p>{plugin_slug}_settings<\/code><\/li>{plugin_slug}_options<\/code><\/li>{plugin_slug}_version<\/code><\/li><\/ul>Common Queries<\/h2>Get option value<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_value \nFROM wp_options \nWHERE option_name = 'siteurl';<\/code><\/pre><\/div>Get all autoloaded options<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_name, option_value \nFROM wp_options \nWHERE autoload = 'yes';<\/code><\/pre><\/div>Calculate autoload size<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT \n SUM(LENGTH(option_value)) as total_bytes,\n COUNT(*) as option_count\nFROM wp_options \nWHERE autoload = 'yes';<\/code><\/pre><\/div>Find large options<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_name, LENGTH(option_value) as size_bytes\nFROM wp_options \nORDER BY size_bytes DESC \nLIMIT 20;<\/code><\/pre><\/div>Find expired transients<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT o.option_name, o.option_value\nFROM wp_options o\nJOIN wp_options t ON t.option_name = CONCAT('_transient_timeout_', \n SUBSTRING(o.option_name, 12))\nWHERE o.option_name LIKE '_transient_%'\n AND o.option_name NOT LIKE '_transient_timeout_%'\n AND t.option_value < UNIX_TIMESTAMP();<\/code><\/pre><\/div>Delete expired transients<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>DELETE a, b FROM wp_options a\nLEFT JOIN wp_options b ON b.option_name = CONCAT('_transient_timeout_', \n SUBSTRING(a.option_name, 12))\nWHERE a.option_name LIKE '_transient_%'\n AND a.option_name NOT LIKE '_transient_timeout_%'\n AND b.option_value IS NOT NULL\n AND b.option_value < UNIX_TIMESTAMP();<\/code><\/pre><\/div>Optimize autoload<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>-- Find options that shouldn't autoload\nSELECT option_name, LENGTH(option_value) as size\nFROM wp_options \nWHERE autoload = 'yes' \n AND LENGTH(option_value) > 10000\nORDER BY size DESC;\n\n-- Disable autoload for specific option\nUPDATE wp_options \nSET autoload = 'no' \nWHERE option_name = 'large_serialized_option';<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_option( $option, $default )<\/code> – Get option value<\/li>add_option( $option, $value, $deprecated, $autoload )<\/code> – Add option<\/li>update_option( $option, $value, $autoload )<\/code> – Update\/add option<\/li>delete_option( $option )<\/code> – Delete option<\/li>set_transient( $name, $value, $expiration )<\/code> – Set transient<\/li>get_transient( $name )<\/code> – Get transient<\/li>delete_transient( $name )<\/code> – Delete transient<\/li><\/ul>Performance Notes<\/h2>Autoload Optimization<\/h3>Large sites should audit autoloaded options:<\/p>sql<\/span><\/use><\/svg><\/button><\/div>SELECT SUM(LENGTH(option_value))\/1024 as kb FROM wp_options WHERE autoload='yes';<\/code><\/pre><\/div>Target: Keep autoload under 1MB total.<\/p>Transient Cleanup<\/h3>Transients without expiration never auto-delete. Periodically clean:<\/p>php<\/span>
admin_email<\/code><\/td>Admin email address<\/td><\/tr>timezone_string<\/code><\/td>Timezone setting<\/td><\/tr>date_format<\/code><\/td>Date display format<\/td><\/tr>time_format<\/code><\/td>Time display format<\/td><\/tr><\/tbody><\/table><\/figure>Reading\/Writing<\/h3>Option<\/th>Description<\/th><\/tr><\/thead>posts_per_page<\/code><\/td>Posts per archive page<\/td><\/tr>posts_per_rss<\/code><\/td>Posts per RSS feed<\/td><\/tr>show_on_front<\/code><\/td>‘posts’ or ‘page’<\/td><\/tr>page_on_front<\/code><\/td>Static front page ID<\/td><\/tr>page_for_posts<\/code><\/td>Blog page ID<\/td><\/tr>default_category<\/code><\/td>Default post category<\/td><\/tr>default_comment_status<\/code><\/td>Default comment status<\/td><\/tr><\/tbody><\/table><\/figure>Permalinks<\/h3>Option<\/th>Description<\/th><\/tr><\/thead>permalink_structure<\/code><\/td>Permalink pattern<\/td><\/tr>category_base<\/code><\/td>Category URL prefix<\/td><\/tr>tag_base<\/code><\/td>Tag URL prefix<\/td><\/tr>rewrite_rules<\/code><\/td>Serialized rewrite rules<\/td><\/tr><\/tbody><\/table><\/figure>Theme\/Appearance<\/h3>Option<\/th>Description<\/th><\/tr><\/thead>template<\/code><\/td>Active theme directory<\/td><\/tr>stylesheet<\/code><\/td>Active child theme directory<\/td><\/tr>current_theme<\/code><\/td>Theme display name<\/td><\/tr>sidebars_widgets<\/code><\/td>Widget assignments<\/td><\/tr>theme_mods_{theme}<\/code><\/td>Theme customization<\/td><\/tr>nav_menu_options<\/code><\/td>Navigation menu settings<\/td><\/tr><\/tbody><\/table><\/figure>Cron & Transients<\/h3>Pattern<\/th>Description<\/th><\/tr><\/thead>cron<\/code><\/td>Scheduled tasks<\/td><\/tr>_transient_{name}<\/code><\/td>Cached data<\/td><\/tr>_transient_timeout_{name}<\/code><\/td>Transient expiration<\/td><\/tr>_site_transient_{name}<\/code><\/td>Network transient<\/td><\/tr><\/tbody><\/table><\/figure>Plugin Settings<\/h3>Plugins typically use patterns like:<\/p>{plugin_slug}_settings<\/code><\/li>{plugin_slug}_options<\/code><\/li>{plugin_slug}_version<\/code><\/li><\/ul>Common Queries<\/h2>Get option value<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_value \nFROM wp_options \nWHERE option_name = 'siteurl';<\/code><\/pre><\/div>Get all autoloaded options<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_name, option_value \nFROM wp_options \nWHERE autoload = 'yes';<\/code><\/pre><\/div>Calculate autoload size<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT \n SUM(LENGTH(option_value)) as total_bytes,\n COUNT(*) as option_count\nFROM wp_options \nWHERE autoload = 'yes';<\/code><\/pre><\/div>Find large options<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_name, LENGTH(option_value) as size_bytes\nFROM wp_options \nORDER BY size_bytes DESC \nLIMIT 20;<\/code><\/pre><\/div>Find expired transients<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT o.option_name, o.option_value\nFROM wp_options o\nJOIN wp_options t ON t.option_name = CONCAT('_transient_timeout_', \n SUBSTRING(o.option_name, 12))\nWHERE o.option_name LIKE '_transient_%'\n AND o.option_name NOT LIKE '_transient_timeout_%'\n AND t.option_value < UNIX_TIMESTAMP();<\/code><\/pre><\/div>Delete expired transients<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>DELETE a, b FROM wp_options a\nLEFT JOIN wp_options b ON b.option_name = CONCAT('_transient_timeout_', \n SUBSTRING(a.option_name, 12))\nWHERE a.option_name LIKE '_transient_%'\n AND a.option_name NOT LIKE '_transient_timeout_%'\n AND b.option_value IS NOT NULL\n AND b.option_value < UNIX_TIMESTAMP();<\/code><\/pre><\/div>Optimize autoload<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>-- Find options that shouldn't autoload\nSELECT option_name, LENGTH(option_value) as size\nFROM wp_options \nWHERE autoload = 'yes' \n AND LENGTH(option_value) > 10000\nORDER BY size DESC;\n\n-- Disable autoload for specific option\nUPDATE wp_options \nSET autoload = 'no' \nWHERE option_name = 'large_serialized_option';<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_option( $option, $default )<\/code> – Get option value<\/li>add_option( $option, $value, $deprecated, $autoload )<\/code> – Add option<\/li>update_option( $option, $value, $autoload )<\/code> – Update\/add option<\/li>delete_option( $option )<\/code> – Delete option<\/li>set_transient( $name, $value, $expiration )<\/code> – Set transient<\/li>get_transient( $name )<\/code> – Get transient<\/li>delete_transient( $name )<\/code> – Delete transient<\/li><\/ul>Performance Notes<\/h2>Autoload Optimization<\/h3>Large sites should audit autoloaded options:<\/p>sql<\/span><\/use><\/svg><\/button><\/div>SELECT SUM(LENGTH(option_value))\/1024 as kb FROM wp_options WHERE autoload='yes';<\/code><\/pre><\/div>Target: Keep autoload under 1MB total.<\/p>Transient Cleanup<\/h3>Transients without expiration never auto-delete. Periodically clean:<\/p>php<\/span>
timezone_string<\/code><\/td>Timezone setting<\/td><\/tr>date_format<\/code><\/td>Date display format<\/td><\/tr>time_format<\/code><\/td>Time display format<\/td><\/tr><\/tbody><\/table><\/figure>Reading\/Writing<\/h3>Option<\/th>Description<\/th><\/tr><\/thead>posts_per_page<\/code><\/td>Posts per archive page<\/td><\/tr>posts_per_rss<\/code><\/td>Posts per RSS feed<\/td><\/tr>show_on_front<\/code><\/td>‘posts’ or ‘page’<\/td><\/tr>page_on_front<\/code><\/td>Static front page ID<\/td><\/tr>page_for_posts<\/code><\/td>Blog page ID<\/td><\/tr>default_category<\/code><\/td>Default post category<\/td><\/tr>default_comment_status<\/code><\/td>Default comment status<\/td><\/tr><\/tbody><\/table><\/figure>Permalinks<\/h3>Option<\/th>Description<\/th><\/tr><\/thead>permalink_structure<\/code><\/td>Permalink pattern<\/td><\/tr>category_base<\/code><\/td>Category URL prefix<\/td><\/tr>tag_base<\/code><\/td>Tag URL prefix<\/td><\/tr>rewrite_rules<\/code><\/td>Serialized rewrite rules<\/td><\/tr><\/tbody><\/table><\/figure>Theme\/Appearance<\/h3>Option<\/th>Description<\/th><\/tr><\/thead>template<\/code><\/td>Active theme directory<\/td><\/tr>stylesheet<\/code><\/td>Active child theme directory<\/td><\/tr>current_theme<\/code><\/td>Theme display name<\/td><\/tr>sidebars_widgets<\/code><\/td>Widget assignments<\/td><\/tr>theme_mods_{theme}<\/code><\/td>Theme customization<\/td><\/tr>nav_menu_options<\/code><\/td>Navigation menu settings<\/td><\/tr><\/tbody><\/table><\/figure>Cron & Transients<\/h3>Pattern<\/th>Description<\/th><\/tr><\/thead>cron<\/code><\/td>Scheduled tasks<\/td><\/tr>_transient_{name}<\/code><\/td>Cached data<\/td><\/tr>_transient_timeout_{name}<\/code><\/td>Transient expiration<\/td><\/tr>_site_transient_{name}<\/code><\/td>Network transient<\/td><\/tr><\/tbody><\/table><\/figure>Plugin Settings<\/h3>Plugins typically use patterns like:<\/p>{plugin_slug}_settings<\/code><\/li>{plugin_slug}_options<\/code><\/li>{plugin_slug}_version<\/code><\/li><\/ul>Common Queries<\/h2>Get option value<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_value \nFROM wp_options \nWHERE option_name = 'siteurl';<\/code><\/pre><\/div>Get all autoloaded options<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_name, option_value \nFROM wp_options \nWHERE autoload = 'yes';<\/code><\/pre><\/div>Calculate autoload size<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT \n SUM(LENGTH(option_value)) as total_bytes,\n COUNT(*) as option_count\nFROM wp_options \nWHERE autoload = 'yes';<\/code><\/pre><\/div>Find large options<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_name, LENGTH(option_value) as size_bytes\nFROM wp_options \nORDER BY size_bytes DESC \nLIMIT 20;<\/code><\/pre><\/div>Find expired transients<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT o.option_name, o.option_value\nFROM wp_options o\nJOIN wp_options t ON t.option_name = CONCAT('_transient_timeout_', \n SUBSTRING(o.option_name, 12))\nWHERE o.option_name LIKE '_transient_%'\n AND o.option_name NOT LIKE '_transient_timeout_%'\n AND t.option_value < UNIX_TIMESTAMP();<\/code><\/pre><\/div>Delete expired transients<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>DELETE a, b FROM wp_options a\nLEFT JOIN wp_options b ON b.option_name = CONCAT('_transient_timeout_', \n SUBSTRING(a.option_name, 12))\nWHERE a.option_name LIKE '_transient_%'\n AND a.option_name NOT LIKE '_transient_timeout_%'\n AND b.option_value IS NOT NULL\n AND b.option_value < UNIX_TIMESTAMP();<\/code><\/pre><\/div>Optimize autoload<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>-- Find options that shouldn't autoload\nSELECT option_name, LENGTH(option_value) as size\nFROM wp_options \nWHERE autoload = 'yes' \n AND LENGTH(option_value) > 10000\nORDER BY size DESC;\n\n-- Disable autoload for specific option\nUPDATE wp_options \nSET autoload = 'no' \nWHERE option_name = 'large_serialized_option';<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_option( $option, $default )<\/code> – Get option value<\/li>add_option( $option, $value, $deprecated, $autoload )<\/code> – Add option<\/li>update_option( $option, $value, $autoload )<\/code> – Update\/add option<\/li>delete_option( $option )<\/code> – Delete option<\/li>set_transient( $name, $value, $expiration )<\/code> – Set transient<\/li>get_transient( $name )<\/code> – Get transient<\/li>delete_transient( $name )<\/code> – Delete transient<\/li><\/ul>Performance Notes<\/h2>Autoload Optimization<\/h3>Large sites should audit autoloaded options:<\/p>sql<\/span><\/use><\/svg><\/button><\/div>SELECT SUM(LENGTH(option_value))\/1024 as kb FROM wp_options WHERE autoload='yes';<\/code><\/pre><\/div>Target: Keep autoload under 1MB total.<\/p>Transient Cleanup<\/h3>Transients without expiration never auto-delete. Periodically clean:<\/p>php<\/span>
date_format<\/code><\/td>Date display format<\/td><\/tr>time_format<\/code><\/td>Time display format<\/td><\/tr><\/tbody><\/table><\/figure>Reading\/Writing<\/h3>Option<\/th>Description<\/th><\/tr><\/thead>posts_per_page<\/code><\/td>Posts per archive page<\/td><\/tr>posts_per_rss<\/code><\/td>Posts per RSS feed<\/td><\/tr>show_on_front<\/code><\/td>‘posts’ or ‘page’<\/td><\/tr>page_on_front<\/code><\/td>Static front page ID<\/td><\/tr>page_for_posts<\/code><\/td>Blog page ID<\/td><\/tr>default_category<\/code><\/td>Default post category<\/td><\/tr>default_comment_status<\/code><\/td>Default comment status<\/td><\/tr><\/tbody><\/table><\/figure>Permalinks<\/h3>Option<\/th>Description<\/th><\/tr><\/thead>permalink_structure<\/code><\/td>Permalink pattern<\/td><\/tr>category_base<\/code><\/td>Category URL prefix<\/td><\/tr>tag_base<\/code><\/td>Tag URL prefix<\/td><\/tr>rewrite_rules<\/code><\/td>Serialized rewrite rules<\/td><\/tr><\/tbody><\/table><\/figure>Theme\/Appearance<\/h3>Option<\/th>Description<\/th><\/tr><\/thead>template<\/code><\/td>Active theme directory<\/td><\/tr>stylesheet<\/code><\/td>Active child theme directory<\/td><\/tr>current_theme<\/code><\/td>Theme display name<\/td><\/tr>sidebars_widgets<\/code><\/td>Widget assignments<\/td><\/tr>theme_mods_{theme}<\/code><\/td>Theme customization<\/td><\/tr>nav_menu_options<\/code><\/td>Navigation menu settings<\/td><\/tr><\/tbody><\/table><\/figure>Cron & Transients<\/h3>Pattern<\/th>Description<\/th><\/tr><\/thead>cron<\/code><\/td>Scheduled tasks<\/td><\/tr>_transient_{name}<\/code><\/td>Cached data<\/td><\/tr>_transient_timeout_{name}<\/code><\/td>Transient expiration<\/td><\/tr>_site_transient_{name}<\/code><\/td>Network transient<\/td><\/tr><\/tbody><\/table><\/figure>Plugin Settings<\/h3>Plugins typically use patterns like:<\/p>{plugin_slug}_settings<\/code><\/li>{plugin_slug}_options<\/code><\/li>{plugin_slug}_version<\/code><\/li><\/ul>Common Queries<\/h2>Get option value<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_value \nFROM wp_options \nWHERE option_name = 'siteurl';<\/code><\/pre><\/div>Get all autoloaded options<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_name, option_value \nFROM wp_options \nWHERE autoload = 'yes';<\/code><\/pre><\/div>Calculate autoload size<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT \n SUM(LENGTH(option_value)) as total_bytes,\n COUNT(*) as option_count\nFROM wp_options \nWHERE autoload = 'yes';<\/code><\/pre><\/div>Find large options<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_name, LENGTH(option_value) as size_bytes\nFROM wp_options \nORDER BY size_bytes DESC \nLIMIT 20;<\/code><\/pre><\/div>Find expired transients<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT o.option_name, o.option_value\nFROM wp_options o\nJOIN wp_options t ON t.option_name = CONCAT('_transient_timeout_', \n SUBSTRING(o.option_name, 12))\nWHERE o.option_name LIKE '_transient_%'\n AND o.option_name NOT LIKE '_transient_timeout_%'\n AND t.option_value < UNIX_TIMESTAMP();<\/code><\/pre><\/div>Delete expired transients<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>DELETE a, b FROM wp_options a\nLEFT JOIN wp_options b ON b.option_name = CONCAT('_transient_timeout_', \n SUBSTRING(a.option_name, 12))\nWHERE a.option_name LIKE '_transient_%'\n AND a.option_name NOT LIKE '_transient_timeout_%'\n AND b.option_value IS NOT NULL\n AND b.option_value < UNIX_TIMESTAMP();<\/code><\/pre><\/div>Optimize autoload<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>-- Find options that shouldn't autoload\nSELECT option_name, LENGTH(option_value) as size\nFROM wp_options \nWHERE autoload = 'yes' \n AND LENGTH(option_value) > 10000\nORDER BY size DESC;\n\n-- Disable autoload for specific option\nUPDATE wp_options \nSET autoload = 'no' \nWHERE option_name = 'large_serialized_option';<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_option( $option, $default )<\/code> – Get option value<\/li>add_option( $option, $value, $deprecated, $autoload )<\/code> – Add option<\/li>update_option( $option, $value, $autoload )<\/code> – Update\/add option<\/li>delete_option( $option )<\/code> – Delete option<\/li>set_transient( $name, $value, $expiration )<\/code> – Set transient<\/li>get_transient( $name )<\/code> – Get transient<\/li>delete_transient( $name )<\/code> – Delete transient<\/li><\/ul>Performance Notes<\/h2>Autoload Optimization<\/h3>Large sites should audit autoloaded options:<\/p>sql<\/span><\/use><\/svg><\/button><\/div>SELECT SUM(LENGTH(option_value))\/1024 as kb FROM wp_options WHERE autoload='yes';<\/code><\/pre><\/div>Target: Keep autoload under 1MB total.<\/p>Transient Cleanup<\/h3>Transients without expiration never auto-delete. Periodically clean:<\/p>php<\/span>
time_format<\/code><\/td>Time display format<\/td><\/tr><\/tbody><\/table><\/figure>Reading\/Writing<\/h3>Option<\/th>Description<\/th><\/tr><\/thead>posts_per_page<\/code><\/td>Posts per archive page<\/td><\/tr>posts_per_rss<\/code><\/td>Posts per RSS feed<\/td><\/tr>show_on_front<\/code><\/td>‘posts’ or ‘page’<\/td><\/tr>page_on_front<\/code><\/td>Static front page ID<\/td><\/tr>page_for_posts<\/code><\/td>Blog page ID<\/td><\/tr>default_category<\/code><\/td>Default post category<\/td><\/tr>default_comment_status<\/code><\/td>Default comment status<\/td><\/tr><\/tbody><\/table><\/figure>Permalinks<\/h3>Option<\/th>Description<\/th><\/tr><\/thead>permalink_structure<\/code><\/td>Permalink pattern<\/td><\/tr>category_base<\/code><\/td>Category URL prefix<\/td><\/tr>tag_base<\/code><\/td>Tag URL prefix<\/td><\/tr>rewrite_rules<\/code><\/td>Serialized rewrite rules<\/td><\/tr><\/tbody><\/table><\/figure>Theme\/Appearance<\/h3>Option<\/th>Description<\/th><\/tr><\/thead>template<\/code><\/td>Active theme directory<\/td><\/tr>stylesheet<\/code><\/td>Active child theme directory<\/td><\/tr>current_theme<\/code><\/td>Theme display name<\/td><\/tr>sidebars_widgets<\/code><\/td>Widget assignments<\/td><\/tr>theme_mods_{theme}<\/code><\/td>Theme customization<\/td><\/tr>nav_menu_options<\/code><\/td>Navigation menu settings<\/td><\/tr><\/tbody><\/table><\/figure>Cron & Transients<\/h3>Pattern<\/th>Description<\/th><\/tr><\/thead>cron<\/code><\/td>Scheduled tasks<\/td><\/tr>_transient_{name}<\/code><\/td>Cached data<\/td><\/tr>_transient_timeout_{name}<\/code><\/td>Transient expiration<\/td><\/tr>_site_transient_{name}<\/code><\/td>Network transient<\/td><\/tr><\/tbody><\/table><\/figure>Plugin Settings<\/h3>Plugins typically use patterns like:<\/p>{plugin_slug}_settings<\/code><\/li>{plugin_slug}_options<\/code><\/li>{plugin_slug}_version<\/code><\/li><\/ul>Common Queries<\/h2>Get option value<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_value \nFROM wp_options \nWHERE option_name = 'siteurl';<\/code><\/pre><\/div>Get all autoloaded options<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_name, option_value \nFROM wp_options \nWHERE autoload = 'yes';<\/code><\/pre><\/div>Calculate autoload size<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT \n SUM(LENGTH(option_value)) as total_bytes,\n COUNT(*) as option_count\nFROM wp_options \nWHERE autoload = 'yes';<\/code><\/pre><\/div>Find large options<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_name, LENGTH(option_value) as size_bytes\nFROM wp_options \nORDER BY size_bytes DESC \nLIMIT 20;<\/code><\/pre><\/div>Find expired transients<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT o.option_name, o.option_value\nFROM wp_options o\nJOIN wp_options t ON t.option_name = CONCAT('_transient_timeout_', \n SUBSTRING(o.option_name, 12))\nWHERE o.option_name LIKE '_transient_%'\n AND o.option_name NOT LIKE '_transient_timeout_%'\n AND t.option_value < UNIX_TIMESTAMP();<\/code><\/pre><\/div>Delete expired transients<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>DELETE a, b FROM wp_options a\nLEFT JOIN wp_options b ON b.option_name = CONCAT('_transient_timeout_', \n SUBSTRING(a.option_name, 12))\nWHERE a.option_name LIKE '_transient_%'\n AND a.option_name NOT LIKE '_transient_timeout_%'\n AND b.option_value IS NOT NULL\n AND b.option_value < UNIX_TIMESTAMP();<\/code><\/pre><\/div>Optimize autoload<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>-- Find options that shouldn't autoload\nSELECT option_name, LENGTH(option_value) as size\nFROM wp_options \nWHERE autoload = 'yes' \n AND LENGTH(option_value) > 10000\nORDER BY size DESC;\n\n-- Disable autoload for specific option\nUPDATE wp_options \nSET autoload = 'no' \nWHERE option_name = 'large_serialized_option';<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_option( $option, $default )<\/code> – Get option value<\/li>add_option( $option, $value, $deprecated, $autoload )<\/code> – Add option<\/li>update_option( $option, $value, $autoload )<\/code> – Update\/add option<\/li>delete_option( $option )<\/code> – Delete option<\/li>set_transient( $name, $value, $expiration )<\/code> – Set transient<\/li>get_transient( $name )<\/code> – Get transient<\/li>delete_transient( $name )<\/code> – Delete transient<\/li><\/ul>Performance Notes<\/h2>Autoload Optimization<\/h3>Large sites should audit autoloaded options:<\/p>sql<\/span><\/use><\/svg><\/button><\/div>SELECT SUM(LENGTH(option_value))\/1024 as kb FROM wp_options WHERE autoload='yes';<\/code><\/pre><\/div>Target: Keep autoload under 1MB total.<\/p>Transient Cleanup<\/h3>Transients without expiration never auto-delete. Periodically clean:<\/p>php<\/span>
posts_per_page<\/code><\/td>Posts per archive page<\/td><\/tr>posts_per_rss<\/code><\/td>Posts per RSS feed<\/td><\/tr>show_on_front<\/code><\/td>‘posts’ or ‘page’<\/td><\/tr>page_on_front<\/code><\/td>Static front page ID<\/td><\/tr>page_for_posts<\/code><\/td>Blog page ID<\/td><\/tr>default_category<\/code><\/td>Default post category<\/td><\/tr>default_comment_status<\/code><\/td>Default comment status<\/td><\/tr><\/tbody><\/table><\/figure>Permalinks<\/h3>Option<\/th>Description<\/th><\/tr><\/thead>permalink_structure<\/code><\/td>Permalink pattern<\/td><\/tr>category_base<\/code><\/td>Category URL prefix<\/td><\/tr>tag_base<\/code><\/td>Tag URL prefix<\/td><\/tr>rewrite_rules<\/code><\/td>Serialized rewrite rules<\/td><\/tr><\/tbody><\/table><\/figure>Theme\/Appearance<\/h3>Option<\/th>Description<\/th><\/tr><\/thead>template<\/code><\/td>Active theme directory<\/td><\/tr>stylesheet<\/code><\/td>Active child theme directory<\/td><\/tr>current_theme<\/code><\/td>Theme display name<\/td><\/tr>sidebars_widgets<\/code><\/td>Widget assignments<\/td><\/tr>theme_mods_{theme}<\/code><\/td>Theme customization<\/td><\/tr>nav_menu_options<\/code><\/td>Navigation menu settings<\/td><\/tr><\/tbody><\/table><\/figure>Cron & Transients<\/h3>Pattern<\/th>Description<\/th><\/tr><\/thead>cron<\/code><\/td>Scheduled tasks<\/td><\/tr>_transient_{name}<\/code><\/td>Cached data<\/td><\/tr>_transient_timeout_{name}<\/code><\/td>Transient expiration<\/td><\/tr>_site_transient_{name}<\/code><\/td>Network transient<\/td><\/tr><\/tbody><\/table><\/figure>Plugin Settings<\/h3>Plugins typically use patterns like:<\/p>{plugin_slug}_settings<\/code><\/li>{plugin_slug}_options<\/code><\/li>{plugin_slug}_version<\/code><\/li><\/ul>Common Queries<\/h2>Get option value<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_value \nFROM wp_options \nWHERE option_name = 'siteurl';<\/code><\/pre><\/div>Get all autoloaded options<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_name, option_value \nFROM wp_options \nWHERE autoload = 'yes';<\/code><\/pre><\/div>Calculate autoload size<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT \n SUM(LENGTH(option_value)) as total_bytes,\n COUNT(*) as option_count\nFROM wp_options \nWHERE autoload = 'yes';<\/code><\/pre><\/div>Find large options<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_name, LENGTH(option_value) as size_bytes\nFROM wp_options \nORDER BY size_bytes DESC \nLIMIT 20;<\/code><\/pre><\/div>Find expired transients<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT o.option_name, o.option_value\nFROM wp_options o\nJOIN wp_options t ON t.option_name = CONCAT('_transient_timeout_', \n SUBSTRING(o.option_name, 12))\nWHERE o.option_name LIKE '_transient_%'\n AND o.option_name NOT LIKE '_transient_timeout_%'\n AND t.option_value < UNIX_TIMESTAMP();<\/code><\/pre><\/div>Delete expired transients<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>DELETE a, b FROM wp_options a\nLEFT JOIN wp_options b ON b.option_name = CONCAT('_transient_timeout_', \n SUBSTRING(a.option_name, 12))\nWHERE a.option_name LIKE '_transient_%'\n AND a.option_name NOT LIKE '_transient_timeout_%'\n AND b.option_value IS NOT NULL\n AND b.option_value < UNIX_TIMESTAMP();<\/code><\/pre><\/div>Optimize autoload<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>-- Find options that shouldn't autoload\nSELECT option_name, LENGTH(option_value) as size\nFROM wp_options \nWHERE autoload = 'yes' \n AND LENGTH(option_value) > 10000\nORDER BY size DESC;\n\n-- Disable autoload for specific option\nUPDATE wp_options \nSET autoload = 'no' \nWHERE option_name = 'large_serialized_option';<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_option( $option, $default )<\/code> – Get option value<\/li>add_option( $option, $value, $deprecated, $autoload )<\/code> – Add option<\/li>update_option( $option, $value, $autoload )<\/code> – Update\/add option<\/li>delete_option( $option )<\/code> – Delete option<\/li>set_transient( $name, $value, $expiration )<\/code> – Set transient<\/li>get_transient( $name )<\/code> – Get transient<\/li>delete_transient( $name )<\/code> – Delete transient<\/li><\/ul>Performance Notes<\/h2>Autoload Optimization<\/h3>Large sites should audit autoloaded options:<\/p>sql<\/span><\/use><\/svg><\/button><\/div>SELECT SUM(LENGTH(option_value))\/1024 as kb FROM wp_options WHERE autoload='yes';<\/code><\/pre><\/div>Target: Keep autoload under 1MB total.<\/p>Transient Cleanup<\/h3>Transients without expiration never auto-delete. Periodically clean:<\/p>php<\/span>
posts_per_rss<\/code><\/td>Posts per RSS feed<\/td><\/tr>show_on_front<\/code><\/td>‘posts’ or ‘page’<\/td><\/tr>page_on_front<\/code><\/td>Static front page ID<\/td><\/tr>page_for_posts<\/code><\/td>Blog page ID<\/td><\/tr>default_category<\/code><\/td>Default post category<\/td><\/tr>default_comment_status<\/code><\/td>Default comment status<\/td><\/tr><\/tbody><\/table><\/figure>Permalinks<\/h3>Option<\/th>Description<\/th><\/tr><\/thead>permalink_structure<\/code><\/td>Permalink pattern<\/td><\/tr>category_base<\/code><\/td>Category URL prefix<\/td><\/tr>tag_base<\/code><\/td>Tag URL prefix<\/td><\/tr>rewrite_rules<\/code><\/td>Serialized rewrite rules<\/td><\/tr><\/tbody><\/table><\/figure>Theme\/Appearance<\/h3>Option<\/th>Description<\/th><\/tr><\/thead>template<\/code><\/td>Active theme directory<\/td><\/tr>stylesheet<\/code><\/td>Active child theme directory<\/td><\/tr>current_theme<\/code><\/td>Theme display name<\/td><\/tr>sidebars_widgets<\/code><\/td>Widget assignments<\/td><\/tr>theme_mods_{theme}<\/code><\/td>Theme customization<\/td><\/tr>nav_menu_options<\/code><\/td>Navigation menu settings<\/td><\/tr><\/tbody><\/table><\/figure>Cron & Transients<\/h3>Pattern<\/th>Description<\/th><\/tr><\/thead>cron<\/code><\/td>Scheduled tasks<\/td><\/tr>_transient_{name}<\/code><\/td>Cached data<\/td><\/tr>_transient_timeout_{name}<\/code><\/td>Transient expiration<\/td><\/tr>_site_transient_{name}<\/code><\/td>Network transient<\/td><\/tr><\/tbody><\/table><\/figure>Plugin Settings<\/h3>Plugins typically use patterns like:<\/p>{plugin_slug}_settings<\/code><\/li>{plugin_slug}_options<\/code><\/li>{plugin_slug}_version<\/code><\/li><\/ul>Common Queries<\/h2>Get option value<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_value \nFROM wp_options \nWHERE option_name = 'siteurl';<\/code><\/pre><\/div>Get all autoloaded options<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_name, option_value \nFROM wp_options \nWHERE autoload = 'yes';<\/code><\/pre><\/div>Calculate autoload size<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT \n SUM(LENGTH(option_value)) as total_bytes,\n COUNT(*) as option_count\nFROM wp_options \nWHERE autoload = 'yes';<\/code><\/pre><\/div>Find large options<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_name, LENGTH(option_value) as size_bytes\nFROM wp_options \nORDER BY size_bytes DESC \nLIMIT 20;<\/code><\/pre><\/div>Find expired transients<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT o.option_name, o.option_value\nFROM wp_options o\nJOIN wp_options t ON t.option_name = CONCAT('_transient_timeout_', \n SUBSTRING(o.option_name, 12))\nWHERE o.option_name LIKE '_transient_%'\n AND o.option_name NOT LIKE '_transient_timeout_%'\n AND t.option_value < UNIX_TIMESTAMP();<\/code><\/pre><\/div>Delete expired transients<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>DELETE a, b FROM wp_options a\nLEFT JOIN wp_options b ON b.option_name = CONCAT('_transient_timeout_', \n SUBSTRING(a.option_name, 12))\nWHERE a.option_name LIKE '_transient_%'\n AND a.option_name NOT LIKE '_transient_timeout_%'\n AND b.option_value IS NOT NULL\n AND b.option_value < UNIX_TIMESTAMP();<\/code><\/pre><\/div>Optimize autoload<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>-- Find options that shouldn't autoload\nSELECT option_name, LENGTH(option_value) as size\nFROM wp_options \nWHERE autoload = 'yes' \n AND LENGTH(option_value) > 10000\nORDER BY size DESC;\n\n-- Disable autoload for specific option\nUPDATE wp_options \nSET autoload = 'no' \nWHERE option_name = 'large_serialized_option';<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_option( $option, $default )<\/code> – Get option value<\/li>add_option( $option, $value, $deprecated, $autoload )<\/code> – Add option<\/li>update_option( $option, $value, $autoload )<\/code> – Update\/add option<\/li>delete_option( $option )<\/code> – Delete option<\/li>set_transient( $name, $value, $expiration )<\/code> – Set transient<\/li>get_transient( $name )<\/code> – Get transient<\/li>delete_transient( $name )<\/code> – Delete transient<\/li><\/ul>Performance Notes<\/h2>Autoload Optimization<\/h3>Large sites should audit autoloaded options:<\/p>sql<\/span><\/use><\/svg><\/button><\/div>SELECT SUM(LENGTH(option_value))\/1024 as kb FROM wp_options WHERE autoload='yes';<\/code><\/pre><\/div>Target: Keep autoload under 1MB total.<\/p>Transient Cleanup<\/h3>Transients without expiration never auto-delete. Periodically clean:<\/p>php<\/span>
show_on_front<\/code><\/td>‘posts’ or ‘page’<\/td><\/tr>page_on_front<\/code><\/td>Static front page ID<\/td><\/tr>page_for_posts<\/code><\/td>Blog page ID<\/td><\/tr>default_category<\/code><\/td>Default post category<\/td><\/tr>default_comment_status<\/code><\/td>Default comment status<\/td><\/tr><\/tbody><\/table><\/figure>Permalinks<\/h3>Option<\/th>Description<\/th><\/tr><\/thead>permalink_structure<\/code><\/td>Permalink pattern<\/td><\/tr>category_base<\/code><\/td>Category URL prefix<\/td><\/tr>tag_base<\/code><\/td>Tag URL prefix<\/td><\/tr>rewrite_rules<\/code><\/td>Serialized rewrite rules<\/td><\/tr><\/tbody><\/table><\/figure>Theme\/Appearance<\/h3>Option<\/th>Description<\/th><\/tr><\/thead>template<\/code><\/td>Active theme directory<\/td><\/tr>stylesheet<\/code><\/td>Active child theme directory<\/td><\/tr>current_theme<\/code><\/td>Theme display name<\/td><\/tr>sidebars_widgets<\/code><\/td>Widget assignments<\/td><\/tr>theme_mods_{theme}<\/code><\/td>Theme customization<\/td><\/tr>nav_menu_options<\/code><\/td>Navigation menu settings<\/td><\/tr><\/tbody><\/table><\/figure>Cron & Transients<\/h3>Pattern<\/th>Description<\/th><\/tr><\/thead>cron<\/code><\/td>Scheduled tasks<\/td><\/tr>_transient_{name}<\/code><\/td>Cached data<\/td><\/tr>_transient_timeout_{name}<\/code><\/td>Transient expiration<\/td><\/tr>_site_transient_{name}<\/code><\/td>Network transient<\/td><\/tr><\/tbody><\/table><\/figure>Plugin Settings<\/h3>Plugins typically use patterns like:<\/p>{plugin_slug}_settings<\/code><\/li>{plugin_slug}_options<\/code><\/li>{plugin_slug}_version<\/code><\/li><\/ul>Common Queries<\/h2>Get option value<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_value \nFROM wp_options \nWHERE option_name = 'siteurl';<\/code><\/pre><\/div>Get all autoloaded options<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_name, option_value \nFROM wp_options \nWHERE autoload = 'yes';<\/code><\/pre><\/div>Calculate autoload size<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT \n SUM(LENGTH(option_value)) as total_bytes,\n COUNT(*) as option_count\nFROM wp_options \nWHERE autoload = 'yes';<\/code><\/pre><\/div>Find large options<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_name, LENGTH(option_value) as size_bytes\nFROM wp_options \nORDER BY size_bytes DESC \nLIMIT 20;<\/code><\/pre><\/div>Find expired transients<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT o.option_name, o.option_value\nFROM wp_options o\nJOIN wp_options t ON t.option_name = CONCAT('_transient_timeout_', \n SUBSTRING(o.option_name, 12))\nWHERE o.option_name LIKE '_transient_%'\n AND o.option_name NOT LIKE '_transient_timeout_%'\n AND t.option_value < UNIX_TIMESTAMP();<\/code><\/pre><\/div>Delete expired transients<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>DELETE a, b FROM wp_options a\nLEFT JOIN wp_options b ON b.option_name = CONCAT('_transient_timeout_', \n SUBSTRING(a.option_name, 12))\nWHERE a.option_name LIKE '_transient_%'\n AND a.option_name NOT LIKE '_transient_timeout_%'\n AND b.option_value IS NOT NULL\n AND b.option_value < UNIX_TIMESTAMP();<\/code><\/pre><\/div>Optimize autoload<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>-- Find options that shouldn't autoload\nSELECT option_name, LENGTH(option_value) as size\nFROM wp_options \nWHERE autoload = 'yes' \n AND LENGTH(option_value) > 10000\nORDER BY size DESC;\n\n-- Disable autoload for specific option\nUPDATE wp_options \nSET autoload = 'no' \nWHERE option_name = 'large_serialized_option';<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_option( $option, $default )<\/code> – Get option value<\/li>add_option( $option, $value, $deprecated, $autoload )<\/code> – Add option<\/li>update_option( $option, $value, $autoload )<\/code> – Update\/add option<\/li>delete_option( $option )<\/code> – Delete option<\/li>set_transient( $name, $value, $expiration )<\/code> – Set transient<\/li>get_transient( $name )<\/code> – Get transient<\/li>delete_transient( $name )<\/code> – Delete transient<\/li><\/ul>Performance Notes<\/h2>Autoload Optimization<\/h3>Large sites should audit autoloaded options:<\/p>sql<\/span><\/use><\/svg><\/button><\/div>SELECT SUM(LENGTH(option_value))\/1024 as kb FROM wp_options WHERE autoload='yes';<\/code><\/pre><\/div>Target: Keep autoload under 1MB total.<\/p>Transient Cleanup<\/h3>Transients without expiration never auto-delete. Periodically clean:<\/p>php<\/span>
page_on_front<\/code><\/td>Static front page ID<\/td><\/tr>page_for_posts<\/code><\/td>Blog page ID<\/td><\/tr>default_category<\/code><\/td>Default post category<\/td><\/tr>default_comment_status<\/code><\/td>Default comment status<\/td><\/tr><\/tbody><\/table><\/figure>Permalinks<\/h3>Option<\/th>Description<\/th><\/tr><\/thead>permalink_structure<\/code><\/td>Permalink pattern<\/td><\/tr>category_base<\/code><\/td>Category URL prefix<\/td><\/tr>tag_base<\/code><\/td>Tag URL prefix<\/td><\/tr>rewrite_rules<\/code><\/td>Serialized rewrite rules<\/td><\/tr><\/tbody><\/table><\/figure>Theme\/Appearance<\/h3>Option<\/th>Description<\/th><\/tr><\/thead>template<\/code><\/td>Active theme directory<\/td><\/tr>stylesheet<\/code><\/td>Active child theme directory<\/td><\/tr>current_theme<\/code><\/td>Theme display name<\/td><\/tr>sidebars_widgets<\/code><\/td>Widget assignments<\/td><\/tr>theme_mods_{theme}<\/code><\/td>Theme customization<\/td><\/tr>nav_menu_options<\/code><\/td>Navigation menu settings<\/td><\/tr><\/tbody><\/table><\/figure>Cron & Transients<\/h3>Pattern<\/th>Description<\/th><\/tr><\/thead>cron<\/code><\/td>Scheduled tasks<\/td><\/tr>_transient_{name}<\/code><\/td>Cached data<\/td><\/tr>_transient_timeout_{name}<\/code><\/td>Transient expiration<\/td><\/tr>_site_transient_{name}<\/code><\/td>Network transient<\/td><\/tr><\/tbody><\/table><\/figure>Plugin Settings<\/h3>Plugins typically use patterns like:<\/p>{plugin_slug}_settings<\/code><\/li>{plugin_slug}_options<\/code><\/li>{plugin_slug}_version<\/code><\/li><\/ul>Common Queries<\/h2>Get option value<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_value \nFROM wp_options \nWHERE option_name = 'siteurl';<\/code><\/pre><\/div>Get all autoloaded options<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_name, option_value \nFROM wp_options \nWHERE autoload = 'yes';<\/code><\/pre><\/div>Calculate autoload size<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT \n SUM(LENGTH(option_value)) as total_bytes,\n COUNT(*) as option_count\nFROM wp_options \nWHERE autoload = 'yes';<\/code><\/pre><\/div>Find large options<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_name, LENGTH(option_value) as size_bytes\nFROM wp_options \nORDER BY size_bytes DESC \nLIMIT 20;<\/code><\/pre><\/div>Find expired transients<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT o.option_name, o.option_value\nFROM wp_options o\nJOIN wp_options t ON t.option_name = CONCAT('_transient_timeout_', \n SUBSTRING(o.option_name, 12))\nWHERE o.option_name LIKE '_transient_%'\n AND o.option_name NOT LIKE '_transient_timeout_%'\n AND t.option_value < UNIX_TIMESTAMP();<\/code><\/pre><\/div>Delete expired transients<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>DELETE a, b FROM wp_options a\nLEFT JOIN wp_options b ON b.option_name = CONCAT('_transient_timeout_', \n SUBSTRING(a.option_name, 12))\nWHERE a.option_name LIKE '_transient_%'\n AND a.option_name NOT LIKE '_transient_timeout_%'\n AND b.option_value IS NOT NULL\n AND b.option_value < UNIX_TIMESTAMP();<\/code><\/pre><\/div>Optimize autoload<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>-- Find options that shouldn't autoload\nSELECT option_name, LENGTH(option_value) as size\nFROM wp_options \nWHERE autoload = 'yes' \n AND LENGTH(option_value) > 10000\nORDER BY size DESC;\n\n-- Disable autoload for specific option\nUPDATE wp_options \nSET autoload = 'no' \nWHERE option_name = 'large_serialized_option';<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_option( $option, $default )<\/code> – Get option value<\/li>add_option( $option, $value, $deprecated, $autoload )<\/code> – Add option<\/li>update_option( $option, $value, $autoload )<\/code> – Update\/add option<\/li>delete_option( $option )<\/code> – Delete option<\/li>set_transient( $name, $value, $expiration )<\/code> – Set transient<\/li>get_transient( $name )<\/code> – Get transient<\/li>delete_transient( $name )<\/code> – Delete transient<\/li><\/ul>Performance Notes<\/h2>Autoload Optimization<\/h3>Large sites should audit autoloaded options:<\/p>sql<\/span><\/use><\/svg><\/button><\/div>SELECT SUM(LENGTH(option_value))\/1024 as kb FROM wp_options WHERE autoload='yes';<\/code><\/pre><\/div>Target: Keep autoload under 1MB total.<\/p>Transient Cleanup<\/h3>Transients without expiration never auto-delete. Periodically clean:<\/p>php<\/span>
page_for_posts<\/code><\/td>Blog page ID<\/td><\/tr>default_category<\/code><\/td>Default post category<\/td><\/tr>default_comment_status<\/code><\/td>Default comment status<\/td><\/tr><\/tbody><\/table><\/figure>Permalinks<\/h3>Option<\/th>Description<\/th><\/tr><\/thead>permalink_structure<\/code><\/td>Permalink pattern<\/td><\/tr>category_base<\/code><\/td>Category URL prefix<\/td><\/tr>tag_base<\/code><\/td>Tag URL prefix<\/td><\/tr>rewrite_rules<\/code><\/td>Serialized rewrite rules<\/td><\/tr><\/tbody><\/table><\/figure>Theme\/Appearance<\/h3>Option<\/th>Description<\/th><\/tr><\/thead>template<\/code><\/td>Active theme directory<\/td><\/tr>stylesheet<\/code><\/td>Active child theme directory<\/td><\/tr>current_theme<\/code><\/td>Theme display name<\/td><\/tr>sidebars_widgets<\/code><\/td>Widget assignments<\/td><\/tr>theme_mods_{theme}<\/code><\/td>Theme customization<\/td><\/tr>nav_menu_options<\/code><\/td>Navigation menu settings<\/td><\/tr><\/tbody><\/table><\/figure>Cron & Transients<\/h3>Pattern<\/th>Description<\/th><\/tr><\/thead>cron<\/code><\/td>Scheduled tasks<\/td><\/tr>_transient_{name}<\/code><\/td>Cached data<\/td><\/tr>_transient_timeout_{name}<\/code><\/td>Transient expiration<\/td><\/tr>_site_transient_{name}<\/code><\/td>Network transient<\/td><\/tr><\/tbody><\/table><\/figure>Plugin Settings<\/h3>Plugins typically use patterns like:<\/p>{plugin_slug}_settings<\/code><\/li>{plugin_slug}_options<\/code><\/li>{plugin_slug}_version<\/code><\/li><\/ul>Common Queries<\/h2>Get option value<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_value \nFROM wp_options \nWHERE option_name = 'siteurl';<\/code><\/pre><\/div>Get all autoloaded options<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_name, option_value \nFROM wp_options \nWHERE autoload = 'yes';<\/code><\/pre><\/div>Calculate autoload size<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT \n SUM(LENGTH(option_value)) as total_bytes,\n COUNT(*) as option_count\nFROM wp_options \nWHERE autoload = 'yes';<\/code><\/pre><\/div>Find large options<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_name, LENGTH(option_value) as size_bytes\nFROM wp_options \nORDER BY size_bytes DESC \nLIMIT 20;<\/code><\/pre><\/div>Find expired transients<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT o.option_name, o.option_value\nFROM wp_options o\nJOIN wp_options t ON t.option_name = CONCAT('_transient_timeout_', \n SUBSTRING(o.option_name, 12))\nWHERE o.option_name LIKE '_transient_%'\n AND o.option_name NOT LIKE '_transient_timeout_%'\n AND t.option_value < UNIX_TIMESTAMP();<\/code><\/pre><\/div>Delete expired transients<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>DELETE a, b FROM wp_options a\nLEFT JOIN wp_options b ON b.option_name = CONCAT('_transient_timeout_', \n SUBSTRING(a.option_name, 12))\nWHERE a.option_name LIKE '_transient_%'\n AND a.option_name NOT LIKE '_transient_timeout_%'\n AND b.option_value IS NOT NULL\n AND b.option_value < UNIX_TIMESTAMP();<\/code><\/pre><\/div>Optimize autoload<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>-- Find options that shouldn't autoload\nSELECT option_name, LENGTH(option_value) as size\nFROM wp_options \nWHERE autoload = 'yes' \n AND LENGTH(option_value) > 10000\nORDER BY size DESC;\n\n-- Disable autoload for specific option\nUPDATE wp_options \nSET autoload = 'no' \nWHERE option_name = 'large_serialized_option';<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_option( $option, $default )<\/code> – Get option value<\/li>add_option( $option, $value, $deprecated, $autoload )<\/code> – Add option<\/li>update_option( $option, $value, $autoload )<\/code> – Update\/add option<\/li>delete_option( $option )<\/code> – Delete option<\/li>set_transient( $name, $value, $expiration )<\/code> – Set transient<\/li>get_transient( $name )<\/code> – Get transient<\/li>delete_transient( $name )<\/code> – Delete transient<\/li><\/ul>Performance Notes<\/h2>Autoload Optimization<\/h3>Large sites should audit autoloaded options:<\/p>sql<\/span><\/use><\/svg><\/button><\/div>SELECT SUM(LENGTH(option_value))\/1024 as kb FROM wp_options WHERE autoload='yes';<\/code><\/pre><\/div>Target: Keep autoload under 1MB total.<\/p>Transient Cleanup<\/h3>Transients without expiration never auto-delete. Periodically clean:<\/p>php<\/span>
default_category<\/code><\/td>Default post category<\/td><\/tr>default_comment_status<\/code><\/td>Default comment status<\/td><\/tr><\/tbody><\/table><\/figure>Permalinks<\/h3>Option<\/th>Description<\/th><\/tr><\/thead>permalink_structure<\/code><\/td>Permalink pattern<\/td><\/tr>category_base<\/code><\/td>Category URL prefix<\/td><\/tr>tag_base<\/code><\/td>Tag URL prefix<\/td><\/tr>rewrite_rules<\/code><\/td>Serialized rewrite rules<\/td><\/tr><\/tbody><\/table><\/figure>Theme\/Appearance<\/h3>Option<\/th>Description<\/th><\/tr><\/thead>template<\/code><\/td>Active theme directory<\/td><\/tr>stylesheet<\/code><\/td>Active child theme directory<\/td><\/tr>current_theme<\/code><\/td>Theme display name<\/td><\/tr>sidebars_widgets<\/code><\/td>Widget assignments<\/td><\/tr>theme_mods_{theme}<\/code><\/td>Theme customization<\/td><\/tr>nav_menu_options<\/code><\/td>Navigation menu settings<\/td><\/tr><\/tbody><\/table><\/figure>Cron & Transients<\/h3>Pattern<\/th>Description<\/th><\/tr><\/thead>cron<\/code><\/td>Scheduled tasks<\/td><\/tr>_transient_{name}<\/code><\/td>Cached data<\/td><\/tr>_transient_timeout_{name}<\/code><\/td>Transient expiration<\/td><\/tr>_site_transient_{name}<\/code><\/td>Network transient<\/td><\/tr><\/tbody><\/table><\/figure>Plugin Settings<\/h3>Plugins typically use patterns like:<\/p>{plugin_slug}_settings<\/code><\/li>{plugin_slug}_options<\/code><\/li>{plugin_slug}_version<\/code><\/li><\/ul>Common Queries<\/h2>Get option value<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_value \nFROM wp_options \nWHERE option_name = 'siteurl';<\/code><\/pre><\/div>Get all autoloaded options<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_name, option_value \nFROM wp_options \nWHERE autoload = 'yes';<\/code><\/pre><\/div>Calculate autoload size<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT \n SUM(LENGTH(option_value)) as total_bytes,\n COUNT(*) as option_count\nFROM wp_options \nWHERE autoload = 'yes';<\/code><\/pre><\/div>Find large options<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_name, LENGTH(option_value) as size_bytes\nFROM wp_options \nORDER BY size_bytes DESC \nLIMIT 20;<\/code><\/pre><\/div>Find expired transients<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT o.option_name, o.option_value\nFROM wp_options o\nJOIN wp_options t ON t.option_name = CONCAT('_transient_timeout_', \n SUBSTRING(o.option_name, 12))\nWHERE o.option_name LIKE '_transient_%'\n AND o.option_name NOT LIKE '_transient_timeout_%'\n AND t.option_value < UNIX_TIMESTAMP();<\/code><\/pre><\/div>Delete expired transients<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>DELETE a, b FROM wp_options a\nLEFT JOIN wp_options b ON b.option_name = CONCAT('_transient_timeout_', \n SUBSTRING(a.option_name, 12))\nWHERE a.option_name LIKE '_transient_%'\n AND a.option_name NOT LIKE '_transient_timeout_%'\n AND b.option_value IS NOT NULL\n AND b.option_value < UNIX_TIMESTAMP();<\/code><\/pre><\/div>Optimize autoload<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>-- Find options that shouldn't autoload\nSELECT option_name, LENGTH(option_value) as size\nFROM wp_options \nWHERE autoload = 'yes' \n AND LENGTH(option_value) > 10000\nORDER BY size DESC;\n\n-- Disable autoload for specific option\nUPDATE wp_options \nSET autoload = 'no' \nWHERE option_name = 'large_serialized_option';<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_option( $option, $default )<\/code> – Get option value<\/li>add_option( $option, $value, $deprecated, $autoload )<\/code> – Add option<\/li>update_option( $option, $value, $autoload )<\/code> – Update\/add option<\/li>delete_option( $option )<\/code> – Delete option<\/li>set_transient( $name, $value, $expiration )<\/code> – Set transient<\/li>get_transient( $name )<\/code> – Get transient<\/li>delete_transient( $name )<\/code> – Delete transient<\/li><\/ul>Performance Notes<\/h2>Autoload Optimization<\/h3>Large sites should audit autoloaded options:<\/p>sql<\/span><\/use><\/svg><\/button><\/div>SELECT SUM(LENGTH(option_value))\/1024 as kb FROM wp_options WHERE autoload='yes';<\/code><\/pre><\/div>Target: Keep autoload under 1MB total.<\/p>Transient Cleanup<\/h3>Transients without expiration never auto-delete. Periodically clean:<\/p>php<\/span>
default_comment_status<\/code><\/td>Default comment status<\/td><\/tr><\/tbody><\/table><\/figure>Permalinks<\/h3>Option<\/th>Description<\/th><\/tr><\/thead>permalink_structure<\/code><\/td>Permalink pattern<\/td><\/tr>category_base<\/code><\/td>Category URL prefix<\/td><\/tr>tag_base<\/code><\/td>Tag URL prefix<\/td><\/tr>rewrite_rules<\/code><\/td>Serialized rewrite rules<\/td><\/tr><\/tbody><\/table><\/figure>Theme\/Appearance<\/h3>Option<\/th>Description<\/th><\/tr><\/thead>template<\/code><\/td>Active theme directory<\/td><\/tr>stylesheet<\/code><\/td>Active child theme directory<\/td><\/tr>current_theme<\/code><\/td>Theme display name<\/td><\/tr>sidebars_widgets<\/code><\/td>Widget assignments<\/td><\/tr>theme_mods_{theme}<\/code><\/td>Theme customization<\/td><\/tr>nav_menu_options<\/code><\/td>Navigation menu settings<\/td><\/tr><\/tbody><\/table><\/figure>Cron & Transients<\/h3>Pattern<\/th>Description<\/th><\/tr><\/thead>cron<\/code><\/td>Scheduled tasks<\/td><\/tr>_transient_{name}<\/code><\/td>Cached data<\/td><\/tr>_transient_timeout_{name}<\/code><\/td>Transient expiration<\/td><\/tr>_site_transient_{name}<\/code><\/td>Network transient<\/td><\/tr><\/tbody><\/table><\/figure>Plugin Settings<\/h3>Plugins typically use patterns like:<\/p>{plugin_slug}_settings<\/code><\/li>{plugin_slug}_options<\/code><\/li>{plugin_slug}_version<\/code><\/li><\/ul>Common Queries<\/h2>Get option value<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_value \nFROM wp_options \nWHERE option_name = 'siteurl';<\/code><\/pre><\/div>Get all autoloaded options<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_name, option_value \nFROM wp_options \nWHERE autoload = 'yes';<\/code><\/pre><\/div>Calculate autoload size<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT \n SUM(LENGTH(option_value)) as total_bytes,\n COUNT(*) as option_count\nFROM wp_options \nWHERE autoload = 'yes';<\/code><\/pre><\/div>Find large options<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_name, LENGTH(option_value) as size_bytes\nFROM wp_options \nORDER BY size_bytes DESC \nLIMIT 20;<\/code><\/pre><\/div>Find expired transients<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT o.option_name, o.option_value\nFROM wp_options o\nJOIN wp_options t ON t.option_name = CONCAT('_transient_timeout_', \n SUBSTRING(o.option_name, 12))\nWHERE o.option_name LIKE '_transient_%'\n AND o.option_name NOT LIKE '_transient_timeout_%'\n AND t.option_value < UNIX_TIMESTAMP();<\/code><\/pre><\/div>Delete expired transients<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>DELETE a, b FROM wp_options a\nLEFT JOIN wp_options b ON b.option_name = CONCAT('_transient_timeout_', \n SUBSTRING(a.option_name, 12))\nWHERE a.option_name LIKE '_transient_%'\n AND a.option_name NOT LIKE '_transient_timeout_%'\n AND b.option_value IS NOT NULL\n AND b.option_value < UNIX_TIMESTAMP();<\/code><\/pre><\/div>Optimize autoload<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>-- Find options that shouldn't autoload\nSELECT option_name, LENGTH(option_value) as size\nFROM wp_options \nWHERE autoload = 'yes' \n AND LENGTH(option_value) > 10000\nORDER BY size DESC;\n\n-- Disable autoload for specific option\nUPDATE wp_options \nSET autoload = 'no' \nWHERE option_name = 'large_serialized_option';<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_option( $option, $default )<\/code> – Get option value<\/li>add_option( $option, $value, $deprecated, $autoload )<\/code> – Add option<\/li>update_option( $option, $value, $autoload )<\/code> – Update\/add option<\/li>delete_option( $option )<\/code> – Delete option<\/li>set_transient( $name, $value, $expiration )<\/code> – Set transient<\/li>get_transient( $name )<\/code> – Get transient<\/li>delete_transient( $name )<\/code> – Delete transient<\/li><\/ul>Performance Notes<\/h2>Autoload Optimization<\/h3>Large sites should audit autoloaded options:<\/p>sql<\/span><\/use><\/svg><\/button><\/div>SELECT SUM(LENGTH(option_value))\/1024 as kb FROM wp_options WHERE autoload='yes';<\/code><\/pre><\/div>Target: Keep autoload under 1MB total.<\/p>Transient Cleanup<\/h3>Transients without expiration never auto-delete. Periodically clean:<\/p>php<\/span>
permalink_structure<\/code><\/td>Permalink pattern<\/td><\/tr>category_base<\/code><\/td>Category URL prefix<\/td><\/tr>tag_base<\/code><\/td>Tag URL prefix<\/td><\/tr>rewrite_rules<\/code><\/td>Serialized rewrite rules<\/td><\/tr><\/tbody><\/table><\/figure>Theme\/Appearance<\/h3>Option<\/th>Description<\/th><\/tr><\/thead>template<\/code><\/td>Active theme directory<\/td><\/tr>stylesheet<\/code><\/td>Active child theme directory<\/td><\/tr>current_theme<\/code><\/td>Theme display name<\/td><\/tr>sidebars_widgets<\/code><\/td>Widget assignments<\/td><\/tr>theme_mods_{theme}<\/code><\/td>Theme customization<\/td><\/tr>nav_menu_options<\/code><\/td>Navigation menu settings<\/td><\/tr><\/tbody><\/table><\/figure>Cron & Transients<\/h3>Pattern<\/th>Description<\/th><\/tr><\/thead>cron<\/code><\/td>Scheduled tasks<\/td><\/tr>_transient_{name}<\/code><\/td>Cached data<\/td><\/tr>_transient_timeout_{name}<\/code><\/td>Transient expiration<\/td><\/tr>_site_transient_{name}<\/code><\/td>Network transient<\/td><\/tr><\/tbody><\/table><\/figure>Plugin Settings<\/h3>Plugins typically use patterns like:<\/p>{plugin_slug}_settings<\/code><\/li>{plugin_slug}_options<\/code><\/li>{plugin_slug}_version<\/code><\/li><\/ul>Common Queries<\/h2>Get option value<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_value \nFROM wp_options \nWHERE option_name = 'siteurl';<\/code><\/pre><\/div>Get all autoloaded options<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_name, option_value \nFROM wp_options \nWHERE autoload = 'yes';<\/code><\/pre><\/div>Calculate autoload size<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT \n SUM(LENGTH(option_value)) as total_bytes,\n COUNT(*) as option_count\nFROM wp_options \nWHERE autoload = 'yes';<\/code><\/pre><\/div>Find large options<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_name, LENGTH(option_value) as size_bytes\nFROM wp_options \nORDER BY size_bytes DESC \nLIMIT 20;<\/code><\/pre><\/div>Find expired transients<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT o.option_name, o.option_value\nFROM wp_options o\nJOIN wp_options t ON t.option_name = CONCAT('_transient_timeout_', \n SUBSTRING(o.option_name, 12))\nWHERE o.option_name LIKE '_transient_%'\n AND o.option_name NOT LIKE '_transient_timeout_%'\n AND t.option_value < UNIX_TIMESTAMP();<\/code><\/pre><\/div>Delete expired transients<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>DELETE a, b FROM wp_options a\nLEFT JOIN wp_options b ON b.option_name = CONCAT('_transient_timeout_', \n SUBSTRING(a.option_name, 12))\nWHERE a.option_name LIKE '_transient_%'\n AND a.option_name NOT LIKE '_transient_timeout_%'\n AND b.option_value IS NOT NULL\n AND b.option_value < UNIX_TIMESTAMP();<\/code><\/pre><\/div>Optimize autoload<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>-- Find options that shouldn't autoload\nSELECT option_name, LENGTH(option_value) as size\nFROM wp_options \nWHERE autoload = 'yes' \n AND LENGTH(option_value) > 10000\nORDER BY size DESC;\n\n-- Disable autoload for specific option\nUPDATE wp_options \nSET autoload = 'no' \nWHERE option_name = 'large_serialized_option';<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_option( $option, $default )<\/code> – Get option value<\/li>add_option( $option, $value, $deprecated, $autoload )<\/code> – Add option<\/li>update_option( $option, $value, $autoload )<\/code> – Update\/add option<\/li>delete_option( $option )<\/code> – Delete option<\/li>set_transient( $name, $value, $expiration )<\/code> – Set transient<\/li>get_transient( $name )<\/code> – Get transient<\/li>delete_transient( $name )<\/code> – Delete transient<\/li><\/ul>Performance Notes<\/h2>Autoload Optimization<\/h3>Large sites should audit autoloaded options:<\/p>sql<\/span><\/use><\/svg><\/button><\/div>SELECT SUM(LENGTH(option_value))\/1024 as kb FROM wp_options WHERE autoload='yes';<\/code><\/pre><\/div>Target: Keep autoload under 1MB total.<\/p>Transient Cleanup<\/h3>Transients without expiration never auto-delete. Periodically clean:<\/p>php<\/span>
category_base<\/code><\/td>Category URL prefix<\/td><\/tr>tag_base<\/code><\/td>Tag URL prefix<\/td><\/tr>rewrite_rules<\/code><\/td>Serialized rewrite rules<\/td><\/tr><\/tbody><\/table><\/figure>Theme\/Appearance<\/h3>Option<\/th>Description<\/th><\/tr><\/thead>template<\/code><\/td>Active theme directory<\/td><\/tr>stylesheet<\/code><\/td>Active child theme directory<\/td><\/tr>current_theme<\/code><\/td>Theme display name<\/td><\/tr>sidebars_widgets<\/code><\/td>Widget assignments<\/td><\/tr>theme_mods_{theme}<\/code><\/td>Theme customization<\/td><\/tr>nav_menu_options<\/code><\/td>Navigation menu settings<\/td><\/tr><\/tbody><\/table><\/figure>Cron & Transients<\/h3>Pattern<\/th>Description<\/th><\/tr><\/thead>cron<\/code><\/td>Scheduled tasks<\/td><\/tr>_transient_{name}<\/code><\/td>Cached data<\/td><\/tr>_transient_timeout_{name}<\/code><\/td>Transient expiration<\/td><\/tr>_site_transient_{name}<\/code><\/td>Network transient<\/td><\/tr><\/tbody><\/table><\/figure>Plugin Settings<\/h3>Plugins typically use patterns like:<\/p>{plugin_slug}_settings<\/code><\/li>{plugin_slug}_options<\/code><\/li>{plugin_slug}_version<\/code><\/li><\/ul>Common Queries<\/h2>Get option value<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_value \nFROM wp_options \nWHERE option_name = 'siteurl';<\/code><\/pre><\/div>Get all autoloaded options<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_name, option_value \nFROM wp_options \nWHERE autoload = 'yes';<\/code><\/pre><\/div>Calculate autoload size<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT \n SUM(LENGTH(option_value)) as total_bytes,\n COUNT(*) as option_count\nFROM wp_options \nWHERE autoload = 'yes';<\/code><\/pre><\/div>Find large options<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_name, LENGTH(option_value) as size_bytes\nFROM wp_options \nORDER BY size_bytes DESC \nLIMIT 20;<\/code><\/pre><\/div>Find expired transients<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT o.option_name, o.option_value\nFROM wp_options o\nJOIN wp_options t ON t.option_name = CONCAT('_transient_timeout_', \n SUBSTRING(o.option_name, 12))\nWHERE o.option_name LIKE '_transient_%'\n AND o.option_name NOT LIKE '_transient_timeout_%'\n AND t.option_value < UNIX_TIMESTAMP();<\/code><\/pre><\/div>Delete expired transients<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>DELETE a, b FROM wp_options a\nLEFT JOIN wp_options b ON b.option_name = CONCAT('_transient_timeout_', \n SUBSTRING(a.option_name, 12))\nWHERE a.option_name LIKE '_transient_%'\n AND a.option_name NOT LIKE '_transient_timeout_%'\n AND b.option_value IS NOT NULL\n AND b.option_value < UNIX_TIMESTAMP();<\/code><\/pre><\/div>Optimize autoload<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>-- Find options that shouldn't autoload\nSELECT option_name, LENGTH(option_value) as size\nFROM wp_options \nWHERE autoload = 'yes' \n AND LENGTH(option_value) > 10000\nORDER BY size DESC;\n\n-- Disable autoload for specific option\nUPDATE wp_options \nSET autoload = 'no' \nWHERE option_name = 'large_serialized_option';<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_option( $option, $default )<\/code> – Get option value<\/li>add_option( $option, $value, $deprecated, $autoload )<\/code> – Add option<\/li>update_option( $option, $value, $autoload )<\/code> – Update\/add option<\/li>delete_option( $option )<\/code> – Delete option<\/li>set_transient( $name, $value, $expiration )<\/code> – Set transient<\/li>get_transient( $name )<\/code> – Get transient<\/li>delete_transient( $name )<\/code> – Delete transient<\/li><\/ul>Performance Notes<\/h2>Autoload Optimization<\/h3>Large sites should audit autoloaded options:<\/p>sql<\/span><\/use><\/svg><\/button><\/div>SELECT SUM(LENGTH(option_value))\/1024 as kb FROM wp_options WHERE autoload='yes';<\/code><\/pre><\/div>Target: Keep autoload under 1MB total.<\/p>Transient Cleanup<\/h3>Transients without expiration never auto-delete. Periodically clean:<\/p>php<\/span>
tag_base<\/code><\/td>Tag URL prefix<\/td><\/tr>rewrite_rules<\/code><\/td>Serialized rewrite rules<\/td><\/tr><\/tbody><\/table><\/figure>Theme\/Appearance<\/h3>Option<\/th>Description<\/th><\/tr><\/thead>template<\/code><\/td>Active theme directory<\/td><\/tr>stylesheet<\/code><\/td>Active child theme directory<\/td><\/tr>current_theme<\/code><\/td>Theme display name<\/td><\/tr>sidebars_widgets<\/code><\/td>Widget assignments<\/td><\/tr>theme_mods_{theme}<\/code><\/td>Theme customization<\/td><\/tr>nav_menu_options<\/code><\/td>Navigation menu settings<\/td><\/tr><\/tbody><\/table><\/figure>Cron & Transients<\/h3>Pattern<\/th>Description<\/th><\/tr><\/thead>cron<\/code><\/td>Scheduled tasks<\/td><\/tr>_transient_{name}<\/code><\/td>Cached data<\/td><\/tr>_transient_timeout_{name}<\/code><\/td>Transient expiration<\/td><\/tr>_site_transient_{name}<\/code><\/td>Network transient<\/td><\/tr><\/tbody><\/table><\/figure>Plugin Settings<\/h3>Plugins typically use patterns like:<\/p>{plugin_slug}_settings<\/code><\/li>{plugin_slug}_options<\/code><\/li>{plugin_slug}_version<\/code><\/li><\/ul>Common Queries<\/h2>Get option value<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_value \nFROM wp_options \nWHERE option_name = 'siteurl';<\/code><\/pre><\/div>Get all autoloaded options<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_name, option_value \nFROM wp_options \nWHERE autoload = 'yes';<\/code><\/pre><\/div>Calculate autoload size<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT \n SUM(LENGTH(option_value)) as total_bytes,\n COUNT(*) as option_count\nFROM wp_options \nWHERE autoload = 'yes';<\/code><\/pre><\/div>Find large options<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_name, LENGTH(option_value) as size_bytes\nFROM wp_options \nORDER BY size_bytes DESC \nLIMIT 20;<\/code><\/pre><\/div>Find expired transients<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT o.option_name, o.option_value\nFROM wp_options o\nJOIN wp_options t ON t.option_name = CONCAT('_transient_timeout_', \n SUBSTRING(o.option_name, 12))\nWHERE o.option_name LIKE '_transient_%'\n AND o.option_name NOT LIKE '_transient_timeout_%'\n AND t.option_value < UNIX_TIMESTAMP();<\/code><\/pre><\/div>Delete expired transients<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>DELETE a, b FROM wp_options a\nLEFT JOIN wp_options b ON b.option_name = CONCAT('_transient_timeout_', \n SUBSTRING(a.option_name, 12))\nWHERE a.option_name LIKE '_transient_%'\n AND a.option_name NOT LIKE '_transient_timeout_%'\n AND b.option_value IS NOT NULL\n AND b.option_value < UNIX_TIMESTAMP();<\/code><\/pre><\/div>Optimize autoload<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>-- Find options that shouldn't autoload\nSELECT option_name, LENGTH(option_value) as size\nFROM wp_options \nWHERE autoload = 'yes' \n AND LENGTH(option_value) > 10000\nORDER BY size DESC;\n\n-- Disable autoload for specific option\nUPDATE wp_options \nSET autoload = 'no' \nWHERE option_name = 'large_serialized_option';<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_option( $option, $default )<\/code> – Get option value<\/li>add_option( $option, $value, $deprecated, $autoload )<\/code> – Add option<\/li>update_option( $option, $value, $autoload )<\/code> – Update\/add option<\/li>delete_option( $option )<\/code> – Delete option<\/li>set_transient( $name, $value, $expiration )<\/code> – Set transient<\/li>get_transient( $name )<\/code> – Get transient<\/li>delete_transient( $name )<\/code> – Delete transient<\/li><\/ul>Performance Notes<\/h2>Autoload Optimization<\/h3>Large sites should audit autoloaded options:<\/p>sql<\/span><\/use><\/svg><\/button><\/div>SELECT SUM(LENGTH(option_value))\/1024 as kb FROM wp_options WHERE autoload='yes';<\/code><\/pre><\/div>Target: Keep autoload under 1MB total.<\/p>Transient Cleanup<\/h3>Transients without expiration never auto-delete. Periodically clean:<\/p>php<\/span>
rewrite_rules<\/code><\/td>Serialized rewrite rules<\/td><\/tr><\/tbody><\/table><\/figure>Theme\/Appearance<\/h3>Option<\/th>Description<\/th><\/tr><\/thead>template<\/code><\/td>Active theme directory<\/td><\/tr>stylesheet<\/code><\/td>Active child theme directory<\/td><\/tr>current_theme<\/code><\/td>Theme display name<\/td><\/tr>sidebars_widgets<\/code><\/td>Widget assignments<\/td><\/tr>theme_mods_{theme}<\/code><\/td>Theme customization<\/td><\/tr>nav_menu_options<\/code><\/td>Navigation menu settings<\/td><\/tr><\/tbody><\/table><\/figure>Cron & Transients<\/h3>Pattern<\/th>Description<\/th><\/tr><\/thead>cron<\/code><\/td>Scheduled tasks<\/td><\/tr>_transient_{name}<\/code><\/td>Cached data<\/td><\/tr>_transient_timeout_{name}<\/code><\/td>Transient expiration<\/td><\/tr>_site_transient_{name}<\/code><\/td>Network transient<\/td><\/tr><\/tbody><\/table><\/figure>Plugin Settings<\/h3>Plugins typically use patterns like:<\/p>{plugin_slug}_settings<\/code><\/li>{plugin_slug}_options<\/code><\/li>{plugin_slug}_version<\/code><\/li><\/ul>Common Queries<\/h2>Get option value<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_value \nFROM wp_options \nWHERE option_name = 'siteurl';<\/code><\/pre><\/div>Get all autoloaded options<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_name, option_value \nFROM wp_options \nWHERE autoload = 'yes';<\/code><\/pre><\/div>Calculate autoload size<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT \n SUM(LENGTH(option_value)) as total_bytes,\n COUNT(*) as option_count\nFROM wp_options \nWHERE autoload = 'yes';<\/code><\/pre><\/div>Find large options<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_name, LENGTH(option_value) as size_bytes\nFROM wp_options \nORDER BY size_bytes DESC \nLIMIT 20;<\/code><\/pre><\/div>Find expired transients<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT o.option_name, o.option_value\nFROM wp_options o\nJOIN wp_options t ON t.option_name = CONCAT('_transient_timeout_', \n SUBSTRING(o.option_name, 12))\nWHERE o.option_name LIKE '_transient_%'\n AND o.option_name NOT LIKE '_transient_timeout_%'\n AND t.option_value < UNIX_TIMESTAMP();<\/code><\/pre><\/div>Delete expired transients<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>DELETE a, b FROM wp_options a\nLEFT JOIN wp_options b ON b.option_name = CONCAT('_transient_timeout_', \n SUBSTRING(a.option_name, 12))\nWHERE a.option_name LIKE '_transient_%'\n AND a.option_name NOT LIKE '_transient_timeout_%'\n AND b.option_value IS NOT NULL\n AND b.option_value < UNIX_TIMESTAMP();<\/code><\/pre><\/div>Optimize autoload<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>-- Find options that shouldn't autoload\nSELECT option_name, LENGTH(option_value) as size\nFROM wp_options \nWHERE autoload = 'yes' \n AND LENGTH(option_value) > 10000\nORDER BY size DESC;\n\n-- Disable autoload for specific option\nUPDATE wp_options \nSET autoload = 'no' \nWHERE option_name = 'large_serialized_option';<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_option( $option, $default )<\/code> – Get option value<\/li>add_option( $option, $value, $deprecated, $autoload )<\/code> – Add option<\/li>update_option( $option, $value, $autoload )<\/code> – Update\/add option<\/li>delete_option( $option )<\/code> – Delete option<\/li>set_transient( $name, $value, $expiration )<\/code> – Set transient<\/li>get_transient( $name )<\/code> – Get transient<\/li>delete_transient( $name )<\/code> – Delete transient<\/li><\/ul>Performance Notes<\/h2>Autoload Optimization<\/h3>Large sites should audit autoloaded options:<\/p>sql<\/span><\/use><\/svg><\/button><\/div>SELECT SUM(LENGTH(option_value))\/1024 as kb FROM wp_options WHERE autoload='yes';<\/code><\/pre><\/div>Target: Keep autoload under 1MB total.<\/p>Transient Cleanup<\/h3>Transients without expiration never auto-delete. Periodically clean:<\/p>php<\/span>
template<\/code><\/td>Active theme directory<\/td><\/tr>stylesheet<\/code><\/td>Active child theme directory<\/td><\/tr>current_theme<\/code><\/td>Theme display name<\/td><\/tr>sidebars_widgets<\/code><\/td>Widget assignments<\/td><\/tr>theme_mods_{theme}<\/code><\/td>Theme customization<\/td><\/tr>nav_menu_options<\/code><\/td>Navigation menu settings<\/td><\/tr><\/tbody><\/table><\/figure>Cron & Transients<\/h3>Pattern<\/th>Description<\/th><\/tr><\/thead>cron<\/code><\/td>Scheduled tasks<\/td><\/tr>_transient_{name}<\/code><\/td>Cached data<\/td><\/tr>_transient_timeout_{name}<\/code><\/td>Transient expiration<\/td><\/tr>_site_transient_{name}<\/code><\/td>Network transient<\/td><\/tr><\/tbody><\/table><\/figure>Plugin Settings<\/h3>Plugins typically use patterns like:<\/p>{plugin_slug}_settings<\/code><\/li>{plugin_slug}_options<\/code><\/li>{plugin_slug}_version<\/code><\/li><\/ul>Common Queries<\/h2>Get option value<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_value \nFROM wp_options \nWHERE option_name = 'siteurl';<\/code><\/pre><\/div>Get all autoloaded options<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_name, option_value \nFROM wp_options \nWHERE autoload = 'yes';<\/code><\/pre><\/div>Calculate autoload size<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT \n SUM(LENGTH(option_value)) as total_bytes,\n COUNT(*) as option_count\nFROM wp_options \nWHERE autoload = 'yes';<\/code><\/pre><\/div>Find large options<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_name, LENGTH(option_value) as size_bytes\nFROM wp_options \nORDER BY size_bytes DESC \nLIMIT 20;<\/code><\/pre><\/div>Find expired transients<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT o.option_name, o.option_value\nFROM wp_options o\nJOIN wp_options t ON t.option_name = CONCAT('_transient_timeout_', \n SUBSTRING(o.option_name, 12))\nWHERE o.option_name LIKE '_transient_%'\n AND o.option_name NOT LIKE '_transient_timeout_%'\n AND t.option_value < UNIX_TIMESTAMP();<\/code><\/pre><\/div>Delete expired transients<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>DELETE a, b FROM wp_options a\nLEFT JOIN wp_options b ON b.option_name = CONCAT('_transient_timeout_', \n SUBSTRING(a.option_name, 12))\nWHERE a.option_name LIKE '_transient_%'\n AND a.option_name NOT LIKE '_transient_timeout_%'\n AND b.option_value IS NOT NULL\n AND b.option_value < UNIX_TIMESTAMP();<\/code><\/pre><\/div>Optimize autoload<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>-- Find options that shouldn't autoload\nSELECT option_name, LENGTH(option_value) as size\nFROM wp_options \nWHERE autoload = 'yes' \n AND LENGTH(option_value) > 10000\nORDER BY size DESC;\n\n-- Disable autoload for specific option\nUPDATE wp_options \nSET autoload = 'no' \nWHERE option_name = 'large_serialized_option';<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_option( $option, $default )<\/code> – Get option value<\/li>add_option( $option, $value, $deprecated, $autoload )<\/code> – Add option<\/li>update_option( $option, $value, $autoload )<\/code> – Update\/add option<\/li>delete_option( $option )<\/code> – Delete option<\/li>set_transient( $name, $value, $expiration )<\/code> – Set transient<\/li>get_transient( $name )<\/code> – Get transient<\/li>delete_transient( $name )<\/code> – Delete transient<\/li><\/ul>Performance Notes<\/h2>Autoload Optimization<\/h3>Large sites should audit autoloaded options:<\/p>sql<\/span><\/use><\/svg><\/button><\/div>SELECT SUM(LENGTH(option_value))\/1024 as kb FROM wp_options WHERE autoload='yes';<\/code><\/pre><\/div>Target: Keep autoload under 1MB total.<\/p>Transient Cleanup<\/h3>Transients without expiration never auto-delete. Periodically clean:<\/p>php<\/span>
stylesheet<\/code><\/td>Active child theme directory<\/td><\/tr>current_theme<\/code><\/td>Theme display name<\/td><\/tr>sidebars_widgets<\/code><\/td>Widget assignments<\/td><\/tr>theme_mods_{theme}<\/code><\/td>Theme customization<\/td><\/tr>nav_menu_options<\/code><\/td>Navigation menu settings<\/td><\/tr><\/tbody><\/table><\/figure>Cron & Transients<\/h3>Pattern<\/th>Description<\/th><\/tr><\/thead>cron<\/code><\/td>Scheduled tasks<\/td><\/tr>_transient_{name}<\/code><\/td>Cached data<\/td><\/tr>_transient_timeout_{name}<\/code><\/td>Transient expiration<\/td><\/tr>_site_transient_{name}<\/code><\/td>Network transient<\/td><\/tr><\/tbody><\/table><\/figure>Plugin Settings<\/h3>Plugins typically use patterns like:<\/p>{plugin_slug}_settings<\/code><\/li>{plugin_slug}_options<\/code><\/li>{plugin_slug}_version<\/code><\/li><\/ul>Common Queries<\/h2>Get option value<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_value \nFROM wp_options \nWHERE option_name = 'siteurl';<\/code><\/pre><\/div>Get all autoloaded options<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_name, option_value \nFROM wp_options \nWHERE autoload = 'yes';<\/code><\/pre><\/div>Calculate autoload size<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT \n SUM(LENGTH(option_value)) as total_bytes,\n COUNT(*) as option_count\nFROM wp_options \nWHERE autoload = 'yes';<\/code><\/pre><\/div>Find large options<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_name, LENGTH(option_value) as size_bytes\nFROM wp_options \nORDER BY size_bytes DESC \nLIMIT 20;<\/code><\/pre><\/div>Find expired transients<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT o.option_name, o.option_value\nFROM wp_options o\nJOIN wp_options t ON t.option_name = CONCAT('_transient_timeout_', \n SUBSTRING(o.option_name, 12))\nWHERE o.option_name LIKE '_transient_%'\n AND o.option_name NOT LIKE '_transient_timeout_%'\n AND t.option_value < UNIX_TIMESTAMP();<\/code><\/pre><\/div>Delete expired transients<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>DELETE a, b FROM wp_options a\nLEFT JOIN wp_options b ON b.option_name = CONCAT('_transient_timeout_', \n SUBSTRING(a.option_name, 12))\nWHERE a.option_name LIKE '_transient_%'\n AND a.option_name NOT LIKE '_transient_timeout_%'\n AND b.option_value IS NOT NULL\n AND b.option_value < UNIX_TIMESTAMP();<\/code><\/pre><\/div>Optimize autoload<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>-- Find options that shouldn't autoload\nSELECT option_name, LENGTH(option_value) as size\nFROM wp_options \nWHERE autoload = 'yes' \n AND LENGTH(option_value) > 10000\nORDER BY size DESC;\n\n-- Disable autoload for specific option\nUPDATE wp_options \nSET autoload = 'no' \nWHERE option_name = 'large_serialized_option';<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_option( $option, $default )<\/code> – Get option value<\/li>add_option( $option, $value, $deprecated, $autoload )<\/code> – Add option<\/li>update_option( $option, $value, $autoload )<\/code> – Update\/add option<\/li>delete_option( $option )<\/code> – Delete option<\/li>set_transient( $name, $value, $expiration )<\/code> – Set transient<\/li>get_transient( $name )<\/code> – Get transient<\/li>delete_transient( $name )<\/code> – Delete transient<\/li><\/ul>Performance Notes<\/h2>Autoload Optimization<\/h3>Large sites should audit autoloaded options:<\/p>sql<\/span><\/use><\/svg><\/button><\/div>SELECT SUM(LENGTH(option_value))\/1024 as kb FROM wp_options WHERE autoload='yes';<\/code><\/pre><\/div>Target: Keep autoload under 1MB total.<\/p>Transient Cleanup<\/h3>Transients without expiration never auto-delete. Periodically clean:<\/p>php<\/span>
current_theme<\/code><\/td>Theme display name<\/td><\/tr>sidebars_widgets<\/code><\/td>Widget assignments<\/td><\/tr>theme_mods_{theme}<\/code><\/td>Theme customization<\/td><\/tr>nav_menu_options<\/code><\/td>Navigation menu settings<\/td><\/tr><\/tbody><\/table><\/figure>Cron & Transients<\/h3>Pattern<\/th>Description<\/th><\/tr><\/thead>cron<\/code><\/td>Scheduled tasks<\/td><\/tr>_transient_{name}<\/code><\/td>Cached data<\/td><\/tr>_transient_timeout_{name}<\/code><\/td>Transient expiration<\/td><\/tr>_site_transient_{name}<\/code><\/td>Network transient<\/td><\/tr><\/tbody><\/table><\/figure>Plugin Settings<\/h3>Plugins typically use patterns like:<\/p>{plugin_slug}_settings<\/code><\/li>{plugin_slug}_options<\/code><\/li>{plugin_slug}_version<\/code><\/li><\/ul>Common Queries<\/h2>Get option value<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_value \nFROM wp_options \nWHERE option_name = 'siteurl';<\/code><\/pre><\/div>Get all autoloaded options<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_name, option_value \nFROM wp_options \nWHERE autoload = 'yes';<\/code><\/pre><\/div>Calculate autoload size<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT \n SUM(LENGTH(option_value)) as total_bytes,\n COUNT(*) as option_count\nFROM wp_options \nWHERE autoload = 'yes';<\/code><\/pre><\/div>Find large options<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_name, LENGTH(option_value) as size_bytes\nFROM wp_options \nORDER BY size_bytes DESC \nLIMIT 20;<\/code><\/pre><\/div>Find expired transients<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT o.option_name, o.option_value\nFROM wp_options o\nJOIN wp_options t ON t.option_name = CONCAT('_transient_timeout_', \n SUBSTRING(o.option_name, 12))\nWHERE o.option_name LIKE '_transient_%'\n AND o.option_name NOT LIKE '_transient_timeout_%'\n AND t.option_value < UNIX_TIMESTAMP();<\/code><\/pre><\/div>Delete expired transients<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>DELETE a, b FROM wp_options a\nLEFT JOIN wp_options b ON b.option_name = CONCAT('_transient_timeout_', \n SUBSTRING(a.option_name, 12))\nWHERE a.option_name LIKE '_transient_%'\n AND a.option_name NOT LIKE '_transient_timeout_%'\n AND b.option_value IS NOT NULL\n AND b.option_value < UNIX_TIMESTAMP();<\/code><\/pre><\/div>Optimize autoload<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>-- Find options that shouldn't autoload\nSELECT option_name, LENGTH(option_value) as size\nFROM wp_options \nWHERE autoload = 'yes' \n AND LENGTH(option_value) > 10000\nORDER BY size DESC;\n\n-- Disable autoload for specific option\nUPDATE wp_options \nSET autoload = 'no' \nWHERE option_name = 'large_serialized_option';<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_option( $option, $default )<\/code> – Get option value<\/li>add_option( $option, $value, $deprecated, $autoload )<\/code> – Add option<\/li>update_option( $option, $value, $autoload )<\/code> – Update\/add option<\/li>delete_option( $option )<\/code> – Delete option<\/li>set_transient( $name, $value, $expiration )<\/code> – Set transient<\/li>get_transient( $name )<\/code> – Get transient<\/li>delete_transient( $name )<\/code> – Delete transient<\/li><\/ul>Performance Notes<\/h2>Autoload Optimization<\/h3>Large sites should audit autoloaded options:<\/p>sql<\/span><\/use><\/svg><\/button><\/div>SELECT SUM(LENGTH(option_value))\/1024 as kb FROM wp_options WHERE autoload='yes';<\/code><\/pre><\/div>Target: Keep autoload under 1MB total.<\/p>Transient Cleanup<\/h3>Transients without expiration never auto-delete. Periodically clean:<\/p>php<\/span>
sidebars_widgets<\/code><\/td>Widget assignments<\/td><\/tr>theme_mods_{theme}<\/code><\/td>Theme customization<\/td><\/tr>nav_menu_options<\/code><\/td>Navigation menu settings<\/td><\/tr><\/tbody><\/table><\/figure>Cron & Transients<\/h3>Pattern<\/th>Description<\/th><\/tr><\/thead>cron<\/code><\/td>Scheduled tasks<\/td><\/tr>_transient_{name}<\/code><\/td>Cached data<\/td><\/tr>_transient_timeout_{name}<\/code><\/td>Transient expiration<\/td><\/tr>_site_transient_{name}<\/code><\/td>Network transient<\/td><\/tr><\/tbody><\/table><\/figure>Plugin Settings<\/h3>Plugins typically use patterns like:<\/p>{plugin_slug}_settings<\/code><\/li>{plugin_slug}_options<\/code><\/li>{plugin_slug}_version<\/code><\/li><\/ul>Common Queries<\/h2>Get option value<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_value \nFROM wp_options \nWHERE option_name = 'siteurl';<\/code><\/pre><\/div>Get all autoloaded options<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_name, option_value \nFROM wp_options \nWHERE autoload = 'yes';<\/code><\/pre><\/div>Calculate autoload size<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT \n SUM(LENGTH(option_value)) as total_bytes,\n COUNT(*) as option_count\nFROM wp_options \nWHERE autoload = 'yes';<\/code><\/pre><\/div>Find large options<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_name, LENGTH(option_value) as size_bytes\nFROM wp_options \nORDER BY size_bytes DESC \nLIMIT 20;<\/code><\/pre><\/div>Find expired transients<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT o.option_name, o.option_value\nFROM wp_options o\nJOIN wp_options t ON t.option_name = CONCAT('_transient_timeout_', \n SUBSTRING(o.option_name, 12))\nWHERE o.option_name LIKE '_transient_%'\n AND o.option_name NOT LIKE '_transient_timeout_%'\n AND t.option_value < UNIX_TIMESTAMP();<\/code><\/pre><\/div>Delete expired transients<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>DELETE a, b FROM wp_options a\nLEFT JOIN wp_options b ON b.option_name = CONCAT('_transient_timeout_', \n SUBSTRING(a.option_name, 12))\nWHERE a.option_name LIKE '_transient_%'\n AND a.option_name NOT LIKE '_transient_timeout_%'\n AND b.option_value IS NOT NULL\n AND b.option_value < UNIX_TIMESTAMP();<\/code><\/pre><\/div>Optimize autoload<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>-- Find options that shouldn't autoload\nSELECT option_name, LENGTH(option_value) as size\nFROM wp_options \nWHERE autoload = 'yes' \n AND LENGTH(option_value) > 10000\nORDER BY size DESC;\n\n-- Disable autoload for specific option\nUPDATE wp_options \nSET autoload = 'no' \nWHERE option_name = 'large_serialized_option';<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_option( $option, $default )<\/code> – Get option value<\/li>add_option( $option, $value, $deprecated, $autoload )<\/code> – Add option<\/li>update_option( $option, $value, $autoload )<\/code> – Update\/add option<\/li>delete_option( $option )<\/code> – Delete option<\/li>set_transient( $name, $value, $expiration )<\/code> – Set transient<\/li>get_transient( $name )<\/code> – Get transient<\/li>delete_transient( $name )<\/code> – Delete transient<\/li><\/ul>Performance Notes<\/h2>Autoload Optimization<\/h3>Large sites should audit autoloaded options:<\/p>sql<\/span><\/use><\/svg><\/button><\/div>SELECT SUM(LENGTH(option_value))\/1024 as kb FROM wp_options WHERE autoload='yes';<\/code><\/pre><\/div>Target: Keep autoload under 1MB total.<\/p>Transient Cleanup<\/h3>Transients without expiration never auto-delete. Periodically clean:<\/p>php<\/span>
theme_mods_{theme}<\/code><\/td>Theme customization<\/td><\/tr>nav_menu_options<\/code><\/td>Navigation menu settings<\/td><\/tr><\/tbody><\/table><\/figure>Cron & Transients<\/h3>Pattern<\/th>Description<\/th><\/tr><\/thead>cron<\/code><\/td>Scheduled tasks<\/td><\/tr>_transient_{name}<\/code><\/td>Cached data<\/td><\/tr>_transient_timeout_{name}<\/code><\/td>Transient expiration<\/td><\/tr>_site_transient_{name}<\/code><\/td>Network transient<\/td><\/tr><\/tbody><\/table><\/figure>Plugin Settings<\/h3>Plugins typically use patterns like:<\/p>{plugin_slug}_settings<\/code><\/li>{plugin_slug}_options<\/code><\/li>{plugin_slug}_version<\/code><\/li><\/ul>Common Queries<\/h2>Get option value<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_value \nFROM wp_options \nWHERE option_name = 'siteurl';<\/code><\/pre><\/div>Get all autoloaded options<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_name, option_value \nFROM wp_options \nWHERE autoload = 'yes';<\/code><\/pre><\/div>Calculate autoload size<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT \n SUM(LENGTH(option_value)) as total_bytes,\n COUNT(*) as option_count\nFROM wp_options \nWHERE autoload = 'yes';<\/code><\/pre><\/div>Find large options<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_name, LENGTH(option_value) as size_bytes\nFROM wp_options \nORDER BY size_bytes DESC \nLIMIT 20;<\/code><\/pre><\/div>Find expired transients<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT o.option_name, o.option_value\nFROM wp_options o\nJOIN wp_options t ON t.option_name = CONCAT('_transient_timeout_', \n SUBSTRING(o.option_name, 12))\nWHERE o.option_name LIKE '_transient_%'\n AND o.option_name NOT LIKE '_transient_timeout_%'\n AND t.option_value < UNIX_TIMESTAMP();<\/code><\/pre><\/div>Delete expired transients<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>DELETE a, b FROM wp_options a\nLEFT JOIN wp_options b ON b.option_name = CONCAT('_transient_timeout_', \n SUBSTRING(a.option_name, 12))\nWHERE a.option_name LIKE '_transient_%'\n AND a.option_name NOT LIKE '_transient_timeout_%'\n AND b.option_value IS NOT NULL\n AND b.option_value < UNIX_TIMESTAMP();<\/code><\/pre><\/div>Optimize autoload<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>-- Find options that shouldn't autoload\nSELECT option_name, LENGTH(option_value) as size\nFROM wp_options \nWHERE autoload = 'yes' \n AND LENGTH(option_value) > 10000\nORDER BY size DESC;\n\n-- Disable autoload for specific option\nUPDATE wp_options \nSET autoload = 'no' \nWHERE option_name = 'large_serialized_option';<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_option( $option, $default )<\/code> – Get option value<\/li>add_option( $option, $value, $deprecated, $autoload )<\/code> – Add option<\/li>update_option( $option, $value, $autoload )<\/code> – Update\/add option<\/li>delete_option( $option )<\/code> – Delete option<\/li>set_transient( $name, $value, $expiration )<\/code> – Set transient<\/li>get_transient( $name )<\/code> – Get transient<\/li>delete_transient( $name )<\/code> – Delete transient<\/li><\/ul>Performance Notes<\/h2>Autoload Optimization<\/h3>Large sites should audit autoloaded options:<\/p>sql<\/span><\/use><\/svg><\/button><\/div>SELECT SUM(LENGTH(option_value))\/1024 as kb FROM wp_options WHERE autoload='yes';<\/code><\/pre><\/div>Target: Keep autoload under 1MB total.<\/p>Transient Cleanup<\/h3>Transients without expiration never auto-delete. Periodically clean:<\/p>php<\/span>
nav_menu_options<\/code><\/td>Navigation menu settings<\/td><\/tr><\/tbody><\/table><\/figure>Cron & Transients<\/h3>Pattern<\/th>Description<\/th><\/tr><\/thead>cron<\/code><\/td>Scheduled tasks<\/td><\/tr>_transient_{name}<\/code><\/td>Cached data<\/td><\/tr>_transient_timeout_{name}<\/code><\/td>Transient expiration<\/td><\/tr>_site_transient_{name}<\/code><\/td>Network transient<\/td><\/tr><\/tbody><\/table><\/figure>Plugin Settings<\/h3>Plugins typically use patterns like:<\/p>{plugin_slug}_settings<\/code><\/li>{plugin_slug}_options<\/code><\/li>{plugin_slug}_version<\/code><\/li><\/ul>Common Queries<\/h2>Get option value<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_value \nFROM wp_options \nWHERE option_name = 'siteurl';<\/code><\/pre><\/div>Get all autoloaded options<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_name, option_value \nFROM wp_options \nWHERE autoload = 'yes';<\/code><\/pre><\/div>Calculate autoload size<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT \n SUM(LENGTH(option_value)) as total_bytes,\n COUNT(*) as option_count\nFROM wp_options \nWHERE autoload = 'yes';<\/code><\/pre><\/div>Find large options<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_name, LENGTH(option_value) as size_bytes\nFROM wp_options \nORDER BY size_bytes DESC \nLIMIT 20;<\/code><\/pre><\/div>Find expired transients<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT o.option_name, o.option_value\nFROM wp_options o\nJOIN wp_options t ON t.option_name = CONCAT('_transient_timeout_', \n SUBSTRING(o.option_name, 12))\nWHERE o.option_name LIKE '_transient_%'\n AND o.option_name NOT LIKE '_transient_timeout_%'\n AND t.option_value < UNIX_TIMESTAMP();<\/code><\/pre><\/div>Delete expired transients<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>DELETE a, b FROM wp_options a\nLEFT JOIN wp_options b ON b.option_name = CONCAT('_transient_timeout_', \n SUBSTRING(a.option_name, 12))\nWHERE a.option_name LIKE '_transient_%'\n AND a.option_name NOT LIKE '_transient_timeout_%'\n AND b.option_value IS NOT NULL\n AND b.option_value < UNIX_TIMESTAMP();<\/code><\/pre><\/div>Optimize autoload<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>-- Find options that shouldn't autoload\nSELECT option_name, LENGTH(option_value) as size\nFROM wp_options \nWHERE autoload = 'yes' \n AND LENGTH(option_value) > 10000\nORDER BY size DESC;\n\n-- Disable autoload for specific option\nUPDATE wp_options \nSET autoload = 'no' \nWHERE option_name = 'large_serialized_option';<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_option( $option, $default )<\/code> – Get option value<\/li>add_option( $option, $value, $deprecated, $autoload )<\/code> – Add option<\/li>update_option( $option, $value, $autoload )<\/code> – Update\/add option<\/li>delete_option( $option )<\/code> – Delete option<\/li>set_transient( $name, $value, $expiration )<\/code> – Set transient<\/li>get_transient( $name )<\/code> – Get transient<\/li>delete_transient( $name )<\/code> – Delete transient<\/li><\/ul>Performance Notes<\/h2>Autoload Optimization<\/h3>Large sites should audit autoloaded options:<\/p>sql<\/span><\/use><\/svg><\/button><\/div>SELECT SUM(LENGTH(option_value))\/1024 as kb FROM wp_options WHERE autoload='yes';<\/code><\/pre><\/div>Target: Keep autoload under 1MB total.<\/p>Transient Cleanup<\/h3>Transients without expiration never auto-delete. Periodically clean:<\/p>php<\/span>
cron<\/code><\/td>Scheduled tasks<\/td><\/tr>_transient_{name}<\/code><\/td>Cached data<\/td><\/tr>_transient_timeout_{name}<\/code><\/td>Transient expiration<\/td><\/tr>_site_transient_{name}<\/code><\/td>Network transient<\/td><\/tr><\/tbody><\/table><\/figure>Plugin Settings<\/h3>Plugins typically use patterns like:<\/p>{plugin_slug}_settings<\/code><\/li>{plugin_slug}_options<\/code><\/li>{plugin_slug}_version<\/code><\/li><\/ul>Common Queries<\/h2>Get option value<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_value \nFROM wp_options \nWHERE option_name = 'siteurl';<\/code><\/pre><\/div>Get all autoloaded options<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_name, option_value \nFROM wp_options \nWHERE autoload = 'yes';<\/code><\/pre><\/div>Calculate autoload size<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT \n SUM(LENGTH(option_value)) as total_bytes,\n COUNT(*) as option_count\nFROM wp_options \nWHERE autoload = 'yes';<\/code><\/pre><\/div>Find large options<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_name, LENGTH(option_value) as size_bytes\nFROM wp_options \nORDER BY size_bytes DESC \nLIMIT 20;<\/code><\/pre><\/div>Find expired transients<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT o.option_name, o.option_value\nFROM wp_options o\nJOIN wp_options t ON t.option_name = CONCAT('_transient_timeout_', \n SUBSTRING(o.option_name, 12))\nWHERE o.option_name LIKE '_transient_%'\n AND o.option_name NOT LIKE '_transient_timeout_%'\n AND t.option_value < UNIX_TIMESTAMP();<\/code><\/pre><\/div>Delete expired transients<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>DELETE a, b FROM wp_options a\nLEFT JOIN wp_options b ON b.option_name = CONCAT('_transient_timeout_', \n SUBSTRING(a.option_name, 12))\nWHERE a.option_name LIKE '_transient_%'\n AND a.option_name NOT LIKE '_transient_timeout_%'\n AND b.option_value IS NOT NULL\n AND b.option_value < UNIX_TIMESTAMP();<\/code><\/pre><\/div>Optimize autoload<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>-- Find options that shouldn't autoload\nSELECT option_name, LENGTH(option_value) as size\nFROM wp_options \nWHERE autoload = 'yes' \n AND LENGTH(option_value) > 10000\nORDER BY size DESC;\n\n-- Disable autoload for specific option\nUPDATE wp_options \nSET autoload = 'no' \nWHERE option_name = 'large_serialized_option';<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_option( $option, $default )<\/code> – Get option value<\/li>add_option( $option, $value, $deprecated, $autoload )<\/code> – Add option<\/li>update_option( $option, $value, $autoload )<\/code> – Update\/add option<\/li>delete_option( $option )<\/code> – Delete option<\/li>set_transient( $name, $value, $expiration )<\/code> – Set transient<\/li>get_transient( $name )<\/code> – Get transient<\/li>delete_transient( $name )<\/code> – Delete transient<\/li><\/ul>Performance Notes<\/h2>Autoload Optimization<\/h3>Large sites should audit autoloaded options:<\/p>sql<\/span><\/use><\/svg><\/button><\/div>SELECT SUM(LENGTH(option_value))\/1024 as kb FROM wp_options WHERE autoload='yes';<\/code><\/pre><\/div>Target: Keep autoload under 1MB total.<\/p>Transient Cleanup<\/h3>Transients without expiration never auto-delete. Periodically clean:<\/p>php<\/span>
_transient_{name}<\/code><\/td>Cached data<\/td><\/tr>_transient_timeout_{name}<\/code><\/td>Transient expiration<\/td><\/tr>_site_transient_{name}<\/code><\/td>Network transient<\/td><\/tr><\/tbody><\/table><\/figure>Plugin Settings<\/h3>Plugins typically use patterns like:<\/p>{plugin_slug}_settings<\/code><\/li>{plugin_slug}_options<\/code><\/li>{plugin_slug}_version<\/code><\/li><\/ul>Common Queries<\/h2>Get option value<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_value \nFROM wp_options \nWHERE option_name = 'siteurl';<\/code><\/pre><\/div>Get all autoloaded options<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_name, option_value \nFROM wp_options \nWHERE autoload = 'yes';<\/code><\/pre><\/div>Calculate autoload size<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT \n SUM(LENGTH(option_value)) as total_bytes,\n COUNT(*) as option_count\nFROM wp_options \nWHERE autoload = 'yes';<\/code><\/pre><\/div>Find large options<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_name, LENGTH(option_value) as size_bytes\nFROM wp_options \nORDER BY size_bytes DESC \nLIMIT 20;<\/code><\/pre><\/div>Find expired transients<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT o.option_name, o.option_value\nFROM wp_options o\nJOIN wp_options t ON t.option_name = CONCAT('_transient_timeout_', \n SUBSTRING(o.option_name, 12))\nWHERE o.option_name LIKE '_transient_%'\n AND o.option_name NOT LIKE '_transient_timeout_%'\n AND t.option_value < UNIX_TIMESTAMP();<\/code><\/pre><\/div>Delete expired transients<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>DELETE a, b FROM wp_options a\nLEFT JOIN wp_options b ON b.option_name = CONCAT('_transient_timeout_', \n SUBSTRING(a.option_name, 12))\nWHERE a.option_name LIKE '_transient_%'\n AND a.option_name NOT LIKE '_transient_timeout_%'\n AND b.option_value IS NOT NULL\n AND b.option_value < UNIX_TIMESTAMP();<\/code><\/pre><\/div>Optimize autoload<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>-- Find options that shouldn't autoload\nSELECT option_name, LENGTH(option_value) as size\nFROM wp_options \nWHERE autoload = 'yes' \n AND LENGTH(option_value) > 10000\nORDER BY size DESC;\n\n-- Disable autoload for specific option\nUPDATE wp_options \nSET autoload = 'no' \nWHERE option_name = 'large_serialized_option';<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_option( $option, $default )<\/code> – Get option value<\/li>add_option( $option, $value, $deprecated, $autoload )<\/code> – Add option<\/li>update_option( $option, $value, $autoload )<\/code> – Update\/add option<\/li>delete_option( $option )<\/code> – Delete option<\/li>set_transient( $name, $value, $expiration )<\/code> – Set transient<\/li>get_transient( $name )<\/code> – Get transient<\/li>delete_transient( $name )<\/code> – Delete transient<\/li><\/ul>Performance Notes<\/h2>Autoload Optimization<\/h3>Large sites should audit autoloaded options:<\/p>sql<\/span><\/use><\/svg><\/button><\/div>SELECT SUM(LENGTH(option_value))\/1024 as kb FROM wp_options WHERE autoload='yes';<\/code><\/pre><\/div>Target: Keep autoload under 1MB total.<\/p>Transient Cleanup<\/h3>Transients without expiration never auto-delete. Periodically clean:<\/p>php<\/span>
_transient_timeout_{name}<\/code><\/td>Transient expiration<\/td><\/tr>_site_transient_{name}<\/code><\/td>Network transient<\/td><\/tr><\/tbody><\/table><\/figure>Plugin Settings<\/h3>Plugins typically use patterns like:<\/p>{plugin_slug}_settings<\/code><\/li>{plugin_slug}_options<\/code><\/li>{plugin_slug}_version<\/code><\/li><\/ul>Common Queries<\/h2>Get option value<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_value \nFROM wp_options \nWHERE option_name = 'siteurl';<\/code><\/pre><\/div>Get all autoloaded options<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_name, option_value \nFROM wp_options \nWHERE autoload = 'yes';<\/code><\/pre><\/div>Calculate autoload size<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT \n SUM(LENGTH(option_value)) as total_bytes,\n COUNT(*) as option_count\nFROM wp_options \nWHERE autoload = 'yes';<\/code><\/pre><\/div>Find large options<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_name, LENGTH(option_value) as size_bytes\nFROM wp_options \nORDER BY size_bytes DESC \nLIMIT 20;<\/code><\/pre><\/div>Find expired transients<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT o.option_name, o.option_value\nFROM wp_options o\nJOIN wp_options t ON t.option_name = CONCAT('_transient_timeout_', \n SUBSTRING(o.option_name, 12))\nWHERE o.option_name LIKE '_transient_%'\n AND o.option_name NOT LIKE '_transient_timeout_%'\n AND t.option_value < UNIX_TIMESTAMP();<\/code><\/pre><\/div>Delete expired transients<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>DELETE a, b FROM wp_options a\nLEFT JOIN wp_options b ON b.option_name = CONCAT('_transient_timeout_', \n SUBSTRING(a.option_name, 12))\nWHERE a.option_name LIKE '_transient_%'\n AND a.option_name NOT LIKE '_transient_timeout_%'\n AND b.option_value IS NOT NULL\n AND b.option_value < UNIX_TIMESTAMP();<\/code><\/pre><\/div>Optimize autoload<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>-- Find options that shouldn't autoload\nSELECT option_name, LENGTH(option_value) as size\nFROM wp_options \nWHERE autoload = 'yes' \n AND LENGTH(option_value) > 10000\nORDER BY size DESC;\n\n-- Disable autoload for specific option\nUPDATE wp_options \nSET autoload = 'no' \nWHERE option_name = 'large_serialized_option';<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_option( $option, $default )<\/code> – Get option value<\/li>add_option( $option, $value, $deprecated, $autoload )<\/code> – Add option<\/li>update_option( $option, $value, $autoload )<\/code> – Update\/add option<\/li>delete_option( $option )<\/code> – Delete option<\/li>set_transient( $name, $value, $expiration )<\/code> – Set transient<\/li>get_transient( $name )<\/code> – Get transient<\/li>delete_transient( $name )<\/code> – Delete transient<\/li><\/ul>Performance Notes<\/h2>Autoload Optimization<\/h3>Large sites should audit autoloaded options:<\/p>sql<\/span><\/use><\/svg><\/button><\/div>SELECT SUM(LENGTH(option_value))\/1024 as kb FROM wp_options WHERE autoload='yes';<\/code><\/pre><\/div>Target: Keep autoload under 1MB total.<\/p>Transient Cleanup<\/h3>Transients without expiration never auto-delete. Periodically clean:<\/p>php<\/span>
_site_transient_{name}<\/code><\/td>Network transient<\/td><\/tr><\/tbody><\/table><\/figure>Plugin Settings<\/h3>Plugins typically use patterns like:<\/p>{plugin_slug}_settings<\/code><\/li>{plugin_slug}_options<\/code><\/li>{plugin_slug}_version<\/code><\/li><\/ul>Common Queries<\/h2>Get option value<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_value \nFROM wp_options \nWHERE option_name = 'siteurl';<\/code><\/pre><\/div>Get all autoloaded options<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_name, option_value \nFROM wp_options \nWHERE autoload = 'yes';<\/code><\/pre><\/div>Calculate autoload size<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT \n SUM(LENGTH(option_value)) as total_bytes,\n COUNT(*) as option_count\nFROM wp_options \nWHERE autoload = 'yes';<\/code><\/pre><\/div>Find large options<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_name, LENGTH(option_value) as size_bytes\nFROM wp_options \nORDER BY size_bytes DESC \nLIMIT 20;<\/code><\/pre><\/div>Find expired transients<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT o.option_name, o.option_value\nFROM wp_options o\nJOIN wp_options t ON t.option_name = CONCAT('_transient_timeout_', \n SUBSTRING(o.option_name, 12))\nWHERE o.option_name LIKE '_transient_%'\n AND o.option_name NOT LIKE '_transient_timeout_%'\n AND t.option_value < UNIX_TIMESTAMP();<\/code><\/pre><\/div>Delete expired transients<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>DELETE a, b FROM wp_options a\nLEFT JOIN wp_options b ON b.option_name = CONCAT('_transient_timeout_', \n SUBSTRING(a.option_name, 12))\nWHERE a.option_name LIKE '_transient_%'\n AND a.option_name NOT LIKE '_transient_timeout_%'\n AND b.option_value IS NOT NULL\n AND b.option_value < UNIX_TIMESTAMP();<\/code><\/pre><\/div>Optimize autoload<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>-- Find options that shouldn't autoload\nSELECT option_name, LENGTH(option_value) as size\nFROM wp_options \nWHERE autoload = 'yes' \n AND LENGTH(option_value) > 10000\nORDER BY size DESC;\n\n-- Disable autoload for specific option\nUPDATE wp_options \nSET autoload = 'no' \nWHERE option_name = 'large_serialized_option';<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_option( $option, $default )<\/code> – Get option value<\/li>add_option( $option, $value, $deprecated, $autoload )<\/code> – Add option<\/li>update_option( $option, $value, $autoload )<\/code> – Update\/add option<\/li>delete_option( $option )<\/code> – Delete option<\/li>set_transient( $name, $value, $expiration )<\/code> – Set transient<\/li>get_transient( $name )<\/code> – Get transient<\/li>delete_transient( $name )<\/code> – Delete transient<\/li><\/ul>Performance Notes<\/h2>Autoload Optimization<\/h3>Large sites should audit autoloaded options:<\/p>sql<\/span><\/use><\/svg><\/button><\/div>SELECT SUM(LENGTH(option_value))\/1024 as kb FROM wp_options WHERE autoload='yes';<\/code><\/pre><\/div>Target: Keep autoload under 1MB total.<\/p>Transient Cleanup<\/h3>Transients without expiration never auto-delete. Periodically clean:<\/p>php<\/span>
Plugins typically use patterns like:<\/p>
{plugin_slug}_settings<\/code><\/li>{plugin_slug}_options<\/code><\/li>{plugin_slug}_version<\/code><\/li><\/ul>Common Queries<\/h2>Get option value<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_value \nFROM wp_options \nWHERE option_name = 'siteurl';<\/code><\/pre><\/div>Get all autoloaded options<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_name, option_value \nFROM wp_options \nWHERE autoload = 'yes';<\/code><\/pre><\/div>Calculate autoload size<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT \n SUM(LENGTH(option_value)) as total_bytes,\n COUNT(*) as option_count\nFROM wp_options \nWHERE autoload = 'yes';<\/code><\/pre><\/div>Find large options<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_name, LENGTH(option_value) as size_bytes\nFROM wp_options \nORDER BY size_bytes DESC \nLIMIT 20;<\/code><\/pre><\/div>Find expired transients<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT o.option_name, o.option_value\nFROM wp_options o\nJOIN wp_options t ON t.option_name = CONCAT('_transient_timeout_', \n SUBSTRING(o.option_name, 12))\nWHERE o.option_name LIKE '_transient_%'\n AND o.option_name NOT LIKE '_transient_timeout_%'\n AND t.option_value < UNIX_TIMESTAMP();<\/code><\/pre><\/div>Delete expired transients<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>DELETE a, b FROM wp_options a\nLEFT JOIN wp_options b ON b.option_name = CONCAT('_transient_timeout_', \n SUBSTRING(a.option_name, 12))\nWHERE a.option_name LIKE '_transient_%'\n AND a.option_name NOT LIKE '_transient_timeout_%'\n AND b.option_value IS NOT NULL\n AND b.option_value < UNIX_TIMESTAMP();<\/code><\/pre><\/div>Optimize autoload<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>-- Find options that shouldn't autoload\nSELECT option_name, LENGTH(option_value) as size\nFROM wp_options \nWHERE autoload = 'yes' \n AND LENGTH(option_value) > 10000\nORDER BY size DESC;\n\n-- Disable autoload for specific option\nUPDATE wp_options \nSET autoload = 'no' \nWHERE option_name = 'large_serialized_option';<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_option( $option, $default )<\/code> – Get option value<\/li>add_option( $option, $value, $deprecated, $autoload )<\/code> – Add option<\/li>update_option( $option, $value, $autoload )<\/code> – Update\/add option<\/li>delete_option( $option )<\/code> – Delete option<\/li>set_transient( $name, $value, $expiration )<\/code> – Set transient<\/li>get_transient( $name )<\/code> – Get transient<\/li>delete_transient( $name )<\/code> – Delete transient<\/li><\/ul>Performance Notes<\/h2>Autoload Optimization<\/h3>Large sites should audit autoloaded options:<\/p>sql<\/span><\/use><\/svg><\/button><\/div>SELECT SUM(LENGTH(option_value))\/1024 as kb FROM wp_options WHERE autoload='yes';<\/code><\/pre><\/div>Target: Keep autoload under 1MB total.<\/p>Transient Cleanup<\/h3>Transients without expiration never auto-delete. Periodically clean:<\/p>php<\/span>
{plugin_slug}_options<\/code><\/li>{plugin_slug}_version<\/code><\/li><\/ul>Common Queries<\/h2>Get option value<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_value \nFROM wp_options \nWHERE option_name = 'siteurl';<\/code><\/pre><\/div>Get all autoloaded options<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_name, option_value \nFROM wp_options \nWHERE autoload = 'yes';<\/code><\/pre><\/div>Calculate autoload size<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT \n SUM(LENGTH(option_value)) as total_bytes,\n COUNT(*) as option_count\nFROM wp_options \nWHERE autoload = 'yes';<\/code><\/pre><\/div>Find large options<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_name, LENGTH(option_value) as size_bytes\nFROM wp_options \nORDER BY size_bytes DESC \nLIMIT 20;<\/code><\/pre><\/div>Find expired transients<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT o.option_name, o.option_value\nFROM wp_options o\nJOIN wp_options t ON t.option_name = CONCAT('_transient_timeout_', \n SUBSTRING(o.option_name, 12))\nWHERE o.option_name LIKE '_transient_%'\n AND o.option_name NOT LIKE '_transient_timeout_%'\n AND t.option_value < UNIX_TIMESTAMP();<\/code><\/pre><\/div>Delete expired transients<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>DELETE a, b FROM wp_options a\nLEFT JOIN wp_options b ON b.option_name = CONCAT('_transient_timeout_', \n SUBSTRING(a.option_name, 12))\nWHERE a.option_name LIKE '_transient_%'\n AND a.option_name NOT LIKE '_transient_timeout_%'\n AND b.option_value IS NOT NULL\n AND b.option_value < UNIX_TIMESTAMP();<\/code><\/pre><\/div>Optimize autoload<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>-- Find options that shouldn't autoload\nSELECT option_name, LENGTH(option_value) as size\nFROM wp_options \nWHERE autoload = 'yes' \n AND LENGTH(option_value) > 10000\nORDER BY size DESC;\n\n-- Disable autoload for specific option\nUPDATE wp_options \nSET autoload = 'no' \nWHERE option_name = 'large_serialized_option';<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_option( $option, $default )<\/code> – Get option value<\/li>add_option( $option, $value, $deprecated, $autoload )<\/code> – Add option<\/li>update_option( $option, $value, $autoload )<\/code> – Update\/add option<\/li>delete_option( $option )<\/code> – Delete option<\/li>set_transient( $name, $value, $expiration )<\/code> – Set transient<\/li>get_transient( $name )<\/code> – Get transient<\/li>delete_transient( $name )<\/code> – Delete transient<\/li><\/ul>Performance Notes<\/h2>Autoload Optimization<\/h3>Large sites should audit autoloaded options:<\/p>sql<\/span><\/use><\/svg><\/button><\/div>SELECT SUM(LENGTH(option_value))\/1024 as kb FROM wp_options WHERE autoload='yes';<\/code><\/pre><\/div>Target: Keep autoload under 1MB total.<\/p>Transient Cleanup<\/h3>Transients without expiration never auto-delete. Periodically clean:<\/p>php<\/span>
{plugin_slug}_version<\/code><\/li><\/ul>Common Queries<\/h2>Get option value<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_value \nFROM wp_options \nWHERE option_name = 'siteurl';<\/code><\/pre><\/div>Get all autoloaded options<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_name, option_value \nFROM wp_options \nWHERE autoload = 'yes';<\/code><\/pre><\/div>Calculate autoload size<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT \n SUM(LENGTH(option_value)) as total_bytes,\n COUNT(*) as option_count\nFROM wp_options \nWHERE autoload = 'yes';<\/code><\/pre><\/div>Find large options<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_name, LENGTH(option_value) as size_bytes\nFROM wp_options \nORDER BY size_bytes DESC \nLIMIT 20;<\/code><\/pre><\/div>Find expired transients<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT o.option_name, o.option_value\nFROM wp_options o\nJOIN wp_options t ON t.option_name = CONCAT('_transient_timeout_', \n SUBSTRING(o.option_name, 12))\nWHERE o.option_name LIKE '_transient_%'\n AND o.option_name NOT LIKE '_transient_timeout_%'\n AND t.option_value < UNIX_TIMESTAMP();<\/code><\/pre><\/div>Delete expired transients<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>DELETE a, b FROM wp_options a\nLEFT JOIN wp_options b ON b.option_name = CONCAT('_transient_timeout_', \n SUBSTRING(a.option_name, 12))\nWHERE a.option_name LIKE '_transient_%'\n AND a.option_name NOT LIKE '_transient_timeout_%'\n AND b.option_value IS NOT NULL\n AND b.option_value < UNIX_TIMESTAMP();<\/code><\/pre><\/div>Optimize autoload<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>-- Find options that shouldn't autoload\nSELECT option_name, LENGTH(option_value) as size\nFROM wp_options \nWHERE autoload = 'yes' \n AND LENGTH(option_value) > 10000\nORDER BY size DESC;\n\n-- Disable autoload for specific option\nUPDATE wp_options \nSET autoload = 'no' \nWHERE option_name = 'large_serialized_option';<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_option( $option, $default )<\/code> – Get option value<\/li>add_option( $option, $value, $deprecated, $autoload )<\/code> – Add option<\/li>update_option( $option, $value, $autoload )<\/code> – Update\/add option<\/li>delete_option( $option )<\/code> – Delete option<\/li>set_transient( $name, $value, $expiration )<\/code> – Set transient<\/li>get_transient( $name )<\/code> – Get transient<\/li>delete_transient( $name )<\/code> – Delete transient<\/li><\/ul>Performance Notes<\/h2>Autoload Optimization<\/h3>Large sites should audit autoloaded options:<\/p>sql<\/span><\/use><\/svg><\/button><\/div>SELECT SUM(LENGTH(option_value))\/1024 as kb FROM wp_options WHERE autoload='yes';<\/code><\/pre><\/div>Target: Keep autoload under 1MB total.<\/p>Transient Cleanup<\/h3>Transients without expiration never auto-delete. Periodically clean:<\/p>php<\/span>
SELECT option_value \nFROM wp_options \nWHERE option_name = 'siteurl';<\/code><\/pre><\/div>Get all autoloaded options<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_name, option_value \nFROM wp_options \nWHERE autoload = 'yes';<\/code><\/pre><\/div>Calculate autoload size<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT \n SUM(LENGTH(option_value)) as total_bytes,\n COUNT(*) as option_count\nFROM wp_options \nWHERE autoload = 'yes';<\/code><\/pre><\/div>Find large options<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_name, LENGTH(option_value) as size_bytes\nFROM wp_options \nORDER BY size_bytes DESC \nLIMIT 20;<\/code><\/pre><\/div>Find expired transients<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT o.option_name, o.option_value\nFROM wp_options o\nJOIN wp_options t ON t.option_name = CONCAT('_transient_timeout_', \n SUBSTRING(o.option_name, 12))\nWHERE o.option_name LIKE '_transient_%'\n AND o.option_name NOT LIKE '_transient_timeout_%'\n AND t.option_value < UNIX_TIMESTAMP();<\/code><\/pre><\/div>Delete expired transients<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>DELETE a, b FROM wp_options a\nLEFT JOIN wp_options b ON b.option_name = CONCAT('_transient_timeout_', \n SUBSTRING(a.option_name, 12))\nWHERE a.option_name LIKE '_transient_%'\n AND a.option_name NOT LIKE '_transient_timeout_%'\n AND b.option_value IS NOT NULL\n AND b.option_value < UNIX_TIMESTAMP();<\/code><\/pre><\/div>Optimize autoload<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>-- Find options that shouldn't autoload\nSELECT option_name, LENGTH(option_value) as size\nFROM wp_options \nWHERE autoload = 'yes' \n AND LENGTH(option_value) > 10000\nORDER BY size DESC;\n\n-- Disable autoload for specific option\nUPDATE wp_options \nSET autoload = 'no' \nWHERE option_name = 'large_serialized_option';<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_option( $option, $default )<\/code> – Get option value<\/li>add_option( $option, $value, $deprecated, $autoload )<\/code> – Add option<\/li>update_option( $option, $value, $autoload )<\/code> – Update\/add option<\/li>delete_option( $option )<\/code> – Delete option<\/li>set_transient( $name, $value, $expiration )<\/code> – Set transient<\/li>get_transient( $name )<\/code> – Get transient<\/li>delete_transient( $name )<\/code> – Delete transient<\/li><\/ul>Performance Notes<\/h2>Autoload Optimization<\/h3>Large sites should audit autoloaded options:<\/p>sql<\/span><\/use><\/svg><\/button><\/div>SELECT SUM(LENGTH(option_value))\/1024 as kb FROM wp_options WHERE autoload='yes';<\/code><\/pre><\/div>Target: Keep autoload under 1MB total.<\/p>Transient Cleanup<\/h3>Transients without expiration never auto-delete. Periodically clean:<\/p>php<\/span>
SELECT option_name, option_value \nFROM wp_options \nWHERE autoload = 'yes';<\/code><\/pre><\/div>Calculate autoload size<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT \n SUM(LENGTH(option_value)) as total_bytes,\n COUNT(*) as option_count\nFROM wp_options \nWHERE autoload = 'yes';<\/code><\/pre><\/div>Find large options<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_name, LENGTH(option_value) as size_bytes\nFROM wp_options \nORDER BY size_bytes DESC \nLIMIT 20;<\/code><\/pre><\/div>Find expired transients<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT o.option_name, o.option_value\nFROM wp_options o\nJOIN wp_options t ON t.option_name = CONCAT('_transient_timeout_', \n SUBSTRING(o.option_name, 12))\nWHERE o.option_name LIKE '_transient_%'\n AND o.option_name NOT LIKE '_transient_timeout_%'\n AND t.option_value < UNIX_TIMESTAMP();<\/code><\/pre><\/div>Delete expired transients<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>DELETE a, b FROM wp_options a\nLEFT JOIN wp_options b ON b.option_name = CONCAT('_transient_timeout_', \n SUBSTRING(a.option_name, 12))\nWHERE a.option_name LIKE '_transient_%'\n AND a.option_name NOT LIKE '_transient_timeout_%'\n AND b.option_value IS NOT NULL\n AND b.option_value < UNIX_TIMESTAMP();<\/code><\/pre><\/div>Optimize autoload<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>-- Find options that shouldn't autoload\nSELECT option_name, LENGTH(option_value) as size\nFROM wp_options \nWHERE autoload = 'yes' \n AND LENGTH(option_value) > 10000\nORDER BY size DESC;\n\n-- Disable autoload for specific option\nUPDATE wp_options \nSET autoload = 'no' \nWHERE option_name = 'large_serialized_option';<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_option( $option, $default )<\/code> – Get option value<\/li>add_option( $option, $value, $deprecated, $autoload )<\/code> – Add option<\/li>update_option( $option, $value, $autoload )<\/code> – Update\/add option<\/li>delete_option( $option )<\/code> – Delete option<\/li>set_transient( $name, $value, $expiration )<\/code> – Set transient<\/li>get_transient( $name )<\/code> – Get transient<\/li>delete_transient( $name )<\/code> – Delete transient<\/li><\/ul>Performance Notes<\/h2>Autoload Optimization<\/h3>Large sites should audit autoloaded options:<\/p>sql<\/span><\/use><\/svg><\/button><\/div>SELECT SUM(LENGTH(option_value))\/1024 as kb FROM wp_options WHERE autoload='yes';<\/code><\/pre><\/div>Target: Keep autoload under 1MB total.<\/p>Transient Cleanup<\/h3>Transients without expiration never auto-delete. Periodically clean:<\/p>php<\/span>
SELECT \n SUM(LENGTH(option_value)) as total_bytes,\n COUNT(*) as option_count\nFROM wp_options \nWHERE autoload = 'yes';<\/code><\/pre><\/div>Find large options<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT option_name, LENGTH(option_value) as size_bytes\nFROM wp_options \nORDER BY size_bytes DESC \nLIMIT 20;<\/code><\/pre><\/div>Find expired transients<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT o.option_name, o.option_value\nFROM wp_options o\nJOIN wp_options t ON t.option_name = CONCAT('_transient_timeout_', \n SUBSTRING(o.option_name, 12))\nWHERE o.option_name LIKE '_transient_%'\n AND o.option_name NOT LIKE '_transient_timeout_%'\n AND t.option_value < UNIX_TIMESTAMP();<\/code><\/pre><\/div>Delete expired transients<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>DELETE a, b FROM wp_options a\nLEFT JOIN wp_options b ON b.option_name = CONCAT('_transient_timeout_', \n SUBSTRING(a.option_name, 12))\nWHERE a.option_name LIKE '_transient_%'\n AND a.option_name NOT LIKE '_transient_timeout_%'\n AND b.option_value IS NOT NULL\n AND b.option_value < UNIX_TIMESTAMP();<\/code><\/pre><\/div>Optimize autoload<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>-- Find options that shouldn't autoload\nSELECT option_name, LENGTH(option_value) as size\nFROM wp_options \nWHERE autoload = 'yes' \n AND LENGTH(option_value) > 10000\nORDER BY size DESC;\n\n-- Disable autoload for specific option\nUPDATE wp_options \nSET autoload = 'no' \nWHERE option_name = 'large_serialized_option';<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_option( $option, $default )<\/code> – Get option value<\/li>add_option( $option, $value, $deprecated, $autoload )<\/code> – Add option<\/li>update_option( $option, $value, $autoload )<\/code> – Update\/add option<\/li>delete_option( $option )<\/code> – Delete option<\/li>set_transient( $name, $value, $expiration )<\/code> – Set transient<\/li>get_transient( $name )<\/code> – Get transient<\/li>delete_transient( $name )<\/code> – Delete transient<\/li><\/ul>Performance Notes<\/h2>Autoload Optimization<\/h3>Large sites should audit autoloaded options:<\/p>sql<\/span><\/use><\/svg><\/button><\/div>SELECT SUM(LENGTH(option_value))\/1024 as kb FROM wp_options WHERE autoload='yes';<\/code><\/pre><\/div>Target: Keep autoload under 1MB total.<\/p>Transient Cleanup<\/h3>Transients without expiration never auto-delete. Periodically clean:<\/p>php<\/span>
SELECT option_name, LENGTH(option_value) as size_bytes\nFROM wp_options \nORDER BY size_bytes DESC \nLIMIT 20;<\/code><\/pre><\/div>Find expired transients<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT o.option_name, o.option_value\nFROM wp_options o\nJOIN wp_options t ON t.option_name = CONCAT('_transient_timeout_', \n SUBSTRING(o.option_name, 12))\nWHERE o.option_name LIKE '_transient_%'\n AND o.option_name NOT LIKE '_transient_timeout_%'\n AND t.option_value < UNIX_TIMESTAMP();<\/code><\/pre><\/div>Delete expired transients<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>DELETE a, b FROM wp_options a\nLEFT JOIN wp_options b ON b.option_name = CONCAT('_transient_timeout_', \n SUBSTRING(a.option_name, 12))\nWHERE a.option_name LIKE '_transient_%'\n AND a.option_name NOT LIKE '_transient_timeout_%'\n AND b.option_value IS NOT NULL\n AND b.option_value < UNIX_TIMESTAMP();<\/code><\/pre><\/div>Optimize autoload<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>-- Find options that shouldn't autoload\nSELECT option_name, LENGTH(option_value) as size\nFROM wp_options \nWHERE autoload = 'yes' \n AND LENGTH(option_value) > 10000\nORDER BY size DESC;\n\n-- Disable autoload for specific option\nUPDATE wp_options \nSET autoload = 'no' \nWHERE option_name = 'large_serialized_option';<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_option( $option, $default )<\/code> – Get option value<\/li>add_option( $option, $value, $deprecated, $autoload )<\/code> – Add option<\/li>update_option( $option, $value, $autoload )<\/code> – Update\/add option<\/li>delete_option( $option )<\/code> – Delete option<\/li>set_transient( $name, $value, $expiration )<\/code> – Set transient<\/li>get_transient( $name )<\/code> – Get transient<\/li>delete_transient( $name )<\/code> – Delete transient<\/li><\/ul>Performance Notes<\/h2>Autoload Optimization<\/h3>Large sites should audit autoloaded options:<\/p>sql<\/span><\/use><\/svg><\/button><\/div>SELECT SUM(LENGTH(option_value))\/1024 as kb FROM wp_options WHERE autoload='yes';<\/code><\/pre><\/div>Target: Keep autoload under 1MB total.<\/p>Transient Cleanup<\/h3>Transients without expiration never auto-delete. Periodically clean:<\/p>php<\/span>
SELECT o.option_name, o.option_value\nFROM wp_options o\nJOIN wp_options t ON t.option_name = CONCAT('_transient_timeout_', \n SUBSTRING(o.option_name, 12))\nWHERE o.option_name LIKE '_transient_%'\n AND o.option_name NOT LIKE '_transient_timeout_%'\n AND t.option_value < UNIX_TIMESTAMP();<\/code><\/pre><\/div>Delete expired transients<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>DELETE a, b FROM wp_options a\nLEFT JOIN wp_options b ON b.option_name = CONCAT('_transient_timeout_', \n SUBSTRING(a.option_name, 12))\nWHERE a.option_name LIKE '_transient_%'\n AND a.option_name NOT LIKE '_transient_timeout_%'\n AND b.option_value IS NOT NULL\n AND b.option_value < UNIX_TIMESTAMP();<\/code><\/pre><\/div>Optimize autoload<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>-- Find options that shouldn't autoload\nSELECT option_name, LENGTH(option_value) as size\nFROM wp_options \nWHERE autoload = 'yes' \n AND LENGTH(option_value) > 10000\nORDER BY size DESC;\n\n-- Disable autoload for specific option\nUPDATE wp_options \nSET autoload = 'no' \nWHERE option_name = 'large_serialized_option';<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_option( $option, $default )<\/code> – Get option value<\/li>add_option( $option, $value, $deprecated, $autoload )<\/code> – Add option<\/li>update_option( $option, $value, $autoload )<\/code> – Update\/add option<\/li>delete_option( $option )<\/code> – Delete option<\/li>set_transient( $name, $value, $expiration )<\/code> – Set transient<\/li>get_transient( $name )<\/code> – Get transient<\/li>delete_transient( $name )<\/code> – Delete transient<\/li><\/ul>Performance Notes<\/h2>Autoload Optimization<\/h3>Large sites should audit autoloaded options:<\/p>sql<\/span><\/use><\/svg><\/button><\/div>SELECT SUM(LENGTH(option_value))\/1024 as kb FROM wp_options WHERE autoload='yes';<\/code><\/pre><\/div>Target: Keep autoload under 1MB total.<\/p>Transient Cleanup<\/h3>Transients without expiration never auto-delete. Periodically clean:<\/p>php<\/span>
DELETE a, b FROM wp_options a\nLEFT JOIN wp_options b ON b.option_name = CONCAT('_transient_timeout_', \n SUBSTRING(a.option_name, 12))\nWHERE a.option_name LIKE '_transient_%'\n AND a.option_name NOT LIKE '_transient_timeout_%'\n AND b.option_value IS NOT NULL\n AND b.option_value < UNIX_TIMESTAMP();<\/code><\/pre><\/div>Optimize autoload<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>-- Find options that shouldn't autoload\nSELECT option_name, LENGTH(option_value) as size\nFROM wp_options \nWHERE autoload = 'yes' \n AND LENGTH(option_value) > 10000\nORDER BY size DESC;\n\n-- Disable autoload for specific option\nUPDATE wp_options \nSET autoload = 'no' \nWHERE option_name = 'large_serialized_option';<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_option( $option, $default )<\/code> – Get option value<\/li>add_option( $option, $value, $deprecated, $autoload )<\/code> – Add option<\/li>update_option( $option, $value, $autoload )<\/code> – Update\/add option<\/li>delete_option( $option )<\/code> – Delete option<\/li>set_transient( $name, $value, $expiration )<\/code> – Set transient<\/li>get_transient( $name )<\/code> – Get transient<\/li>delete_transient( $name )<\/code> – Delete transient<\/li><\/ul>Performance Notes<\/h2>Autoload Optimization<\/h3>Large sites should audit autoloaded options:<\/p>sql<\/span><\/use><\/svg><\/button><\/div>SELECT SUM(LENGTH(option_value))\/1024 as kb FROM wp_options WHERE autoload='yes';<\/code><\/pre><\/div>Target: Keep autoload under 1MB total.<\/p>Transient Cleanup<\/h3>Transients without expiration never auto-delete. Periodically clean:<\/p>php<\/span>
-- Find options that shouldn't autoload\nSELECT option_name, LENGTH(option_value) as size\nFROM wp_options \nWHERE autoload = 'yes' \n AND LENGTH(option_value) > 10000\nORDER BY size DESC;\n\n-- Disable autoload for specific option\nUPDATE wp_options \nSET autoload = 'no' \nWHERE option_name = 'large_serialized_option';<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_option( $option, $default )<\/code> – Get option value<\/li>add_option( $option, $value, $deprecated, $autoload )<\/code> – Add option<\/li>update_option( $option, $value, $autoload )<\/code> – Update\/add option<\/li>delete_option( $option )<\/code> – Delete option<\/li>set_transient( $name, $value, $expiration )<\/code> – Set transient<\/li>get_transient( $name )<\/code> – Get transient<\/li>delete_transient( $name )<\/code> – Delete transient<\/li><\/ul>Performance Notes<\/h2>Autoload Optimization<\/h3>Large sites should audit autoloaded options:<\/p>sql<\/span><\/use><\/svg><\/button><\/div>SELECT SUM(LENGTH(option_value))\/1024 as kb FROM wp_options WHERE autoload='yes';<\/code><\/pre><\/div>Target: Keep autoload under 1MB total.<\/p>Transient Cleanup<\/h3>Transients without expiration never auto-delete. Periodically clean:<\/p>php<\/span>
get_option( $option, $default )<\/code> – Get option value<\/li>add_option( $option, $value, $deprecated, $autoload )<\/code> – Add option<\/li>update_option( $option, $value, $autoload )<\/code> – Update\/add option<\/li>delete_option( $option )<\/code> – Delete option<\/li>set_transient( $name, $value, $expiration )<\/code> – Set transient<\/li>get_transient( $name )<\/code> – Get transient<\/li>delete_transient( $name )<\/code> – Delete transient<\/li><\/ul>Performance Notes<\/h2>Autoload Optimization<\/h3>Large sites should audit autoloaded options:<\/p>sql<\/span><\/use><\/svg><\/button><\/div>SELECT SUM(LENGTH(option_value))\/1024 as kb FROM wp_options WHERE autoload='yes';<\/code><\/pre><\/div>Target: Keep autoload under 1MB total.<\/p>Transient Cleanup<\/h3>Transients without expiration never auto-delete. Periodically clean:<\/p>php<\/span>
add_option( $option, $value, $deprecated, $autoload )<\/code> – Add option<\/li>update_option( $option, $value, $autoload )<\/code> – Update\/add option<\/li>delete_option( $option )<\/code> – Delete option<\/li>set_transient( $name, $value, $expiration )<\/code> – Set transient<\/li>get_transient( $name )<\/code> – Get transient<\/li>delete_transient( $name )<\/code> – Delete transient<\/li><\/ul>Performance Notes<\/h2>Autoload Optimization<\/h3>Large sites should audit autoloaded options:<\/p>sql<\/span><\/use><\/svg><\/button><\/div>SELECT SUM(LENGTH(option_value))\/1024 as kb FROM wp_options WHERE autoload='yes';<\/code><\/pre><\/div>Target: Keep autoload under 1MB total.<\/p>Transient Cleanup<\/h3>Transients without expiration never auto-delete. Periodically clean:<\/p>php<\/span>
update_option( $option, $value, $autoload )<\/code> – Update\/add option<\/li>delete_option( $option )<\/code> – Delete option<\/li>set_transient( $name, $value, $expiration )<\/code> – Set transient<\/li>get_transient( $name )<\/code> – Get transient<\/li>delete_transient( $name )<\/code> – Delete transient<\/li><\/ul>Performance Notes<\/h2>Autoload Optimization<\/h3>Large sites should audit autoloaded options:<\/p>sql<\/span><\/use><\/svg><\/button><\/div>SELECT SUM(LENGTH(option_value))\/1024 as kb FROM wp_options WHERE autoload='yes';<\/code><\/pre><\/div>Target: Keep autoload under 1MB total.<\/p>Transient Cleanup<\/h3>Transients without expiration never auto-delete. Periodically clean:<\/p>php<\/span>
delete_option( $option )<\/code> – Delete option<\/li>set_transient( $name, $value, $expiration )<\/code> – Set transient<\/li>get_transient( $name )<\/code> – Get transient<\/li>delete_transient( $name )<\/code> – Delete transient<\/li><\/ul>Performance Notes<\/h2>Autoload Optimization<\/h3>Large sites should audit autoloaded options:<\/p>sql<\/span><\/use><\/svg><\/button><\/div>SELECT SUM(LENGTH(option_value))\/1024 as kb FROM wp_options WHERE autoload='yes';<\/code><\/pre><\/div>Target: Keep autoload under 1MB total.<\/p>Transient Cleanup<\/h3>Transients without expiration never auto-delete. Periodically clean:<\/p>php<\/span>
set_transient( $name, $value, $expiration )<\/code> – Set transient<\/li>get_transient( $name )<\/code> – Get transient<\/li>delete_transient( $name )<\/code> – Delete transient<\/li><\/ul>Performance Notes<\/h2>Autoload Optimization<\/h3>Large sites should audit autoloaded options:<\/p>sql<\/span><\/use><\/svg><\/button><\/div>SELECT SUM(LENGTH(option_value))\/1024 as kb FROM wp_options WHERE autoload='yes';<\/code><\/pre><\/div>Target: Keep autoload under 1MB total.<\/p>Transient Cleanup<\/h3>Transients without expiration never auto-delete. Periodically clean:<\/p>php<\/span>
get_transient( $name )<\/code> – Get transient<\/li>delete_transient( $name )<\/code> – Delete transient<\/li><\/ul>Performance Notes<\/h2>Autoload Optimization<\/h3>Large sites should audit autoloaded options:<\/p>sql<\/span><\/use><\/svg><\/button><\/div>SELECT SUM(LENGTH(option_value))\/1024 as kb FROM wp_options WHERE autoload='yes';<\/code><\/pre><\/div>Target: Keep autoload under 1MB total.<\/p>Transient Cleanup<\/h3>Transients without expiration never auto-delete. Periodically clean:<\/p>php<\/span>
delete_transient( $name )<\/code> – Delete transient<\/li><\/ul>Performance Notes<\/h2>Autoload Optimization<\/h3>Large sites should audit autoloaded options:<\/p>sql<\/span><\/use><\/svg><\/button><\/div>SELECT SUM(LENGTH(option_value))\/1024 as kb FROM wp_options WHERE autoload='yes';<\/code><\/pre><\/div>Target: Keep autoload under 1MB total.<\/p>Transient Cleanup<\/h3>Transients without expiration never auto-delete. Periodically clean:<\/p>php<\/span>
Large sites should audit autoloaded options:<\/p>
SELECT SUM(LENGTH(option_value))\/1024 as kb FROM wp_options WHERE autoload='yes';<\/code><\/pre><\/div>Target: Keep autoload under 1MB total.<\/p>Transient Cleanup<\/h3>Transients without expiration never auto-delete. Periodically clean:<\/p>php<\/span>
Target: Keep autoload under 1MB total.<\/p>
Transients without expiration never auto-delete. Periodically clean:<\/p>