[FIXED] Why wp-options table is 60GB but backup is 24Mb

Issue

After Deleting Transients. Cleaning autoload Options. Setting log_days in my.cnf to 1, an many more tricks... My wp-options says its size is 50GB... however when I backup the file is 24MB.

I'm clearly missing something that is causing me huge binlog files and space problems on the server.

It as bitnami Wordpress installation on a Lightsail server

Any clues will be appreciated

Thanks

Solution

Summary of the comment thread above:

A combination of using OPTIMIZE TABLE to defragment the InnoDB tables after deleting lots of data, and PURGE BINARY LOGS to prune the accumulated binary logs helped to reduce the storage usage.

Answered By - Bill Karwin