Re: How to reduce ibtmp1 file in mysql 5.7?
You didn't make a 5.6 backup before trying to upgrade in place, so there's no going back to that point?
Those mysql.plugin entries suggest that a previous upgrade also went awry. In 5.6 and 5.7, those engines are not plugins. To get rid of those plugin load errors, rename mysql.plugins to, say, mysql.pluginsold, and create a copy of the plugins table with no rows.
> innodb_temp_data_file_path = ibtmp1:12M:autoextend:max:512M
> If you remove the limitation to 512 M, the file fills
> all the available space in a few minutes.
When you get that error, ibtmp fills the disk? Or fills the folder space? Puzzling. And still information_schema.innodb_temp_table_info is empty? I don't understand.