LinuxQuestions.org
Visit Jeremy's Blog.
Home Forums Tutorials Articles Register
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 03-21-2007, 02:49 PM   #1
Micro420
Senior Member
 
Registered: Aug 2003
Location: Berkeley, CA
Distribution: Mac OS X Leopard 10.6.2, Windows 2003 Server/Vista/7/XP/2000/NT/98, Ubuntux64, CentOS4.8/5.4
Posts: 2,986

Rep: Reputation: 45
MySQL - can it handle a database with 300,000,000 entries?


I don't really work with databases, but would MySQL be able to handle a database with 300,000,000+ entries in it (entire U.S. Population)? And, how much space do you think that would take up?
 
Old 03-21-2007, 03:54 PM   #2
jantman
Member
 
Registered: Nov 2005
Location: New Jersey, USA
Distribution: SuSE
Posts: 492

Rep: Reputation: 31
How much data per entry? If optimized, it *should* be able to handle it, but you'll need to have quite a bit of disk space, and a nice fast server with LOTS of RAM to make it do anything...

What is the purpose of this?
 
Old 03-21-2007, 06:13 PM   #3
Micro420
Senior Member
 
Registered: Aug 2003
Location: Berkeley, CA
Distribution: Mac OS X Leopard 10.6.2, Windows 2003 Server/Vista/7/XP/2000/NT/98, Ubuntux64, CentOS4.8/5.4
Posts: 2,986

Original Poster
Rep: Reputation: 45
Jantman: My work is going to collect some data on a sample size of the US population, do some analysis and modeling, and then spit it back out. I am guessing that each data in an entry will contain things like gender, height, weight, health, ethnicity, locale, age, income, etc...

I am not sure of the details of this project, but I was just informed this morning that I need to look into a database that can handle the US Population, and much more. It won't be accessed heavily, only by a few researchers and students. So you think a Pentium 4 with 2GB of RAM and a 500GB hard drive will be enough?

I have already started to read up on my MySQL reference books.

Last edited by Micro420; 03-21-2007 at 06:16 PM.
 
Old 03-21-2007, 07:55 PM   #4
jantman
Member
 
Registered: Nov 2005
Location: New Jersey, USA
Distribution: SuSE
Posts: 492

Rep: Reputation: 31
Sounds like a pretty good machine. At least worth a try. You could always write a script to fill the DB with pseudo-random data and give it a whirl...
 
Old 03-22-2007, 12:22 AM   #5
sanjaykatiyar1
LQ Newbie
 
Registered: Mar 2007
Location: India
Distribution: Redhat, Fedora
Posts: 4

Rep: Reputation: 0
As mysql claims this amount of data server can handle easly so I see no problem at all.
 
  


Reply



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
LXer: SugarCRM Announces 1,000 Customers and 1,000,000 Open Source Downloads as Momentum for Open Source Applications Grows LXer Syndicated Linux News 0 12-19-2006 05:33 AM
LinuxQuestions.org Hits 2,000,000 Posts jeremy Linux - News 16 06-19-2006 07:57 AM
1,000,000,000 PCs by 2010 masand Linux - News 4 11-01-2004 01:55 AM
LinuxQuestions.org Surpasses 1,000,000 Posts jeremy LQ Suggestions & Feedback 15 07-21-2004 12:52 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 05:49 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration