Re: How to reduce ibtmp1 file in mysql 5.7?

[Peter Brawley]

Looks like a botched upgrade.

For upgrades across major versions, we're supposed to mysqldump existing data, install the new version, then load the dump file script into the new installation instead of trying to reuse existing data files and folders. The installer often forces this issue by ignoring the current defaults-file and datadir settings, thus hiding existing data from the new installation.

You didn't do this? You just ran mysql_upgrade? How did you persuade 5.7 to use 5.6 data?

Have you tried running mysql_upgrade again?

To redo the upgrade, you'd need a 5.6 data backup and a binary log of what's changed since the upgrade. You have neither? Fixing this mess will be a slog.

What is the result of ...

select * from mysql.plugin;