Hi,
I had this thing happen where I accidentally flooded my MariaDB, and it blew up the disk storage usage. It is over 10 days ago and the database has been purged reducing its size from about 50GB to 5GB, However, the storage usage hasn’t really decreased at all.
Now, I’m no Linux or database whiz, but I did some poking around and found that the event_data.ibd is still 50Gb, even though a ROUND(SUM(data_length+index_length)/(102410241024), 3) query tells me the database is only 5Gb.
Any ideas on why this .ibd file is still big and how I can shrink it down?
