I’ve a web site the place the options_id subject within the wp_options desk has grown very, very massive. A month and a half after the set up, the auto_increment worth is now at over 10 million.
Whereas there are a variety of plugins put in (resembling ACF and W3 Whole Cache) they don’t appear to be the trigger. They’ve been put in on others websites along with the identical theme framework with none points.
I’ve a neighborhood dev atmosphere of the affected web site the place all of the plugins and theme updates are first examined. Its auto_increment worth is just about 15,000 which I’d count on given all of the theme development on that set up.
The location has additionally been very gradual to load, at about 3 seconds per web page if it wasn’t cached by W3 Whole Cache (with web page caching enabled the load occasions are nice). Given the gradual load occasions and the excessive auto_increment worth, there would appear to be some sort of connection between the 2.
The choices desk itself solely accommodates a few 1000 rows, which appears regular, so it is ready to clear up after itself.
The location is a part of a multisite community and every web site within the community has at the least an auto_increment worth of 1 million or extra.
Some other tables within the database have not been affected, every of them reveals a standard variety of rows given the variety of pages on every web site.
Anybody have any concepts?