MySQL IBTMP1 reclaim space

About IBTMP1 recovery space only restart the database, a little pit ah ah Ah!

[[email protected] data]# ls-lhtotal 7.6g-rw-r-----1 mysql mysql-Jul 17:22 auto.cnf-rw-r-----1 mysql MySQL 142K Jul 16:56 ib_buffer_pool-rw-r-----1 mysql mysql 12M Jul 17:15 ibdata1-rw-r-----1 mysql mysql 32M Jul 18 17 : ib_logfile0-rw-r-----1 mysql mysql 32M Jul 17:15 ib_logfile1-rw-r-----1 mysql mysql 32M Jul 17:15 ib_logfile   2-rw-r-----1 mysql mysql 5.7G Jul 17:15 ibtmp1drwxr-x---2 mysql mysql 4.0K Jul 17:22 mysql-rw-r-----1 mysql MySQL 177 Jul 17:22 mysql-bin.000001-rw-r-----1 mysql mysql 7.7K Jul 19:37 mysql-bin.000002-rw-r-----1 mysql mysql 47 9 Jul 19:49 mysql-bin.000003-rw-r-----1 mysql mysql 177 Jul 16:56 mysql-bin.000004-rw-r-----1 mysql mysql 432 Ju L 17:15 mysql-bin.000005-rw-r-----1 mysql mysql 16:57 mysql-bin.index-rw-r-----1 mysql mysql 5 Jul 18 16:57 mysql.piddrwxr-x---2 mysql mysql 4.0K Jul 17:22 performance_schemadrwxr-x---2 mysql mysql 12K Jul 17:22 sys Drwxr-x---2 mysql mysql 4.0K Jul 18:20 test-rw-r-----1 mysql mysql 556M Jul 17:15 undo001-rw-r-----1 mysql mysql 1.1G Jul 17:15 undo00 2-rw-r-----1 mysql mysql 228M 17:15 undo003[[email protected] data]#/usr/local/mysql/bin/mysql-uroot-pente  R Password:welcome to the MySQL Monitor. Commands End With;  or \g.your MySQL connection ID is 4Server version:5.7.19-log mysql Community Server (GPL) Copyright (c), Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names trademarks of their respectiveowners. Type ' help ', ' or ' \h ' for help. Type ' \c ' to clear the current input statement.mysql> shutdown; Query OK, 0 rows affected (0.01 sec) mysql> exitbye[[email protected] data]#/usr/local/mysql/bin/mysqld_safe-- DEFAULTS-FILE=/ETC/MY.CNF &[1] 11533[[email protected] data]# 2018-07-18t09:23:59.089943z mysqld_safe Logging to '/mysql/log/mysql-error.log '. 2018-07-18t09:23:59.113955Z Mysqld_safe starting mysqld daemon with databases from/mysql/data[[email protected] data]# [[Email  protected] data]# ls-ltotal 2060504-rw-r-----1 mysql mysql, Jul 17:22 auto.cnf-rw-r-----1 mysql mysq   L 131100 Jul 17:23 ib_buffer_pool-rw-r-----1 mysql mysql 12582912 Jul 17:23 ibdata1-rw-r-----1 mysql MySQL 33554432 Jul 17:23 ib_logfile0-rw-r-----1 mysql mysql 33554432 Jul 17:24 ib_logfile1-rw-r-----1 mysql MySQL 3  3554432 Jul 17:15 ib_logfile2-rw-r-----1 mysql mysql 12582912 Jul 17:23 ibtmp1drwxr-x---2 mysql mysql 4096 Jul 17:22 mysql-rw-r-----1 mysql mysql 177 Jul 17:22 mysql-bin.000001-rw-r-----1 mysql mysql 7846 Ju        L 19:37 mysql-bin.000002-rw-r-----1 mysql mysql 479 Jul 19:49 mysql-bin.000003-rw-r-----1 mysql MySQL 177 Jul 16:56 mysql-bin.000004-rw-r-----1 mysql mysql 455 Jul 17:23 mysql-bin.000005-rw-r-----1 MySQL Mys QL 154 Jul 17:23 mysqL-bin.000006-rw-r-----1 mysql mysql 17:23 mysql-bin.index-rw-r-----1 mysql MySQL 6 Jul 18 17: Mysql.piddrwxr-x---2 mysql mysql 4096 Jul 17:22 performance_schemadrwxr-x---2 mysql mysql 12288 Jul 17 17:22 sysdrwxr-x---2 mysql mysql 4096 Jul 18:20 test-rw-r-----1 mysql mysql 583008256 Jul 17:23 undo001-rw- R-----1 mysql mysql 1161822208 Jul 17:23 undo002-rw-r-----1 mysql mysql 239075328 Jul 17:23 undo003[[email p Rotected] data]# ls-lhtotal 2.0g-rw-r-----1 mysql mysql, Jul, 17:22 auto.cnf-rw-r-----1 mysql mysql 129K Jul 18 1 7:23 ib_buffer_pool-rw-r-----1 mysql mysql 12M Jul 17:24 ibdata1-rw-r-----1 mysql mysql 32M Jul 17:24 ib_logfile 0-rw-r-----1 mysql mysql 32M Jul 17:24 ib_logfile1-rw-r-----1 mysql mysql 32M Jul 17:15 ib_logfile2-rw-r-----1 mysql mysql 12M Jul 17:24 ibtmp1drwxr-x---2 mysql mysql 4.0K Jul 17:22 mysql-rw-r-----1 mysql mysql 177 Jul 17 1 7:22 MYSQL-BIN.000001-RW-r-----1 mysql mysql 7.7K Jul 19:37 mysql-bin.000002-rw-r-----1 mysql mysql 479 Jul 19:49 mysql-bin.000003-rw-r-- ---1 mysql mysql 177 Jul 16:56 mysql-bin.000004-rw-r-----1 mysql mysql 455 Jul 17:23 mysql-bin.000005-rw-r----- 1 mysql mysql 154 Jul 17:23 mysql-bin.000006-rw-r-----1 mysql mysql 17:23 mysql-bin.index-rw-r-----1 Mys  QL MySQL 6 Jul 17:23 mysql.piddrwxr-x---2 mysql mysql 4.0K Jul 17:22 performance_schemadrwxr-x---2 mysql mysql 12K Jul 17:22 sysdrwxr-x---2 mysql mysql 4.0K Jul 18:20 test-rw-r-----1 mysql mysql 556M Jul 17:23 undo001-rw- R-----1 mysql mysql 1.1G Jul 17:23 undo002-rw-r-----1 mysql mysql 228M Jul 17:23 undo003[[email protected] Da  ta]#

MySQL IBTMP1 reclaim space