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 (Moderator: Dave Greenberg) »
  • Database sizes and archiving
Pages: [1]

Author Topic: Database sizes and archiving  (Read 865 times)

Ian G.

  • I post occasionally
  • **
  • Posts: 54
  • Karma: 0
    • Atlantic Coast Theatre
  • CiviCRM version: 4.4+
  • CMS version: Joomla 3+
Database sizes and archiving
April 18, 2012, 08:50:58 am
Hi.

I have a complicated setup which requires lots of activities to be logged each day, with lots of detailed information added into custom fields. It's a site for a set of care homes and staff log reports for their interactions with clients.

My concern is that I'm seeing the database size balloon up from 0kb to 450mb in the time it's been running (around 5 months) and I'm wondering if there are any nasty issues for me in the future regarding the size of the database (Joomla/MySql).

I was hoping there might be some way of archiving off any information over a year old - does such a thing exist? I know you can archive old mailings, but this is specifically 'Activities'.

Cheers!!

Ian.

xavier

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4453
  • Karma: 161
    • Tech To The People
  • CiviCRM version: yes probably
  • CMS version: drupal
Re: Database sizes and archiving
April 18, 2012, 12:00:13 pm
Hi,

450Mb isn't a big db, quite a few install got several orders of magnitude bigger ones. If it goes too big, you might need as well to migrate to a dedicated server for the db, but don't think that's going to be an issue soon.

How many activities records do you have in the DB? one issue might be speed and optimising some queries. I know that eileen has had some interesting preliminary results and if you could fund some of her work, this would help improving your use case with a lot of activities.

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

Ian G.

  • I post occasionally
  • **
  • Posts: 54
  • Karma: 0
    • Atlantic Coast Theatre
  • CiviCRM version: 4.4+
  • CMS version: Joomla 3+
Re: Database sizes and archiving
April 25, 2012, 05:33:15 am
Turns out I shouldn't have been panicing. The size was actually down to a rapidly growing error log civi was generating. I deleted it and the backup file went from 450mb to 100mb.

Now need to try to find out what was generating errors!
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM (Moderator: Dave Greenberg) »
  • Database sizes and archiving

This forum was archived on 2017-11-26.