How to optimize wp_option table?

If you Google for “wp_options optimize” you’ll find some suggestions how to search for performance problems in wp_options.

It makes sense to check which option values are very big, using the following query. Then check if you really need the plugin that wrote this setting (or remove the setting(s), if the plugin already is installed). In some cases you can also fix that by changing a plugin’s (or theme’s) configuration:

SELECT *, LENGTH(option_value) option_size 
FROM wp_options 
ORDER BY option_size DESC;

It might be necessary to do a mysqloptimize on the table after removing the values.

Related Posts:

  1. WordPress (MyISAM) database is slow, should I switch to InnoDB?
  2. How to solve slow WordPress site caused by attachment_metadata
  3. Should I remove transients from the wp_options table?
  4. batch UPDATE autoload value in wp_options table
  5. Improve performance by removing unnecessary database queries
  6. Cleanup: best way to remove WooCommerce comments from the wp_comments table
  7. What would Repair and Optimize WordPress Database do?
  8. fastest replacement DB
  9. Optimizing function that automatically creates internal links based on post title string
  10. Will memcached improve performance with WP Super Cache already running?
  11. How to optimise this database query?
  12. Best way to search and replace within serialized database strings?
  13. Exclude Statement in SQL
  14. Is it fine to have foreign key as primary key?
  15. Custom form that store input in database
  16. Restoring WordPress posts from database only
  17. Can a post ID be 0?
  18. Issue with wp_insert_post and post_content field error Could not update post in the database
  19. wp_posts – guid update
  20. Performance Gains of Relational DB Setup
  21. what is the wp_5_posts table in the database?
  22. Migrating data between local and development server
  23. WordPress Database Charset/Collate
  24. store simple data in get_option()
  25. What is the database table for pages?
  26. Using Dynamic Data Pulled from a MySQL Table in a WordPress Page
  27. Migrating non-WordPress CMS to WordPress, lots of data to move — possible solutions?
  28. storing database in version control
  29. Is deleting orphaned wp_options entries safe?
  30. How to build a movie database with wordpress?
  31. Sub-domain or 2nd, temporary different domain?
  32. Hook to be used when creating a database table
  33. Delete all post meta except featured image
  34. Where is custom template file chosen for a post stored in the DB?
  35. How do i get user data from a custom table in the wordpress database by user ID?
  36. Converting WordPress into Android or iPhone app
  37. Safe way to find last inserted id in a table?
  38. Delete duplicate rows from wordpress database where a column is duplicate in phpmyadmin
  39. WooCommerce sku location in DB
  40. WordPress DATABASE Update Manually?
  41. I don’t see site_url and home_url fields in wp_options table (phpMyAdmin)?
  42. Multiple postmeta with same name for one post in wp_postmeta table
  43. Which is more efficient? Using usermeta, or creating a new MySQL table?
  44. Can I have multiple database users within WordPress?
  45. A field with dashes in the slug [closed]
  46. Structure of postmeta meta_value for woocommerce product download
  47. $wpdb doesn’t like to store arrays
  48. Handling large N data in WordPress
  49. How to replicate a user plugin made table value, to this user’s custom meta table value?
  50. WordPress ‘repairing database’ in a constant error loop?
  51. Is there a way to recover the table wp_term_relationships?
  52. Trouble Migrating all data blog from WordPress.com to WordPress.org
  53. Historic WordPress database connection
  54. Check if an option exists and get its value in one hit
  55. $wpdb error (Call to a member function insert() on a non-object)
  56. Problems with moving my WordPress site to another domain/server
  57. Is it important to have integers inserted using %d rather than %s?
  58. How To Run A Temporary Instance Of a WordPress Backup Without a Database?
  59. Share users across multiple sites on same database, but with different domains
  60. Global__r connection timed out
  61. Connect to database in the header of my WordPress website
  62. WordPress url transformation script
  63. Moving WordPress site to new domain – database import [duplicate]
  64. Location of WP default mySQL tables creation file?
  65. Directly editing WP database issues
  66. Installation question
  67. Disable Database Update Required ? break my website
  68. Select From wpdb – Author/User Directory page
  69. How can I query the db to access current post information?
  70. Just created a WordPress Table can’t get $wpdb get row to work – need help
  71. $wpdb->insert not inserting all rows
  72. Best Practice? – Saving multiple Values as Serialized Data / Saving each Value per Row / Dedicated Table
  73. Insert NULL value using prepare()
  74. How to re-connect WP files in lampp/htdocs to new SQL database to recover site under development
  75. How can I find user role in Mysql?
  76. How would I see which wordpress posts have a revision history without opening each one?
  77. $wpdb->insert duplicating rows
  78. Troubles when I want to connect to another DB
  79. Intermittent Yet Problematic Error – “Error Establishing A Database Connection”
  80. Free version of Relevanssi doesn’t show ACF fields
  81. Communication in between WordPress database and another (not WordPress) database
  82. Is it possible to separate databases in WordPress site – one for orders and the other for all non-orders related
  83. Featured image from custom to WordPress database
  84. WordPress Database Query works in phpMyAdmin but not in the code
  85. How to edit posts/pages without making the change live?
  86. Correct and secure way to access a custom SQL database in a custom PHP template file
  87. How to retrieve user data based on role using SQL?
  88. Does WordPress Support Using Named Pipes on the Windows Operating System?
  89. Missing latest posts and options after DB migration via phpMyAdmin
  90. Store id from database query in cookie
  91. Split database on large site?
  92. Store the wordpress “featured image” under »wp_posts« Database table
  93. Custom metabox does not store data
  94. What WordPress file is saving new users to database
  95. wordpress database error
  96. How do i get value from wp_postmeta?
  97. Local host to server import problem
  98. featured image not showing up with mysql_connect
  99. Options of accessing wordpress data from mobile app
  100. WP Multisite Users Not Linking