How many records in one table can myslq support?

Question

MySQL

subject

Answer 1

I believe that the author of the question should not ask the question "How many records in one table can myslq hold?", Because it is initially incorrect.
The case (when the question is of purely academic interest) will not be considered.
Other questions should be asked:
- Do I really need MySQL to solve my problem?
- what will I run into with a large number of records - the restriction on writing or reading?
- at what amount of memory in the MySQL server will not be able to efficiently access the data?
— what is sharding, partitioning and replication?
— how can I backup databases?
What happens if my base falls?
etc. in the same direction.

Answer 2

1.844E+19 in a table like myisam.
Innodb is harder to find, but there is a 64TB limit per file, and therefore per table.
Only this knowledge will not bring you any practical benefit.

Answer 3

Under a hundred million keeps calm, but of course the table is brutally optimized for specific fairly simple queries. InnoDB.
Switching to another DBMS, most likely, is not worth it. It is worth measuring how deplorable the situation is now and whether it can be changed. Analyze what queries go to the table, how fast they work, what basic operations are going on (insert-read), whether there are funny effects because of this (for example, locks on MyISAM and InnoDB are very different), whether all indexes are worth it, no whether there are extra indexes, whether it is possible to reduce them, etc. After that, you will make a decision. If now you have 1 million, you can score a test base for 5 million and see if the alignment has changed a lot.

Answer 4

I saw 2 billion. But it was created by mistake, it was certainly impossible to work with it :)

Answer 5

A million records is not much at all.
I have a couple of tables with 1-1.5 million records, innodb, I have no problems

Answer 6

do you need it? what goal are you pursuing?

Answer 7

I have a table with 50 million rows, but I'm struggling with it.
In general, a lot of large projects work on MySQL, I think they have an order of magnitude more, so there is no foreseeable limit, it all depends on the software and hardware configuration.