CiviCRM Community Forums (archive)

I have set up a Drupal\CiviCRM application (MySQL DB) that has the potential of having many many records.
I’ve tested importing about 500,000 contact records i have from another DB and the test database is now roughly 500MB.
I’m going to test adding all those contacts email addresses as user names very soon.
I know it doesn’t work exactly like this in database land, but for a liberal projection sake I estimate that will increase the DB to near 1GB.
This DB is on a 20GB dedicated fibrechannel disk system. All temp table operations have separate 15GB partition they process on.
I have a couple of people concerned about there being “only 20GB” for the database.
I’ve tried to explain that’s plenty plus we can dynamically expand it if needed later.

All that to ask: Can anyone out there tell me what is considered a HUGE CiviCRM install?
Does anyone out there have a DB with 1 million contact records... TEN million contact records?
What are your db sizes? What are some things to cnsider when capacity planning for a db?

Thanks for the info. That gives me a good start.