My DB (mysql) ballooned up to 1.3GB (I'm on the 512MB free plan). So I backed up what I wanted to back up locally on my PC, deleted the rows and ran OPTIMIZE TABLE, which from what I read should act like VACUUM. Unfortunately when I then ran:
SELECT
table_schema as `Database`,
table_name AS `Table`,
round(((data_length + index_length) / 1024 / 1024), 2) `Size in MB`
FROM information_schema.TABLES
WHERE information_schema.TABLES.table_schema = "myDB$default"
ORDER BY (data_length + index_length) DESC;
It still shows one of the tables is over 1GB.
What loops do I have to jump through to actually reduce the DB size?
EDIT: I actually copied the data from one table to another. Dropped the old table, and renamed the new table to the original name. Now the size is ok. This cannot be the way to do it. It seems way too janky...
