MySQL Forums
Forum List  »  InnoDB

Re: How to reduce ibtmp1 file in mysql 5.7?
Posted by: Peter Brawley
Date: April 14, 2016 08:49AM

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.

Options: ReplyQuote

Written By
Re: How to reduce ibtmp1 file in mysql 5.7?
April 14, 2016 08:49AM

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.