neo777ph Posted March 3, 2007 Share Posted March 3, 2007 Hi my questions: how many records can MYSQL 4.1.14 NT via TCP/IP can hold? how many records per table can MYSQL 4.1.14 NT via TCP/IP can hold? how many records in a table can MYSQL 4.1.14 NT via TCP/IP can hold given the table has a field Primary key - BIGINT(20) autoincrement? need your opinion..Here are the facts: MY system is an internal one. My Server--Is only a Desktop.. Celeron 2.8 Gigahertz, 40Gig Baracuda HD, 512 MB memory.. And it serves an average of 20 users a day and it also serves me for my system development..The average records inserted per month on mYSQL is 10,000 records..We foresee that system would be used for about 10 years. given this scenario..could you please give me proposals/improvements that i should make? that would make my NONE-IT collegeaus that i need such upgrade and an EXTRA PC =>.. Our company is quiet in a tight budget.. hope you could help me on this. Quote Link to comment https://forums.phpfreaks.com/topic/40950-how-many-records-can-mysql-4114-nt-via-tcpip-can-hold/ Share on other sites More sharing options...
artacus Posted March 3, 2007 Share Posted March 3, 2007 Your post doesn't make much sense. But you will run out of keys after 9,223,372,036,854,775,807 rows. Good luck filling that up. Quote Link to comment https://forums.phpfreaks.com/topic/40950-how-many-records-can-mysql-4114-nt-via-tcpip-can-hold/#findComment-198330 Share on other sites More sharing options...
neo777ph Posted March 3, 2007 Author Share Posted March 3, 2007 MY system is an internal one. My Server--Is only a Desktop.. Celeron 2.8 Gigahertz, 40Gig Baracuda HD, 512 MB memory.. And it serves an average of 20 users a day and it also serves me for my system development..The average records inserted per month on mYSQL is 10,000 records..We foresee that system would be used for about 10 years. --thnx to your reply sir.. however can you please provide me your opinion on my hardware setup..Would my hardware withstand the test of time? Quote Link to comment https://forums.phpfreaks.com/topic/40950-how-many-records-can-mysql-4114-nt-via-tcpip-can-hold/#findComment-198335 Share on other sites More sharing options...
artacus Posted March 3, 2007 Share Posted March 3, 2007 Well, you can do 10,000 inserts per second for the next 2.9 million years and you'll still have a few pk's left. 10,000 inserts per month for a total of 1.2 million records is something your system can easily handle. You'll want to have good indexes set up for searching and joining for this many records. I have no idea how big your table is, if you've got text or blob fields you could run out of disk space. Quote Link to comment https://forums.phpfreaks.com/topic/40950-how-many-records-can-mysql-4114-nt-via-tcpip-can-hold/#findComment-198341 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.