jayR Posted July 18, 2006 Share Posted July 18, 2006 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? Quote Link to comment Share on other sites More sharing options...
cmgmyr Posted July 18, 2006 Share Posted July 18, 2006 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 Quote Link to comment Share on other sites More sharing options...
jayR Posted July 18, 2006 Author Share Posted July 18, 2006 Mostly information on people, ip addresses, phone numbers, descriptions, department info. All text or ints Quote Link to comment Share on other sites More sharing options...
cmgmyr Posted July 18, 2006 Share Posted July 18, 2006 I think that you should be fine with 1 gig Quote Link to comment Share on other sites More sharing options...
fenway Posted July 18, 2006 Share Posted July 18, 2006 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.