The 8MB is due to the way that space is pre-allocated. SHOW VARIABLES LIKE 'innodb_file_per_table' - to verify Try this on one of the databases: SET GLOBAL innodb_file_per_table = OFF It may take less space to put small tables in ibdata1 by having innodb_file_per_table = OFF. I ran sudo mysqlcheck -o -all-databases -u root to optimize the tables, but it only reduced the size to 11 GB: du -sm * | sort -nrĪll my large DBs contain several hundred tables that are small in size (less than 2 MB according to phpmyadmin), but they take up a lot more actual disk space (about 8 MB). I checked the disk space usage of the newly created DBs in /var/lib/mysql and their combined size is about 14 GB.
I have a mysqldump containing all of my DBs that takes up about 1.3 GB disk space.Īfter I imported the backup with sudo mysql -u root < myfile.sql, I noticed that there's significantly less space left on my drive. I confirmed that InnoDB file-per-table is On. I'm on Ubuntu Server 18.04 running MySQL server 5.7.27 with InnoDB.
0 kommentar(er)
