How many records in one table can withstand myslq?

0 like 0 dislike
5 views
subject
by | 5 views

7 Answers

0 like 0 dislike
I believe that the author of the question is not worth asking the question, "How many records in one table can withstand myslq?", because it was originally wrong.
\r
Case (when the question is of purely academic interest) will not be considered.
\r
You should ask other questions:
— I just need MySQL to solve my problem?
— what I will be rested with a large number of records in the constraint record or on reading?
— what amount of memory the MySQL server will not be able to effectively dostupatsya the data?
— what is sharding, States for dividing and replication?
— how do I backup a database?
— what happens if my base will fall?
etc. in the same direction.
by
0 like 0 dislike
1.844 E+19 in a table of type myisam.
Have innodb harder to find, but there is a limit to 64Тб on the file, and therefore on the table.
\r
Only this knowledge you no practical benefit will not bring.
by
0 like 0 dislike
A hundred million keeps quiet, but of course the table is severely optimized for the particular quite simple query. InnoDB.
\r
To switch to another DBMS, probably not worth it. It is worth to measure how dire the situation is now and whether to change it. Analyze what queries are coming to the table, how fast they work, what are the main operations are (insert-read), there is this funny effects (for example, locks on MyISAM and InnoDB are very different) if all the indexes are, are there any extra indexes, is it possible to reduce them, etc. then be able to make a decision. Now if You have 1 million, you can score a test database of 5 million and see if much has changed alignment.
by
0 like 0 dislike
Saw 2 billion But it was mistakenly created, working with her was of course impossible :)
by
0 like 0 dislike
a million records is not much.
I have a couple of tables 1-1.5 million records, innodb, do not experience problems
by
0 like 0 dislike
do you need it? what is the purpose?
by
0 like 0 dislike
I have a table with 50 million rows, however, Oh I suffer with her.
\r
In General, many large projects running on MySQL, I think they have to order more so that there is no foreseeable limit, it all depends on configuration and hardware.
by

Related questions

0 like 0 dislike
1 answer
0 like 0 dislike
1 answer
0 like 0 dislike
1 answer
asked May 20, 2019 by Veneomin
0 like 0 dislike
1 answer
0 like 0 dislike
1 answer
asked Apr 14, 2019 by vovella
110,608 questions
257,186 answers
0 comments
28,647 users