I have here a couple of MySQL DB tables optimised with partitioning as in:
ALTER TABLE radpostauth PARTITION BY HASH(id) PARTITIONS 32;
With the upgrade do MySQL 5.7, the following warning started appearing in the error logs:
The partition engine, used by table 'y.radpostauth', is deprecated and will be removed in a future release. Please use native partitioning instead.
I have an idea I can do an
ALTER TABLE REBUILD however, no clue about what to do to make it compliant to 5.7 and beyond.
What do you advise?