Follow Techotopia on Twitter

On-line Guides
All Guides
eBook Store
iOS / Android
Linux for Beginners
Office Productivity
Linux Installation
Linux Security
Linux Utilities
Linux Virtualization
Linux Kernel
System/Network Admin
Scripting Languages
Development Tools
Web Development
GUI Toolkits/Desktop
Mail Systems
Eclipse Documentation

How To Guides
General System Admin
Linux Security
Linux Filesystems
Web Servers
Graphics & Desktop
PC Hardware
Problem Solutions
Privacy Policy




17.4. Restrictions and Limitations on Partitioning

This section discusses current restrictions and limitations on MySQL partitioning support, as listed here:

  • Partitioned tables do not support foreign keys. This includes partitioned tables employing the InnoDB storage engine.

  • Partitioned tables do not support FULLTEXT indexes.

  • Partitioned tables do not support GEOMETRY columns.

  • Partitioned tables may use any available MySQL storage engine; however, all of the table's partitions and subpartitions (if there are any of the latter) use the same engine.

  • A partitioning key must be either an integer column or an expression that resolves to an integer. Currently, NULL values are also permitted; however, this is subject to change.

  • Subpartitions are limited to HASH or KEY partitioning.

  Published under the terms of the GNU General Public License Design by Interspire