Myspl database partition

Vertical partitions and horizontal partitions in database extensions are not a concept of MySQL partitions.
Vertical and horizontal partitions distribute data that is supposed to be stored in the same database to databases on multiple hosts through certain conditions, which has distributed the load of a single device. Vertical and horizontal partitions are a means of database architecture, not just MySQL.
MySQL partition: the data in the database is stored on the disk as a file. For example, MYISAM is used. One table corresponds to three files, and the other is the frm table structure, MYD Stores Table data and MYI Stores Table indexes. If the data volume of a table is too large, MYD and MYI will become very large, and the data query will become very slow. At this time, we can use the MySQL partition function, physically, the three files corresponding to this table are divided into many small pieces. In this way, when we look for a piece of data, we don't need to look for it all. As long as we know where the piece of data is, then you can find it in that area. If the data in the table is too large, it may not be stored on a disk. In this case, we can allocate data to different disks.
 
This article is from the "Zhou Tianqi" blog