CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site

This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Post-installation Setup and Configuration (Moderator: Dave Greenberg) »
  • Big Databases and innodb_file_per_table
Pages: [1]

Author Topic: Big Databases and innodb_file_per_table  (Read 1088 times)

torenware

  • I post frequently
  • ***
  • Posts: 153
  • Karma: 4
Big Databases and innodb_file_per_table
May 15, 2008, 07:24:56 pm
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.

xavier

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4453
  • Karma: 161
    • Tech To The People
  • CiviCRM version: yes probably
  • CMS version: drupal
Re: Big Databases and innodb_file_per_table
May 15, 2008, 09:56:16 pm
Out of curiosity, how many contacts do you have to reach 500G ?

I tend to have separated files, mostly without any good reason ;)

X+
-Hackathon and data journalism about the European parliament 24-26 jan. Watch out the result

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Post-installation Setup and Configuration (Moderator: Dave Greenberg) »
  • Big Databases and innodb_file_per_table

This forum was archived on 2017-11-26.