In the commit 3b4b512d8e42bb3d33cf78789754cd10ff310646, Marko made the comment:
To truncate such "contaminated" or "bloated" undo log tablespaces (when using innodb_undo_tablespaces=2 or more) you can execute the following SQL:
|
BEGIN;INSERT mysql.innodb_table_stats VALUES('','',DEFAULT,0,0,0);ROLLBACK;
|
SET GLOBAL innodb_undo_log_truncate=ON, innodb_fast_shutdown=0;
|
SHUTDOWN;
|
The first line creates a dummy InnoDB transaction, to ensure that there will be some history to be purged during shutdown and that the undo tablespaces will be truncated.
Sure, its not the full ibdata1 space, but might be what you need.
Task
Major
In the commit 3b4b512d8e42bb3d33cf78789754cd10ff310646, Marko made the comment:
SHUTDOWN;Sure, its not the full ibdata1 space, but might be what you need.