Fixing Misplaced Rows in a Partitioned Table
Percona
MARCH 29, 2023
ALTER employees.salaries ENGINE=Innodb; One can also use pt-online schema change to recreate the table, which will not lock the table and have other benefits ( Using Percona Toolkit to Alter Database Tables Online: A Controlled Approach ) as well. sec) But once the data is misplaced, it does not return any rows.
Let's personalize your content