CiviCRM Community Forums (archive)

While trying to figure out how much disk space CiviCRM is using (we're looking at upgrading a server), it took me a bit to figure out where most of the data was going.

Short answer: almost all of it is in the file /var/lib/mysql/ibdata1, which turns out to be the InnoDB "tablespace" file by default.

I'm curious if anyone is experimenting with the setting innodb_file_per_table, which if set puts each table in its own table space (this is more like the way that MyISAM does things).  There are some things I've read that going larger than 500GB on a single tablespace file is maybe not such a good idea; since the application I'm working on is already larger than that, I'm curious if anyone else has an opinion on this.