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
Answer Checked By – Pedro (BugsFixing Volunteer)