MySQL Forums
Forum List  »  InnoDB

Re: How to reduce ibtmp1 file in mysql 5.7?
Posted by: Magi Home
Date: April 08, 2016 01:53PM

Current database: information_schema
mysql> show variables like 'innodb_temp_table_info';
Empty set (0,01 sec)

in mysqld.cnf
innodb_temp_data_file_path = ibtmp1:12M:autoextend

# ls -l ibtmp1
-rw-r----- 1 mysql mysql 1019215872 апр. 8 22:16 ibtmp1

ls -l ibtmp1
-rw-r----- 1 mysql mysql 2092957696 апр. 8 22:24 ibtmp1
# ls -l ibtmp1
-rw-r----- 1 mysql mysql 4844421120 апр. 8 22:27 ibtmp1
ls -l ibtmp1
-rw-r----- 1 mysql mysql 6320816128 апр. 8 22:32 ibtmp1
ls -l ibtmp1
-rw-r----- 1 mysql mysql 9676259328 апр. 8 22:45 ibtmp1

mysql> show variables like 'innodb_temp_table_info';
Empty set (0,00 sec)

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: How to reduce ibtmp1 file in mysql 5.7?
2429
April 08, 2016 01:53PM


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.