What is the difference between mysql subtables and partitions?

Most people do not understand the knowledge points of this article "what is the difference between mysql sub-table and partition", so the editor summarizes the following contents, detailed contents, clear steps, and has a certain reference value. I hope you can get something after reading this article. Let's take a look at this "what is the difference between mysql sub-table and partition" article.

1. Partitioning is just a change in the storage location of data and indexes in a table. A sub-table divides a table into multiple tables, which is a real supporting file for multiple sets of tables.

Partitions cannot break through the database level. No matter how you partition, these partitions should be under a database. Sub-tables can be assigned in the same library or in different libraries, breaking through the limitations of database performance.

2. Partition can only replace the function of horizontal table, not the function of vertical table.

Example

[root@BlackGhost test] # ls | the above is the content of this article on "what is the difference between mysql sub-table and partition". I believe everyone has a certain understanding. I hope the content shared by the editor will be helpful to you. If you want to know more about it, please follow the industry information channel.