Question about Disk Space Usage on AWS Lightsail MySQL

Hello everyone!

I'm facing a question related to disk space usage on my AWS Lightsail server that hosts a MySQL database. The situation is as follows:

My AWS Lightsail server is on the 120 GB plan.

I executed the following SQL query on the database to check the total size of the tables:

sql SELECT ROUND(SUM(data_length + index_length) / 1024 / 1024 / 1024, 2) AS "Total Database Size (GB)" FROM information_schema.tables; The query returned a total of approximately 17 GB as the size of the database.

However, when checking the storage usage metrics on the AWS Lightsail dashboard, it's only showing 1 GB in use.

I'm confused about this discrepancy and don't know what could be consuming the additional disk space. I checked the binary logs (binlogs) using SHOW BINARY LOGS, but I don't have SUPER privileges to execute that command.

Has anyone encountered a similar situation or knows what might be causing this difference in disk space usage? I'd like to understand it better and, if possible, find a solution to free up disk space.

I appreciate any help or suggestions you can provide!