Re: How to reduce ibtmp1 file in mysql 5.7?
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;
Subject
Views
Written By
Posted
5071
April 04, 2016 12:51PM
3080
April 04, 2016 05:48PM
9854
April 08, 2016 12:38AM
2626
April 08, 2016 09:38AM
3399
April 08, 2016 01:53PM
2079
April 08, 2016 03:43PM
2025
April 09, 2016 02:57PM
1976
April 09, 2016 03:09PM
11311
April 11, 2016 01:39AM
Re: How to reduce ibtmp1 file in mysql 5.7?
2785
April 11, 2016 11:42AM
2336
April 14, 2016 04:50AM
4200
April 14, 2016 08:49AM
2661
April 20, 2016 07:18AM
3166
April 20, 2016 11:48AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.