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?
PARTITION BY HASH
is useless. What are you hoping to achieve?SHOW CREATE TABLE
; and a query that you think will benefit from the partitioning. I should be able to explain further from those.