Hi @nico1, we have found similar issues in the past. For instance in this topic: https://community.bitnami.com/t/mysql-unable-to-start-due-to-full-space/70312/8
In summary, some plugins misbehave and bloat the
wp_options table with useless data.
I would recommend you to execute these MySQL commands to identify the problematic row (which will let us know which plugin is causing the issue):
OPTIMIZE TABLE wp_options;
FLUSH QUERY CACHE;
SELECT COUNT(*) FROM wp_options;
SELECT option_name, LENGTH(option_id) + LENGTH(option_name) + LENGTH(option_value) + LENGTH(autoload) AS total_length FROM wp_options ORDER BY total_length DESC LIMIT 10;
Please share the results of the commands with us. The 3rd row will show the amount of rows in wp_options, and the 4th the number of characters for the biggest rows. If a row has a very high amount of characters (i.e. >1M), it could be the problematic one.
If you search its option_name in Google and find it related to any of the plugin you have enabled, disable it (as it is misbehaving) and report the issue to the plugin author. Only then can you run the command below:
DELETE FROM wp_options WHERE option_id = ID;
But be very careful with that command not to remove the wrong option id.