executing unnecessary alters operation
-
The MySQL DB session is executing the query below.
ALTER TABLE
wp_statistics_visitor
CHANGEID
ID
BIGINT(20) NOT NULL AUTO_INCREMENTMySQL 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: 1recommend use BIGINT, deprecated bIGINT(nnn)
Alter does not help.
And the id column is the pk column.
alter operation is making very heavy loadAn 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.