Jump to content

Archived

This topic is now archived and is closed to further replies.

jayR

Database Question

Recommended Posts

Hi, I'm currently setting up a database for my company's intranet page and I began wondering about how large the hard drive should be.  After looking around for a while I was unable to find the amount of space my database was taking up on the server's hard drive.  Is there a way to see how much space my current database is taking up?  And how much space do database's take up?  Is a gig enough space for a database that could have over 1,000,000 records, or should I plan on more? 

Share this post


Link to post
Share on other sites
If you have phpMyAdmin it gives you a breakdown of each table and how much space is taken up and a total on the bottom for everything combined.

The amount of space depends on what you are holding in the database. What kind of information are you holding? But I think 1 gig should be enough.

-Chris

Share this post


Link to post
Share on other sites
Mostly information on people, ip addresses, phone numbers, descriptions, department info.  All text or ints

Share this post


Link to post
Share on other sites
I think that you should be fine with 1 gig

Share this post


Link to post
Share on other sites
Assuming you have access to the box itself, you can simply check the total size of each table (data + index).  Of course, if you have variable width columns, you need to consider them as well.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.