How much data is stored in a mysql table is the highest performance. I have never known how many rows of data are stored in the InnoDB table. www.2cto.com asked some people, but they were still inconclusive. the DBA of one of the largest e-commerce companies in China gave me a rough answer and I felt reliable. So I will share it with you here. 1. A Chinese ox wrote the following paragraph:
Note: The unofficial formula 2 is provided. based on the above theory, we can calculate the maximum theoretical number of rows in a bigint primary key table. Formula 1: (16 KB-200)/8 = Row 2: of course, it can also be calculated as follows: (16 KB)/8-200 = 1848 rows because the highest index tree of mysql is three layers (the table is the first layer ), the maximum number of rows in that row should be 2023*2023 = 4092529 rows or 1848*1848 = 3415104 rows, because I have not tested it myself, it is only 5 million rows and one table, people in the circle say that million is an experience, so I have not studied it in depth. When the author has time to do so, please test it ~