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)
Subject
Views
Written By
Posted
5081
April 04, 2016 12:51PM
3080
April 04, 2016 05:48PM
9856
April 08, 2016 12:38AM
2627
April 08, 2016 09:38AM
Re: How to reduce ibtmp1 file in mysql 5.7?
3399
April 08, 2016 01:53PM
2079
April 08, 2016 03:43PM
2028
April 09, 2016 02:57PM
1977
April 09, 2016 03:09PM
11312
April 11, 2016 01:39AM
2786
April 11, 2016 11:42AM
2336
April 14, 2016 04:50AM
4201
April 14, 2016 08:49AM
2662
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.