Edward Posted August 14, 2007 Share Posted August 14, 2007 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 More sharing options...
kyleldi Posted August 14, 2007 Share Posted August 14, 2007 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. Link to comment https://forums.phpfreaks.com/topic/64837-solved-how-much-can-a-database-hold/#findComment-323516 Share on other sites More sharing options...
Fadion Posted August 14, 2007 Share Posted August 14, 2007 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. Link to comment https://forums.phpfreaks.com/topic/64837-solved-how-much-can-a-database-hold/#findComment-323531 Share on other sites More sharing options...
NArc0t1c Posted August 14, 2007 Share Posted August 14, 2007 Well, Space is the limit. I think a GB can hold about a few million entries. Edit: GuiltyGear, Someone I know held about 12 GB of md5 hasses. Link to comment https://forums.phpfreaks.com/topic/64837-solved-how-much-can-a-database-hold/#findComment-323533 Share on other sites More sharing options...
$username Posted August 14, 2007 Share Posted August 14, 2007 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 Link to comment https://forums.phpfreaks.com/topic/64837-solved-how-much-can-a-database-hold/#findComment-323593 Share on other sites More sharing options...
Edward Posted August 14, 2007 Author Share Posted August 14, 2007 Thank you all for your help. I don't think the limit will affect what I'm doing. Link to comment https://forums.phpfreaks.com/topic/64837-solved-how-much-can-a-database-hold/#findComment-323884 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.