Recovering disk space in MariaDB
I'm out of disk space again. With MySQL it used to be that I could manually delete rows from the photo table, then rebuild the database and recover the space. It was no fun at all but it worked.
Now that I've moved to mariadb, it seems like "innodb_file_per_table = on" doesn't do anything: all the space is used by a single storage.idb file. I tried deleting half the photos and rebuilding the entire database from a dump, but it didn't seem to help. Now that I no longer have tables in individual files, I can't even tell how much space each table is taking up.
Is there any way to manage this disk space? I'd like to find out which tables are taking up the space, and then after deleting unnecessary data from those, recover the disk space on my filesystem.
!Friendica Support
Now that I've moved to mariadb, it seems like "innodb_file_per_table = on" doesn't do anything: all the space is used by a single storage.idb file. I tried deleting half the photos and rebuilding the entire database from a dump, but it didn't seem to help. Now that I no longer have tables in individual files, I can't even tell how much space each table is taking up.
Is there any way to manage this disk space? I'd like to find out which tables are taking up the space, and then after deleting unnecessary data from those, recover the disk space on my filesystem.
!Friendica Support
Friendica Support reshared this.
Matthew Exon
in reply to Matthew Exon • •Friendica Support reshared this.
Matthew Exon
in reply to Matthew Exon • •Friendica Support reshared this.
Matthew Exon
Unknown parent • •Friendica Support reshared this.
Matthew Exon
Unknown parent • •Friendica Support reshared this.
Matthew Exon
Unknown parent • •Friendica Support reshared this.