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. What is an ORM, how does it work, and how should I use one? [closed]
  42. What is the difference between an ORM and an ODM?
  43. What is this JavaScript “require”?
  44. Rename a table in MySQL
  45. How should I tackle –secure-file-priv in MySQL?
  46. What is this JavaScript “require”?
  47. What is “Advanced” SQL?
  48. What’s the difference between identifying and non-identifying relationships?
  49. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  50. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  51. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  52. What are the differences between B trees and B+ trees?
  53. MySQL SELECT increment counter
  54. How to resolve ORA-011033: ORACLE initialization or shutdown in progress
  55. Example of a strong and weak entity types
  56. Oracle SQL query for Date format
  57. phpMyAdmin – Error > Incorrect format parameter?
  58. Strange Characters in database text: Ã, Ã, ¢, â‚ €,
  59. Difference between partition key, composite key and clustering key in Cassandra?
  60. How SID is different from Service name in Oracle tnsnames.ora
  61. What is a relation in database terminology?
  62. Failed to connect to mysql at 127.0.0.1:3306 with user root access denied for user ‘root’@’localhost'(using password:YES)
  63. Database vs File system storage
  64. Can I have multiple primary keys in a single table?
  65. Exclude Statement in SQL
  66. How do you query for “is not null” in Mongo?
  67. What is a file based database?
  68. Is it fine to have foreign key as primary key?
  69. Storing Images in DB – Yea or Nay?
  70. Using wpdb to connect to a separate database
  71. how to Optimize WordPress database for 10 million post? [duplicate]
  72. MySQL Database User: Which Privileges are needed?
  73. Why is my database import losing text widget data?
  74. Database synchronization between dev/staging and production
  75. Keeping WP database synced across multiple developers using git
  76. WPDB Insert or if exists Update
  77. Multiple developers / editors working on a site in progress
  78. How can I make updates to a site, on a development copy, but then move updates back without overriding live site’s evolving database?
  79. get_results using wpdb
  80. Checking if Database Table exists
  81. Why WordPress choose data serialization over json_encode?
  82. Update Option Stored in Multi-Dimensional Array
  83. What’s the simplest way to backup my WordPress database?
  84. WordPress (MyISAM) database is slow, should I switch to InnoDB?
  85. $wpdb won’t insert NULL into table column
  86. Relaunch 4.2 utf8mb4 database upgrade
  87. Fastest way (least amount of steps) to locally import a remote database using WP-CLI
  88. Safest way to bulk delete post revisions
  89. Solution for database version control and deployment?
  90. The MySQL alternatives: Do Percona Server and MariaDB work well with WordPress, and do they make WordPress go better?
  91. How many users can WordPress handle?
  92. Get error messages when $wpdb->insert() returns false?
  93. Detecting errors generated by $wpdb->get_results()
  94. Staging sites, how do you manage synchronising updates in the DB?
  95. Does dbDelta delete columns as well?
  96. How to get the post publish date outside the loop?
  97. MariaDB as a backend database
  98. wpdb update add current timestamp not working
  99. Site stuck in “Database Update Required” loop
  100. How to fetch Data in WordPress using MySQLi or $wpdb
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)