Tables with BLOB and TEXT columns cannot be partitioned
Partitioning allows easier management of smaller data sets for certain queries
Partitioning allows different columns to be stored in separate files
The partitioning expression is an integer or function that returns an integer value or NULL value
Partitioning is only available for those storage engines that implements it natively