Jump to content

[SOLVED] How much can a database hold?


Edward

Recommended Posts

 

Hi,

 

I'm making a website that has a form on it. People fill in the form by entering their personal details (name, address etc) and by answering some questions. When people submit their information, a new row is created in a mysql database stored on the website web space to store their information. I would like to know if there is a limit to how many people can register, or how much information the table can hold. For example, if thousands of people join, will it always keep adding rows to accommodate this?

 

Thank you.

Link to comment
https://forums.phpfreaks.com/topic/64837-solved-how-much-can-a-database-hold/
Share on other sites

The exact limits in which a database could hold more depends on the machine being capable of executing/processing the file.  If you have a good server you should be fine... Thousands isn't going to be an issue by any means, I don't believe.  Large systems (such as this forum) run via sql and with little /no problems whatsoever.

From an article i read, mysql's limit is coming from the 32 bit pointers that store row locations. That means 4GB space limit, if thats what ure worried about. Isnt that enought? U can easily boost its capabilities to 4.2 billion rows. Read the whole <a href="http://jeremy.zawodny.com/blog/archives/000796.html">article</a> to understand it right.

If you are using version 5.1 here is what they have listed.

 

http://dev.mysql.com/doc/refman/5.1/en/full-table.html

 

 

 

Operating System File-size Limit

Win32 w/ FAT/FAT32 2GB/4GB

Win32 w/ NTFS 2TB (possibly larger)

Linux 2.2-Intel 32-bit 2GB (LFS: 4GB)

Linux 2.4+ (using ext3 filesystem) 4TB

Solaris 9/10 16TB

MacOS X w/ HFS+ 2TB

NetWare w/NSS filesystem 8TB

 

 

 

Brett

 

 

Archived

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

×
×
  • Create New...

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.