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, which is the highest performance ??? 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 :???? Note

? ? ? I have never known how many rows of data are stored in the InnoDB table, which is the highest performance? ? ? 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 :? ? ? ? Note

? ? ? I have never known how many rows of data are stored in the InnoDB table before, which is the highest performance.

? ? ? 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 ~