Size of a Mysql table with 200 million records

Question

Size of a Mysql table with 200 million records

Navigation

#1 by (3 votes)

0

I'm developing a system for a client, and I came across the following situation: it passed me a database, with phone numbers. And I have to create a routine, to generate new numbers for future queries.

The table will get about 200 million of records, with 3 fields ID - NÚMERO E CÓDIGO - my fear is if the table in MYSQL will support without problems.

The system will run for 4 days to generate all the data, I started this afternoon with 15 million records and almost 600 megs . p>

The table will not have multiple concurrent accesses, it will only be to generate a data report with the same code!

mysql

asked by anonymous 15.12.2016 / 00:59

1 answer

jQuery: Remove table row How do I not display the list of directories?

score 3 · Accepted Answer

According to this response of the English OS:

The physical size of the DB does not matter. The number of lines does not matter.

In my experience, the biggest problem you will have is not the size but the number of queries you can bear at any given time.

My BD has more than 10GB and with a moderate number of connections, there is no problem with the requirements.

This other response from the English OS, the user says they had tables with 200-300 million records, with size over 1TB without problems. It's a question of how to execute.

In short, no, no problem . But I strongly advise you to give a good handle on the documentation, on those answers, working with indices, sometimes talking to an experienced DBA.