Jump to content

how many records can MYSQL 4.1.14 NT via TCP/IP can hold?


neo777ph

Recommended Posts

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.

 

 

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?

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.

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.