My options table is huge. What can I do?

Check out this thread wp_options is GB in size
My wp_options table dropped from 670GB to 13.5MB after running the optimization commands they outlined

Related Posts:

  1. Will it break my site if I delete all transient records in wp_options table?
  2. Please explain how WordPress works with MySQL character set and collation at a low level
  3. What is the purpose of the option name hack_file in the options table?
  4. delete_option() and update_option() returning false
  5. How to change option recently_edited?
  6. store simple data in get_option()
  7. WP_Options ID high
  8. Transient RSS feeds in wp_options not removed automatically?
  9. Long option names fail silently?
  10. save new data to wp_options non-post form
  11. Huge wp_options table
  12. Cannot unserialize WordPress serialized values in `wp_options` table?
  13. WordPress DB: options-table –> 32 gzipcompression?
  14. wp_options table has duplicate rows and primary key / autoincrement has been removed
  15. Help running a MySQL query to update all wp_#_options tables in a Multisite install
  16. What ALL can cause “Another update is currently in progress.”? [closed]
  17. Should I remove transients from the wp_options table?
  18. I don’t see site_url and home_url fields in wp_options table (phpMyAdmin)?
  19. Accidentally deleted active_plugins portion of the wp_options DB table
  20. batch UPDATE autoload value in wp_options table
  21. Multiple wp_options tables to share content across installs
  22. Is there an atomic way to update_option in WordPress (to ensure data integrity)?
  23. Does auto_load to ‘no’ in wp_options improve performance
  24. Check if an option exists and get its value in one hit
  25. Change options table prefix only
  26. When to use custom DB tables or add_option?
  27. In which format the data is stored in WordPress Databases?
  28. Automate WordPress website setup with prefilled data
  29. Image link issues after importing a database backup to my local web server
  30. Native timestamp on wp_options option
  31. Whats the best practise on how to store json data from a custom settings page?
  32. WordPress Settings API Overrides My Previous Value
  33. What structure and database storage method should I use for temporary storage that may be written concurrently?
  34. get_option() does unserialize and don’t remove \
  35. I cannot change anything in my wordpress database from within wordpress?
  36. Wrong url for the images while using same database for two WordPress installations
  37. Options table – where does my values go?
  38. Theme options not being sent to Database
  39. Multiple Address In WP-Option Value
  40. How do I use update_option to give me a new option name each time a form is submitted? [duplicate]
  41. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  42. phpMyAdmin – Error > Incorrect format parameter?
  43. Why is my database import losing text widget data?
  44. Does dbDelta delete columns as well?
  45. Insert data in database using form
  46. Upload files – total size limit – WordPress/Contact Form 7
  47. Relationship between performance and database size
  48. Scheduling posts in database
  49. Size article thumbnails and retrieve them directly from database
  50. Should I be able to run two different “close” code versions of wordpress with the same DB
  51. Need of separate security plugins for both root and subfolder sites WordPress?
  52. Escaping / encoding data before insert into a database?
  53. how to store arrays into a database
  54. Error: SELECT SQL_CALC_FOUND_ROWS
  55. Where are WP_Errors Saved
  56. Error establishing database connection – high traffic?
  57. Populate dropdown from database
  58. wordpress ‘database update required’ loop after update
  59. Database Table for customer user
  60. How to Access wp_usermeta Data Immediately After a New User is Created
  61. Cleanup: best way to remove WooCommerce comments from the wp_comments table
  62. How to paginate information obtained from a query to a custom table?
  63. How can I show related posts from multiple separate installations
  64. Uknown meta entries in wp_postmeta
  65. Insert Query not working in the form
  66. Two prefixes in database? Which one is valid?
  67. Enter user registration information in the database
  68. Problem in using wpdb
  69. Create database on installation
  70. Importer fails to import every post
  71. Options on how to Display member specific data from a MS SQL database
  72. Unkown meta_value in ACF
  73. Buddypress avatar image in database [closed]
  74. wp_insert_user not creating account correctly when ID is manually set
  75. Installing local to live WP into subdirectory
  76. WordPress SQL – How to Check for Category?
  77. Getting WordPress to work inside a rails 3 application
  78. Advantages of dbDelta
  79. MSQL database wp_postmeta has meta key tve_revision
  80. Occasional Error Establishing a Database Connection
  81. Display user data in numbered list
  82. Removing old_slug and old_date from WordPress Database
  83. Help with $wpdb on custom code
  84. “BS_” rows in postmeta table
  85. How do I change several broken URLs in a several wordpress databases in the fastest way?
  86. Optimize WP site for millions of posts
  87. I Want a More Concice Form of Data than an Array
  88. Duplicate database to roll back theme & content changes
  89. WordPress Migration – Issue with admin panel changes
  90. mySQL database size large, but tables size less
  91. How To connect to the same WordPress database with different database user
  92. How much post meta data is too much?
  93. I have include wp-config, should I add global $wpdb also?
  94. Localize strings from db
  95. Can’t Install WordPress (local) Failed to open file wp-includes/wp-db.php
  96. version control for wordpress? (wordpress folder and database at same time)
  97. Redirect Issue: WordPress database
  98. Creating Job Tickets
  99. Best db table structure for users with many records
  100. How to stop WordPress from using utf8mb4_unicode_ci collation