• The MySQL DB session is executing the query below.

    ALTER TABLE wp_statistics_visitor CHANGE ID ID BIGINT(20) NOT NULL AUTO_INCREMENT

    MySQL 8.0 is occur warning
    0 row(s) affected, 1 warning(s): 1681 Integer display width is deprecated and will be removed in a future release. Records: 0 Duplicates: 0 Warnings: 1

    recommend use BIGINT, deprecated bIGINT(nnn)

    Alter does not help.
    And the id column is the pk column.
    alter operation is making very heavy load

    An update is required immediately.

Viewing 1 replies (of 1 total)
Viewing 1 replies (of 1 total)
  • The topic ‘executing unnecessary alters operation’ is closed to new replies.