The concept of partitioning relates to the physical aspects of data storage in the database. If you look at the SQL standards, they do not give much information on the concept, and the SQL language itself intends to work independently of which media or data structure is used for storing information or data specific to different schemas, tables, rows, or columns. Advanced database management systems have added means of specifying the physical location used for data storage as hardware, the file system, or as both. In MySQL, the InnoDB storage engine provides support for these purposes with the notion of tablespace.
Partitioning enables us to distribute parts of individual tables to be stored as separate tables at different locations in the file system. Additionally, the distribution is accomplished with user specified rules provided, such as in the form...
