How much data is stored in a mysql table is bitsCN.com with the highest performance
Mysql has the highest performance when storing data in a table.
I have never known how many rows of data are stored in the InnoDB table before.
So I asked some people, and I was not final. 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: unofficial formulas
2. based on the above theory, we can calculate the maximum number of theoretical rows in a bigint primary key table.
Formula 1: (16 KB-200)/8 = 2023 rows
Formula 2: Of course, this 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 the row should be 2023*2023 = 4092529 rows or 1848*1848 = 3415104 rows
Because I have not tested it myself, I only have 5 million rows and one table. I have never studied it in depth because I have heard that million rows is an experience. When the author has time to do so, please test it ~
BitsCN.com