Shulou(Shulou.com)06/03 Report--

This article mainly shows you the "mysql sub-table and what are the differences between partitions", the content is easy to understand, clear, hope to help you solve your doubts, the following let the editor lead you to study and learn "what are the differences between mysql sub-tables and partitions" this 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 all the contents of the article "what are the differences between mysql subtables and partitions". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.