MySQL could not be started. Disk space full

Keywords: MySQL - Virtual Machines - Technical issue - Other
Description:
I tried to open my wordpress website today but it wasn’t opening. Tried to see the mysql logs and turns out that mysql could not start due to no space. I confirmed this by the command df -h
Checked further that /opt/bitnami/mysql/data was taking alot of space (12 gb). The exact file was wp_options.idb
Can I delete this file?

Hello @imran,

There have been similar issues in the past and they were usually related to plugins misusing the wp_options table and wp_option.idb file. Please, try checking the following thread:

Regards,
Francisco de Paz

Hello @fdepaz, Thanks for replying. I checked them out. Can you please tell how can we find out the plugin which plugin is increasing the size of wp_options table?

Hello @imran,

You can find the debug process to find the problematic plugin in one of the linked threads in the previous one. Feel free to share the output of any commands if you have any doubt on how to proceed.

Regards,
Francisco de Paz