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
4240
April 04, 2016 12:51PM
2931
April 04, 2016 05:48PM
9434
April 08, 2016 12:38AM
2464
April 08, 2016 09:38AM
Re: How to reduce ibtmp1 file in mysql 5.7?
3166
April 08, 2016 01:53PM
1952
April 08, 2016 03:43PM
1864
April 09, 2016 02:57PM
1843
April 09, 2016 03:09PM
10841
April 11, 2016 01:39AM
2625
April 11, 2016 11:42AM
2205
April 14, 2016 04:50AM
3821
April 14, 2016 08:49AM
2494
April 20, 2016 07:18AM
3005
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.