I had an issue with my wp_options table growing to over 1.3 gb and the only thing I could see as the issue was a 7500 entries like _transient_tribe_views_v2_cache_d764c091076c:1684723412.9262_0. Since I saw “tribe” in the entries, I sent a support request to The Events Calendar. John Beacham answered my support ticket and not only walked me through installing the Transients Manager plugin, but also provided me with a SQL query and offered to actually set up a permanent solution on my staging site.
The info in this post is used on the front page of WP Facilitate. WP Facilitate, founded by John Beacham, provides affordable, trusted, versatile and passionate WordPress help.