Hello @oomskaap,
I hope you’re doing well and that your site is up-and-running once more.
I’m also sorry to hear you’ve experienced issues with the plugin. And I completely understand your concerns.
This very topic (about the transients) was covered a few days ago in the support forums: found here.
Summarized, there I explained that the use of transients won’t cause issues; in normal cases.
In normal cases, it should also vastly improve the performance.
The website’s database you’ve shown isn’t normal, it’s huge! It has millions of options. I can only guess there are also thousands upon thousands of posts. I never encountered such a website; so I haven’t been able to test against it yet.
In order to prevent the transients from being created in the future, please refer to this code snippet:
define( 'THE_SEO_FRAMEWORK_DISABLE_TRANSIENTS', true );
In the next update, I’ll be sure to add an option that (sort of) acts like the constant definition above.
So, I’ve also opened a GitHub issue on this topic; I want to prevent your issue from ever happening again by adding a new option. See GitHub issue #46.
Nevertheless, I do believe your database is set-up sub-par; as it should actually be able to easily handle this situation. I think the MySQLi caching is set up too aggressive; or too subtle.
The massive and sudden increase also means that your website is popular, my congratulations on that one 🙂
I hope you understand the cause and resolution of this issue, and I wish that in the future you’d like to take a look once more into this plugin; and then of course I hope you’ll love it 🙂
Have a wonderful day and best of luck!
