As of MySQL 5.7.17, the generic partitioning handler in the MySQL
server is deprecated, and is removed in MySQL 8.0, when
the storage engine used for a given table is expected to provide
its own (“native”) partitioning handler. Currently,
only the InnoDB and
NDB storage engines do this.

Use of tables with nonnative partitioning results in an
ER_WARN_DEPRECATED_SYNTAX warning.
In MySQL 5.7.17 through 5.7.20, the server automatically performs
a check at startup to identify tables that use nonnative
partitioning; for any that are found, the server writes a message
to its error log. To disable this check, use the
--disable-partition-engine-check
option. In MySQL 5.7.21 and later, this check is
not performed; in these versions, you must
start the server with
--disable-partition-engine-check=false,
if you wish for the server to check for tables using the generic
partitioning handler (Bug #85830, Bug #25846957).

To prepare for migration to MySQL 8.0, any table with
nonnative partitioning should be changed to use an engine that
provides native partitioning, or be made nonpartitioned. For
example, to change a table to InnoDB, execute
this statement:

ALTER TABLE table_name ENGINE = INNODB;

You can determine whether your MySQL Server supports partitioning by
checking the output of the SHOW
PLUGINS statement, like this:

In either case, if you do not see the partition
plugin listed with the value ACTIVE for the
Status column in the output (shown in bold text
in each of the examples just given), then your version of MySQL was
not built with partitioning support.

If your MySQL binary is built with partitioning support, nothing
further needs to be done to enable it (for example, no special
entries are required in your my.cnf file).

If you want to disable partitioning support, you can start the MySQL
Server with the --skip-partition
option. When partitioning support is disabled, you can see any
existing partitioned tables and drop them (although doing this is
not advised), but you cannot otherwise manipulate them or access
their data.

This is the official discussion forum for those interested in or
experimenting with MySQL Partitioning technology. It features
announcements and updates from MySQL developers and others. It
is monitored by members of the Partitioning Development and
Documentation Teams.

A MySQL news site featuring MySQL-related blogs, which should be
of interest to anyone using my MySQL. We encourage you to check
here for links to blogs kept by those working with MySQL
Partitioning, or to have your own blog added to those covered.